Running Out of Foreign Keys-Question of the Day

Running Out of Foreign Keys is live today. Nothing too interesting about this one, a straight forward question where you...

Tulsa User Group

I love user groups.
I have a special place in my heart for people who go out and give their time...

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