SQL Server Data Tools (a.k.a. SSDT) used to part of product installation media in SQL Server 2012. We can install it by selecting "SQL Server Data Tools" from shared features section. Alternately we can install it using SQL Server 2012 setup ...read more

I originally encountered this issue back in May with a customer.  We had another customer this month that had the same issue.  When you try to load an Excel Document with a Power View Report in it from SharePoint, you may encounter the default ...read more

Hi Everyone, Today I’m going to highlight one of the changes brought by SQL Server 2012 SP2 , which is the way we handle VSS Backup requests on AlwaysOn Secondary Databases . Until now, any request for a FULL database backup (VSS_BT_FULL) thru VSS against ...read more

In a previous blog , I talked about how table variable can impact performance of your query. The reason is that the statements referencing the table variable are compiled when the table variable has no data in it. Therefore, cardinality estimate for the ...read more