SSIS Execute SQL error – No disconnected record set is available

If you get the error in SSIS that says:

…failed with the following error: “No disconnected record set is available for...

I’m speaking at SQL Server Saturday #233 – Washington DC!

It’s that time of the year again when SQL Saturday makes its way back to the Washington DC Area. Here...

SQL Server – Custom sorting in ORDER BY clause

ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...

SQL Server – Custom sorting in ORDER BY clause

ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...

SQL Server – Custom sorting in ORDER BY clause

ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...

Power Pivot Synonyms

A little gem was included with the latest Office 365 update.  After downloading and installing this update you will now find...

Fill Factor, Why Do You Taunt Me? Part 2

So Friday we were discussing the idea of an idea. I think... or an idea of an idea's idea. What...

70-457 Reviewer #16 Implement AlwaysOn in SQL Server 2012

This reviewer is still part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of...

Chicago SQL Server Users Group Wrapup

Thursday night I had a great time presenting my session entitled “Squeezing Top Performance from Your Virtualized SQL Server” to...

Superpowers Revealed

Like many of you out there, I’m constantly looking for new things to learn. A new skill, a new hobby,...