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

Creating Power Map Reporting Solutions Recording and Q&A

I hope you were able to attend my free webinar on Creating Power Map Reporting Solutions on April 17 2014.  If you...

SQL Server Diagnostic Information Queries for April 2014

I made some small improvements to a few of the queries this month. I plan to add several more SQL...

Speaking at SQL Bits XII

I’m heading back to SQL Bits for the third time and I’m excited to be going again. I think that...