Monthly Archives: March 2015

What are AlwaysOn Availability Groups?

The most exciting feature that came out of the SQL Server 2012 release was AlwaysOn Availability Groups (AG). Even through AG has received a lot of publicity, there are many people who haven’t used it or may not even know what … Continue reading

Posted in High Availability | Leave a comment

New article on SQL Authority: Avoiding duplicate indexes

Without fail, when I am asked to look at indexes for a customer, I see duplicate and overlapping  indexes. While you may think this is not a big deal, (more indexes are better, right?) there are many performance implications. My latest … Continue reading

Posted in SQL Server Administration | Leave a comment

New Book on T-SQL Window Functions!

I am very pleased to announce that my new book “Expert T-SQL Window Functions in SQL Server” is now available! This book covers everything I talk about in my two window function presentations plus even more material. I am also thrilled … Continue reading

Posted in T-SQL Window Functions | 13 Comments