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

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

PASS Business Analytics Conference 2014 Recap, part 1

PASS Business Analytics Conference is not a new kid on the block anymore – happening for the second year in a...

SharePoint 2013 External Data Connections

SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections  are part of the Business Connectivity Services (BCS)  that can be...