Consuming the Output of an SSIS Package in a Client Application

Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting...

#tsql2sday #60 – Something New Learned – Problem Step Recorder

What is T-SQL Tuesday?

T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...

Summit 2014

It’s hard to believe it’s over.  It felt like a whirlwind while I was in Seattle for my 7th PASS...

How explicitly insert default value ? TIP #72

 
Suppose, sometimes you just need  entry in the table with all the default values.
For example you have a Student...

#SQLPASS #Summit14 Day 2 Keynote Highlights !

This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day...

Let’s get started

Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to...

Last Weeks Top “Reading” Links #108

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Expected Variables–T-SQL Testing

After I wrote about creating tables that contain the results I expected, I wondered if I could do the same...

Add Witness to Existing SQL Server Database Mirroring

1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2. Click Configure Security, Configure Database Mirroring Security...

Add Witness to Existing SQL Server Database Mirroring

1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2....