SSIS Project Deployment under different name

I love SSIS Server, it was one of the greatest addition to the SQL Server Integration Services in 2012 version...

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 Support site. Cumulative Update 1 contains all the hotfixes...

CTE - Limitations

Hi

Wanted to explore one of the major limitation of CTE in sql 2012 i.e. it cannot be used inside if...

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