Monthly Archives: May 2016

Scripting Data from a table doesn’t have to be like pulling teeth

Sometimes you need to be able to script the data out of a table and it is easier than you might think. I commonly do this when I am generating automated tests or updating a product with system data for...
Continue Reading →

Improving Project Success

There was a timely editorial posted this morning on SQL Server Central by Steve Jones concerning Successful Projects. In his post he references Kevin Whitson’s The Kevin Test for Successful Projects, which was inspired by The Rands Test   and Joel...
Continue Reading →

SQL Server 2016 coming June 1st (And free stuff)

Microsoft announced the June 1st release date for SQL Server 2016.   Read to the end for other big news. From the breakdown of Features Supported for SQL 2016 by Edition there are a couple new features that will make their...
Continue Reading →

SQL Server Discontinued Features and Items marked for deprecation

With each version of SQL server certain items are discontinued (removed) from that release, and other items are marked for deprecation (removal in a future release). Earlier this week I saw some code that I remembered being on the deprecation...
Continue Reading →

Project Pre-Kickoff Road-mapping and Scoping

In many cases we are asked to give a WAG for a project very early in the process. This typically includes the assumptions  we made, and any known risks. As the project progresses it is usually necessary to spend some...
Continue Reading →

Hiding the SSRS Breadcrumbs from Users

It is common when rolling out our SSRS prototypes that different onsite users will be interacting with the different products. This means that typically different user groups will be setup and certain groups will have access to specific SSRS report folders...
Continue Reading →