Tag Archives: sql server

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

The (Former) Complexity of PowerShell

Posted on January 19, 2017 by way0utwest

When I first looked at PowerShell, it was v1.0, and I was in a TechEd presentation. The language seemed a mile past the VBScript I was using when T-SQL didn’t function well. The ability to access the .NET namespace, work … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

Securing Your Instances

Posted on January 13, 2017 by way0utwest

I wrote a post about finding the port number of a SQL instance using PowerShell. Almost immediately I was taken to task by someone that noted port scanners can easily find SQL ports, so it’s silly to move off 1433. … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Securing Your Instances

Not Excited by Linux

Posted on January 11, 2017 by way0utwest

You’re not excited by Linux. At least most of you in this community aren’t excited. A recent poll we ran showed that nearly two thirds of the people answering aren’t interested in even evaluating SQL Server on Linux. That’s an … Continue reading →

Posted in Editorial | Tagged , | 1 Comment