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

SQL Server Database Mirroring Tips and Tricks, Part 1

Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique that should work perfectly well for at least two-three major versions of SQL Server after the newly released SQL Server … Continue reading

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

SQL Server Database Mirroring (Not Dead Yet)

SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL Server 2005, and enabled without a trace flag in SQL Server 2005 SP1. It was enhanced in SQL Server 2008 … Continue reading

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

Intel Xeon E5-2600 Series Processors Released

Yesterday, Intel finally released the much anticipated Xeon E5-2600 family of processors, also known as Sandy Bridge-EP. This is a Tock release for Intel (which means a new microarchitecture) that still uses the same 32nm manufacturing process as the previous … Continue reading

Posted in Computer Hardware, Processors, SQL Server 2012 | Tagged , | Leave a comment