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

Test Post – Please ignore

I’m just testng out my new laptop making sure things are working as they should

The Next Phase of My Career

For anyone who hasn't seen an update somewhere else in the social media universe, I recently started a new job...

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

A Tour of the Transaction Log: Part 3 Reading Log Backups

In part one and two of our Tour of the Transaction Log articles we focused on reading events from the...

Checking your users and groups in Command Window.

As a DBA, I work closely with the Infra guys to manage domain accounts. Now and then, there comes a...

Fill Factor, Why Do You Taunt Me? Part 1

Like all the arbitrary numbers we hear in the SQL community such as the 30% fragmentation and 1000 pages. These...

Friday Followup For November 15, 2013

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...