Microsoft Security Bulletin MS12-070 for SSRS

Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...

Multilanguage Table, How to insert different language text in table ?

Issue :
Today, I received one request from my old friend.
He wants to insert text in different languages in table. He...

Office 2013 BI and Mobility

I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about...

Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT

When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to...

Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT

When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data...

SQL Saturday #145 Nashville – Recap

This month has been wild. I’ve been out of town quite a bit for work, and started the month with...

Using SQL Server 2012 FileTables

Reblogged from Basit's SQL Server Tips:

SQL Server 2012 allows you to store file/directories in a special table called FileTable that...

Database Design Contest at the 2012 AITP Region 3 Student Conference

Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette.  31 different teams submitted database...

SQL Server # TSQL to Convert STRING in PROPER format

Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...

When a Covering Index no longer covers

I received an email from my boss on the morning supervisors approve timesheets. He stated that they are complaining about...