Monthly Archives: January 2017

The Purpose of a Database

Posted on January 23, 2017 by way0utwest

A great quote from a blog on machine learning in SQL Server: “…nobody buys a DBMS for the sake of DBMS. People buy it for what it enables you to do”. The post is from Rimma Nehme, who has given … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Purpose of a Database

Installing dbatools on WS2012 R2

Posted on January 20, 2017 by way0utwest

This is actually a simple, short post, but writing helps me remember things, and since I had to learn this, I decided to write something short. I have a number of Windows Server 2012 R2 VMs. I need to get … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Installing dbatools on WS2012 R2

Legacy Limits

Posted on January 20, 2017 by way0utwest

We are seeing changes to the SQL Server platform every month in Azure. Since that’s the same codebase used to product SQL Server on premise, that means the enhancements are not only being tested in the cloud, but they are … Continue reading →

Posted in Editorial | Tagged | Comments Off on Legacy Limits

What is a Database Master Key?

Posted on January 19, 2017 by way0utwest

The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran across a few people struggling to understand, so I decided to cover the concepts in a series of posts. This … Continue reading →

Posted in Blog | Tagged , , | 3 Comments