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

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