Webinar – Easy SQL Server Benchmarking

On Thursday, May 1st, I will be presenting a new webcast with Tegile Systems entitled “Easy SQL Server Benchmarking”.
Abstract: Do you have a new piece of...

Notes From The April 2014 oPASS Meeting

Same room but different seating arrangement. Instead of separate table pushed some together, used the space better and more a...

Collation: Temporary objects and variables: Demonstration

I had a recent run in with collation problems and it got me started reading about them. As I read...

Collation: Temporary objects and variables: Demonstration

I had a recent run in with collation problems and it got me started reading about them. As I read...

FileTables–Inserting Directories from T-SQL

Creating a directory in a Filetable share is easy. It looks like this:

It’s hard to see, but this was a...

Central Management Studio CMS

By David Postlethwaite

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...

New release 2.4.5222

Today we released new version of SQL Code Guard - 2.4.5222There are many fixes and improvements, some new rules were added.Full...

Creating a Dynamic, Parameterized Measure in DAX

As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value...

Modern DataWarehouse: The Weakest Link

It has been quite some time, that the term Modern Data Warehouse has appeared on the horizon of so many...

Hangout #18 with Boris Hristov

Yesterday evening I had the honour and pleasure of recording one of his famous SQL Hangout with my friend Boris Hristov (b|t).
We...