Tag Archives: sql server

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

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