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

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

Password Cracking–Part 2

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

Escaping from a runaway Logon trigger

Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon...

Database Backup Encryption with SQL Server 2014

A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...

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

Building The SQLSaturday Orlando Marketing Plan–Part 8

One of things I wish PASS provided was at least one template for an event flyer, something that is basically...