SSRS report subscription: Fire Event from SSIS package

My previous two posts about SSRS reports being deployed to a SharePoint site along with their subscription didn't stop me...

Top 10 Recommended Books…

So the title says it all, right?  Well, only really partially. Recently an article was published listing the top 10 most recommended books for SQL Server.  That’s the part...

Top 10 Recommended Books…

So the title says it all, right?  Well, only really partially.
Recently an article was published listing the top 10 most...

Add them to ALL the roles!

I seem to get a lot of permissions questions these days and one of the more frequent ones goes along...

Book: SQL Server 2014 Development Essentials

I am very happy to announce that my first book “SQL Server 2014 Development Essentials” has now been published by...

Building The SQLSaturday Orlando Marketing Plan-Part 26

More notes:
In hindsight it’s easy to see we should have worked on the email template first, then the flyers. Email...

Last Weeks Top “Reading” Links #94

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Steps to install Service Pack for SQL Server 2005 – Multiple Instances

Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :-
Step 1 : First page of...

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

CTE - Limitations

Hi

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