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

Get SQL Server Info - Quick Tip & Script

There
are a number of ways to collect basic information about SQL Server, its
version, edition and other top-level properties.  What is...

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

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

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