Schema Switch-A-Roo : Part 2
I go into a little more detail about what happens to metadata when you use schema transfers behind the scenes.
Monthly Archive: April 2013
Troubleshooting AlwaysOn – Sometimes it takes many sets of eyes
I discuss some obstacles he recently encountered when configuring an Availability Groups lab environment and how some assistance from the community helped me isolate and solve the issues.
How filtered indexes could be a more powerful feature
I explore a couple of advantages and a hefty list of limitations with filtered indexes in SQL Server 2008 and above, with links to no less than 36 Connect items.
April 2013 Cumulative Updates for SQL Server 2008 R2
Today Microsoft released new cumulative updates for SQL Server 2008 R2. SQL Server 2008 R2 Service Pack 1 Cumulative Update # 12 KB Article: KB #2828727 7 fixes listed at time of publication Build...
SQL Server 2012 Cumulative Update #7 is available!
The SQL Server team has released CU #7 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2823247 Build # is 11.0.2405 This build has 17 fixes Relevant for builds 11.0.2100 -> 11.0.2404. Do not attempt to...
SQLintersection slide decks
I gave two talks at the SQLintersection conference this week in Las Vegas. One was my Bad Habits & Best Practices session, and the other is a new one discussing advantages to upgrading to...
Microsoft Announces SQL Server 2012 R2 and SQL Server 2012 R3!
Microsoft announced today that their next two major releases, each of which contains a major performance-related feature, will follow a naming strategy similar to the 2008 -> 2008 R2 story. Read on for more…