Monthly Archives: March 2010

Intel Xeon 7500 Series aka Nehalem-EX

Intel has finally released the long awaited (at least by me) 45nm Xeon 7500 series processor. This beast has eight cores, plus hyper-threading and turbo boost, and 24MB of shared L3 cache. It also supports up to 16 DDR3 memory … Continue reading

Posted in Computer Hardware | 2 Comments

SQL Server 2008 Database Mirroring: It takes a licking but it keeps on ticking!

With apologies to Timex, I just wanted to relate a minor incident that happened with one of my mirrored databases last night. This database needed to grow its primary data file, and the autogrow amount was set to 5GB ( … Continue reading

Posted in SQL Server 2008 | 1 Comment

Using Custom Connection Colors in SSMS

One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was continued in SQL Server 2008 R2, is the ability to set custom connection colors for individual instances of SQL Server. … Continue reading

Posted in SQL Server 2008 R2 | 9 Comments

To Get Certified or Not Get Certified

I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think that getting a Microsoft certification is a good thing. It proves that you have at least a certain level of … Continue reading

Posted in Teaching | 10 Comments

Recovery Models and Backup Strategies for SQL Server 2008

I had a question via e-mail from one of my new students at University of Denver, University College this morning, asking why the transaction log on one of his SQL Server databases seemed to fill up so quickly, and then … Continue reading

Posted in SQL Server 2008 | 1 Comment

Creating SQL Server 2008 Databases with T-SQL

Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file system laid out. You can take advantage of the fact that SQL Server keeps track (at the instance level) of … Continue reading

Posted in SQL Server 2008 | 4 Comments

Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server

I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a clustered index in SQL Server. After all, on the surface that sounds like a good choice, since a UniqueIdentifier is … Continue reading

Posted in SQL Server 2008 | 7 Comments