Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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 lot of fun!

SQL301: Scaling SQL Server 2012
Glenn Berry

Read more

9 comments, 708 reads

Posted in Glenn Berry's SQL Server Performance on 29 March 2012

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 are a few queries that only work with SQL… Read more

10 comments, 410 reads

Posted in Glenn Berry's SQL Server Performance on 28 March 2012

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 partnership at all times.  There is no built-in support for… Read more

10 comments, 5,577 reads

Posted in Glenn Berry's SQL Server Performance on 27 March 2012

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 been expanded to also cover high school students. Basically, this… Read more

0 comments, 581 reads

Posted in Glenn Berry's SQL Server Performance on 21 March 2012

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 certificates back and forth between the instances. I will have… Read more

1 comments, 705 reads

Posted in Glenn Berry's SQL Server Performance on 21 March 2012

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 work on other Service Pack levels of SQL Server 2008,… Read more

0 comments, 3,077 reads

Posted in Glenn Berry's SQL Server Performance on 21 March 2012

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 will not work on other Service Pack levels of… Read more

0 comments, 965 reads

Posted in Glenn Berry's SQL Server Performance on 20 March 2012

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 2012. Microsoft’s deprecation language actually says that “the following… Read more

7 comments, 3,105 reads

Posted in Glenn Berry's SQL Server Performance on 12 March 2012

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 with features like log stream compression and automatic page repair,…

Read more

6 comments, 1,972 reads

Posted in Glenn Berry's SQL Server Performance on 7 March 2012

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 Xeon 5600 series (Westmere-EP). They will use the new Romley… Read more

0 comments, 702 reads

Posted in Glenn Berry's SQL Server Performance on 7 March 2012

CPU-Z 1.60 Released

Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors from both Intel and AMD, including the Ivy Bridge and Trinity lines.

Here you can see the CPU tab report for my Intel Core i5-2410M processor in my little… Read more

0 comments, 440 reads

Posted in Glenn Berry's SQL Server Performance on 4 March 2012