Bug In ado.net enumerator in foreach loop in SSIS 2012

Hi Greetings to everyone,

Today I am going to report a bug in SSIS 2012. In one of the packages I...

Lost Administrator SA password SQL server 2012

AdvertisementsThere are many blog posts talking about, how to recover “SysAdmin” password in case if it’s lost OR the server...

Cumulative Update – 1 for SQL Server 2012 Service Pack 2 Is Now Available !

The 1st cumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft...

SQLSaturday Porto Edition 2014 Selection Process Results & Voting

This blog post is a continuation of the initial announcement almost a month ago about the session selection process that...

SQLBits XII Recap

There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones.

There is a technological event...

Webinar Q&A: Getting Started with Change Data Capture

Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics...

Speaking on ETL Security

I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.
Securing...

Reblog: July 18 to July 24

Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...

A Question From The NomCom

One of the many things we’re discussing going into the 2014 PASS election is what the planned two official campaign...

Friday Followup For July 25, 2014

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