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

Sabbatical Decisions

My employer, Red Gate Software, offers a sabbatical to their employees, and this year I’m taking mine. I’ll be gone from...

Reblog: April 25 to May 1

Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...