Debugging query timeouts with X-Events – part 1

I like hunting. Not the kind where you are walking around the forrest and trying to find a target. No,...

SQL Saturday #110 - Tampa - The Dirty Business of Auditing Presentation Materials

For those who might want the materials for my presentation at SQL Saturday #110, I've posted them to the site.
 
SQL...

A Little Feature Self-Deprecation

The buzz started yesterday, with the rumblings about Database Mirroring showing up on the "Features Not Supported in a Future...

Database Mirroring Deprecated in SQL 2012

From the newly released SQL 2012 Books Online documentation:

This note shows that as of SQL Server 2012, which will be...

Deprecated Features in the SQL Server 2012 Database Engine

As you might know, Microsoft has released on March 7 the RTM version of SQL Server
2012. If you are an...

Execution Plans – Nested Loop

The nested loop is a physical operator used to join 2 or more sets of data when the query optimizer...

Re-blog – March 2 – March 8

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

SC Midlands Chapter of ISACA - SQL Server Auditing Course Materials

If you attended my SQL Server Auditing course held for the SC Midlands Chapter of ISACA, I finally was able...

SQL Roundup – 03/09/2012

Welcome to another week of SQL Roundup. Just in case you missed, SQL Server 2012 was released this week and...

SQL Server - Kerberos and KRB_AP_ERR_MODIFIED

On a routine scan of Event Viewer System, Logs I found this message on 4 different servers  hosting SQL Server...