Monthly Archives: March 2012

Three Sessions at Spring 2012 Connections Conference

I will be a busy little beaver today, presenting three sessions at the Spring 2012 Connections Conference, the first one at 8AM! Hopefully enough people will be able to get up by then and join me. It should be a … Continue reading

Posted in Computer Hardware, Microsoft Training, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, Storage Subsystems | Tagged | 9 Comments

SQL Server 2008 Diagnostic Information Queries (April 2012)

Since it is nearly April, I will go ahead and jump the gun again and post an updated version of my SQL Server 2008 Diagnostic Information Queries. This version works on SQL Server 2008 and SQL Server 2008 R2. There … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 11 Comments

SQL Server Database Mirroring Tips and Tricks, Part 3

One of the challenges you face with SQL Server database mirroring is making sure that all of the databases that are dependent on each other will failover together, so they are running on the same side of the database mirroring … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 12 Comments

Microsoft DreamSpark Program

Back in 2008, Microsoft rolled out the DreamSpark program as a means to get Microsoft software design and development tools in the hands of students at no charge. It was initially only for university or college students, but it has … Continue reading

Posted in Microsoft | Tagged | Leave a comment

SQL Server Database Mirroring Tips and Tricks, Part 2

If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common ways to do it involves creating certificates on each instance, creating logins and users for those certificates, and copying the … Continue reading

Posted in Microsoft, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 1 Comment

Microsoft Releases SQL Server 2008 SP3 Cumulative Update 4

Microsoft has also released SQL Server 2008 SP3 Cumulative Update 4. This is Build 10.00.5775.00, and it has ten fixes listed in the public fix list. Remember, this Cumulative Update is only for SQL Server 2008 SP3. It will not … Continue reading

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment

Microsoft Releases SQL Server 2008 SP2 Cumulative Update 9

Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has seven fixes listed in the public fix list. Remember, this Cumulative Update is only for SQL Server 2008 SP2. It … Continue reading

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment