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

Blogging-Write More

Blogging isn’t easy. You have to come up with a topic, write about it, and then release it for the...

Building the SQLSaturday Orlando Marketing Plan–Part 5

More notes, many from a chat with Kendal.
We wish we could see the open rate on email and an...

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

Collation: Confusion

I started reading about collations after I had a recent run in with them. As I read I started to...

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

Friday Followup For May 2, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

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