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...

SQL Server 2012 (“Denali”): Power View installation and requirements

Power View is installed when you run the SQL Server 2012 install and on the Feature Selection page choose “Reporting...

SSAS Tabular Model – Query Modes

One of the most compelling features of the new SSAS Tabular Model is the ability to set the model’s Query...