(Allen White) I’ve mentioned before my company manages trade shows, and we’ve got a series of web sites managed by an application which uses a different SQL Server database for each site, with a master database (I’ll call it Global, to differentiate it from SQL Server’s master database). Well, we ha
Other News
SqlCredit – Part 12: Exploring Indexed Persisted Computed Columns
(Rob Garrison) SQL Server 2005 adds the option of “persisting” a computed column. Prior to SQL Server 2005, you could create a computed column, but it would not be stored on disk and could not be indexed. If a computed column was not persisted, it would be recalculated each time it is accessed, so y
Virtual Columns in Oracle 11g
Virtual columns is a new feature in Oracle 11g. This is something that is already available in SQL Server and DB2 LUW albeit with a different name. You can read more about computed columns (virtual columns) in one of our previous blog post here. In Oracle 10g and prior releases, the only way we can
Gathering I/O statistics down to the database file level
When managing your SQL Server environment there are many aspects that need to be reviewed to determine where the bottlenecks are occurring to ensure you are getting the best performance possible. SQL Server offers many great tools and functions to determine issues with locking, blocking, fragmentat
SQL Server 200x and Software Assurance – What Is The Answer?
New SelectViews Show Posted Need your help and opinion on a question in the show! We’ve just posted this week’s SelectViews show – I’m headed up to Microsoft later in the week and wanted to make sure we got the show out for you. Open source feedback, the SQL Server 2008 Slip, the 60-second SQL Server tip of the day […]
SelectViews SQL Server Show Posted, SQL Server 2008
New SelectViews Show Posted Need your help and opinion on a question in the show! We’ve just posted this week’s SelectViews show – I’m headed up to Microsoft later in the week and wanted to make sure we got the show out for you. Open source feedback, the SQL Server 2008 Slip, the 60-second SQL Server tip of the day […]
Receive events from XMLBeans
(Jacob D. Eisinger and Vince C. Brunssen) XMLBeans is a great XML-to-Java data-binding technology, but it lacks the ability to register observers for model changes. However, you can customize generated plain old Java objects (POJOs) to include the necessary interfaces and the notification of changes
Overview of the ASP.NET Framework
(Stephen Walther) If you are using Visual Web Developer or Visual Studio, you first need to create a new website. Start Visual Web Developer and select the menu option File, New Web Site. The New Web Site dialog box appears (see Figure 1.1). Enter the folder where you want your new website to be cre
Using Web User Controls in Repeaters and DataList
(Mike Clark) The ASP.Net data bound DataList and Repeater controls give us the ability to create flexible HTML layouts for tabular and XML hierarchal data. However, when you throw in a need for conditional logic or some string formatting or perhaps the need to edit/update the data, things get compli
Use IBM Rational Data Architect to model your Oracle databases
(Anson Kokkat) Find out why IBM Rational Data Architect is gaining momentum as a database modeling tool that is optimized for IBM databases, yet also provides functionality to model other major database vendors such as Oracle. Look at alternatives to Oracle Designer, and see how keeping up with Orac