SQL Query Result Order

Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned is...

An interview with Alex Whittles Chairman of SQLRelay 2013

Some of you may recall in January I ran a series of interviews entitled “New Year Aspirations”. This interview was...

Easy way to generate a restore script.

Easy way to generate a restore script.
I was asked today if I had a canned restore script handy. I don’t....

Building a SharePoint 2013 BI Demo Environment Part 5 – Installing SharePoint

Let’s get started with the next step in the series: installing SharePoint. We will install only the software, but we...

Philly Wrap SQLSaturday 200, HealthSQL and beyond..

SQLSaturday 200 is already looking further away in the rear view mirror, but it was a great event!
Joey D'Antoni, Sebastian...

How To Make Your DLL Into A NuGet Package for a Private NuGet Feed

This is my reinterpretation of the documentation on NuGet.org, modified to remove the public publishing steps, and to add local...

From the 2013 Techno Security Conference - Cloud Computing and Digital Forensics

I'm processing through my notes for the 2013 Techno Security Conference, which is finishing up today with post-cons. Of all...

CHOOSE in SQL Server 2012

The CHOOSE command is new in the T-SQL as of SQL Server 2012. I hadn’t ever had the chance to...

SQL Saturday Baton Rouge Call for Speakers closes June 6!

SQL Saturday Baton Rouge Call for Speakers is open through June 6 (closes June 7 at midnight).

This year's pre-conference banquet...

My 2 cents on SQL Server 2014

Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of...