Script to create demo database and load data for statistics and R

Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...

Speaking at SQLSaturday Sacramento!

I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 23th 2016! This will be my third SQLSaturday event this year and I’m really excited...

Speaking at SQLSaturday Sacramento!

I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 23th 2016! This will be my...

Azure SQL Database waits you should be aware of…

I’ve been using Microsoft’s cloud database for some time now. I’ve had a few customers with various performance problems and...

Resolving PolyBase Installation Errors in SQL Server 2016

One of the exciting new features you may want to explore in SQL Server 2016 is PolyBase. However, as I...

SQL vs NoSQL

Introduction
Despite the traditional relational DB world, there’s also a trend for NoSQL. The NoSQL databases that enable storing unstructured and...

GIT Learning Resources

I’ve spent most of my career using VSS and TFS, mainly because that’s what was being used. Better any source...

TGI Friday (Live Blog Day 4)

Its been long but productive week at Tree Tech

This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the...

SQLServerZest is now DataGinger!

We are happy to announce the birth of DataGinger. Starting today we officially re-branded ourselves as DataGinger.com (previously SQLServerZest.com). The...

Introduction to Power BI Desktop – Recording Now Available

Thank you to everyone that attended this past Tuesday’s webinar hosted by Pragmatic Works called Introduction to Power BI Desktop....