Consolidating Multiple Data Marts

One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering.  The BI group at CHC used to assign specific...

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

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

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

Consolidating Multiple Data Marts

One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering. ...

#PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer

Power BI Desktop has been out for GA for over a week now and some of the pro’s out there...

Windows 10 Upgrade on Surface Pro 3 – Sending email issue FIXED

I very rarely blogabout anything other than SQL Server but felt that with a lot of the SQL Community using...

SQL Server GEEKS Annual summit 2015

Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit...

Monday Morning SQL Break – July 27, 2015

It’s past time for the Monday blog and twitter round-up for last week, but better late than never (or not)....