The SSIS Object Variable and Multiple Result Sets

In my most recent post in this series, I talked about how to use the SSIS object variable as an...

Upcoming SQL Saturday Precon Sessions

I have two exciting SQL Saturday preconference training sessions coming up in the month of May!
The first is my Virtualization...

What SQL version is my SSIS package?

When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how...

Hi Folks,

Hope you all are doing good. Would like to start with praying for all those who have been affected...

How to send E-mail/E-mail with Attachments in SQL Server TIP #97

 
In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail...

Microsoft DataZen Mobile Platform Available to Enterprise Customers for Free

Last week Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...

Microsoft DataZen Mobile Platform Available to Enterprise Customers for Free

Last week Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise...

Rebuild a Standard Table to a Partitioned Table

[read this post on Mr. Fox SQL blog] I have been working on a SQL DW database and revisiting an existing SQL table partitioning scheme.  The main reasons we’re going to...

Rebuild a Standard Table to a Partitioned Table

[read this post on Mr. Fox SQL blog]
I have been working on a SQL DW database and revisiting an existing SQL table...

Speaking at NT Conference 2015 in Slovenia

It is always feels like a great honour to be invited to speak at a big conference, but when this...