Downloading SFTP Files with SSIS

If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to...

Indexes on GUIDs – Not Only Fragmentation

A client called us with the following issue:
He had a table of a few dozen million rows. The table had...

Monday Morning SQL Break – August 3, 2015

It’s (finally) time for Monday’s weekly blog and twitter round-up for last week (it’s even on time). This post is...

Question of the Month (July)

Suppose we have a table emp_plan  which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:-

Create table emp_plan (empid nvarchar(200),planid...

Question of the Month (July)

Suppose we have a table emp_plan  which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate)....

Single instance vs. multiple instances of SQL Server on a server

Let`s consider a situation when you need to build a server with SQL Server used by multiple client applications. Here...

SQL Crossword

I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF...

SQL Server – Sparse Column Property using SELECT INTO

Hi friends, in our day to day work we used SELECT…INTO clause to create replica of a table for different...

Start SQL Server in Single User Mode

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Using the DAC

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...