Windows Hot Fix makes SQL 2012 AG’s fail over faster
Microsoft has recently released hot fix 388724 under MS KB 2687741 which resolves a performance issue when failing over a SQL Server 2012 Availability Group from one replica to another. The basic jist of the problem is that there was an issue with the inter-node communication within the Windows cluster which caused the AG to […]
AlwaysOn and your application source code
One of the things that people will need to change to their applications when using AlwaysOn under SQL Server 2012 will be that the applications will need to have retry logic added to the application so that if the SQL Server is down that the application can retry the connection. Now this shouldn’t be anything […]
Storage and Virtualization in Poland May 24
Come and join me in Poland, May 24th, 2012 (24-05-2012) at SQL Day 2012. During this day long session we will be looking at storage and virtualization from a DBA perspective with the end goal of the day being to improve the your knowledge of enterprise storage and enterprise virtualization. While we won’t be looking […]
SQL Saturday 111 Slide Decks
I’ve uploaded my slide decks from SQL Saturday 111. The sessions can be found on the session pages for the two sessions. I gave two sessions at SQL Saturday 111 in Atlanta, GA. The first was index internals and the second was SQL Server Table Partitioning. I had a great time at SQL Saturday 111 […]