Create Several Shell SSIS Packages In Minutes Using BIML

What do i mean by shell packages? You’re spot on – that’s an excellent question to begin with. For the purpose...

Which SQL Instance is Killing Your CPU?

You have 5 instances running.  How do you know which one is killing your CPU?

As you can see from Windows...

SQL Server 2012 RTM Cumulative Update 4

Microsoft has released SQL Server 2012 RTM Cumulative Update 4, which is build 11.00.2383.0. By my count, there are 25...

SSAS #28 – Setup to Learn SSAS Stored Procedures

Having worked with SSAS for a while and done some reporting with MDX queries, I started to explore opportunities 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 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...

Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers

Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...

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

Lions and Tigers and Bears…

Last Thursday I found myself on a journey of sorts.  There weren’t any lions or tigers or bears, but there were plenty of “Oh My”‘s. It all began on...

Lions and Tigers and Bears…

Last Thursday I found myself on a journey of sorts.  There weren’t any lions or tigers or bears, but there...