Teaching the Maintaining SQL Server 2005 class tonight. Week 2 – Database Design, Normalization, Analyzing Capacity Needs, Service Broker Here is the slide deck for… Read More »Database Design, Normalization, Analyzing Capacity Needs, Service Broker
Teaching the SQL SERVER SPECIALIST CERTIFICATE PROGRAM – Maintaining SQL Server 2005 Class Tonight. Week1 Here is the slide deck for the class tonight. DBA_Essentials_Class01_Installation… Read More »Installing / Configuring SQL Server 2005
The question came up as to which version of sql server is being run, and how do you determine the exact version number of the… Read More »Determining the version of SQL server from TSQL
Tonight I created the Questions and Answers website. My wife was watching Mamma Mia (the movie), and that lost my interest quickly so I went… Read More »Questions and Answers Website.
I have just finished all of the paperwork. For spring quarter 2009, I will be teaching a SQL Server DBA class at Western Washington University.… Read More »On to a new adventure – Teaching SQL Server
SQL Server 2008 introduces a new feature called Filtered Index. A filtered index is a way of adding a WHERE clause to the index definition… Read More »SQL Server 2008 – Filtered Indexes
The biggest benefit that I see with the new backup compression in SQL Server 2008 is that it improves the speed of the restore. The… Read More »SQL Server 2008 – Backup Compression
In SQL Server, an empty or a null column still would take up space in the database, so even if you added a column that… Read More »SQL Server 2008 – Sparse Columns
Tonight I had the opportunity to present to the Bellingham .NET users group. About 30 people showed up for the presentation. SQL Server Performance… Read More »SQL Server Performance Tuning for the Bellingham .NET users group
The following applies to SQL Server 2008. How big of an allocation does max represent in the case of varchar(max) and varbinary(max)? Up to 2… Read More »varchar(max) and varbinary(max) Questions and Answers