Cumulative Update – 1 for SQL Server 2014 RTM Rollback by Microsoft !

The 1st cumulative update release for SQL Server 2014 RTM was released by Microsoft.
But due to issues in setup Microsoft...

Why is there a sysobjects when we already have sys.objects?

Once upon a time in a version of SQL far far away we had system tables that were easy to...

Enable CLR with Powershell

I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
He...

What is MongoDB?

How does MongoDB Store Data?
What is MongoDB?  MongoDB is a document oriented database.  This means it stores its data in...

A few words about simplicity: Using Red-Gate Ecosystem framework

In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).To be honest, the first version...

Presentation Slides for Modern Data Warehousing

Thanks to everyone who attended my session “Modern Data Warehousing” at the PASS SQLSaturday Business Analytics edition in Dallas.  The abstract is below.  Great...

PROVIDING LOGGING INFORMATION AT COMMAND LINE

For providing logging information at command line utility use the option /l

for example

dtexe /f "some path" /l "logging type; connection...

Data Quality Matching in SQL Server

Every IT person is more than introduced to the problems of integration – in the ideal perfect world we could join...

Building the SQLSaturday Orlando Marketing Plan–Part 6 (Seminars)

Seminars (aka “pre-cons”) have been part of the DNA of SQLSaturday going back to #1. For those that weren’t there...

Hekaton 2014 – The Saviour vs The Lost Cause

With the release of the SQL Server 2014, Microsoft has finally unleashed their long-time in work In-Memory solution (codenamed XTP...