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

Reblog: April 11 to April 17

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...