Varchar "miracle" and best practice

I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can...

Add an Instance to SQL Server Azure Virtual Machine

How do you add an instance to your local SQL Server installation? You run the executable that you probably downloaded...

Cannot start SSAS after install in tabular mode

After installing SSAS, using the tabular model, you receive the error “The service cannot be started: The following system error...

FileTable– Using GetParent for Inserts

In a previous post, I looked at the ways in which I could insert files into a Filetable folder programmatically....

Finding Groups - Consecutive Months

A step by step explanation on one way to get a consecutive period of months, which could easily be adapted...

Know Backups and Know Restores – SQL Server Restores

A couple of years ago I put together a training session to demonstrate various types of backups and restores. The driving...

Last Weeks Top “Reading” Links #84

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

PASS Business Analytics Conference 2014 Recap, part 2

These are my impressions from the PASS Business Analytics Conference 2014 in San José, California.

The first part of this series...

Password Cracking–Part 2

Two days felt like a long time, so we found a cloud server with 16 cores we could use. We...

Statistics with Ascending Key Column Values

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...