Execution Plans – Nested Loop

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

Why Support WIT

First, only support Women in Technology if you want to. It’s an idea that appeals to some, but not to...

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

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

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

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

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

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

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

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