Tag Archives: sql server

Legacy Limits

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 | Leave a comment

What is a Database Master Key?

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 , , | 1 Comment

The (Former) Complexity of PowerShell

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

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 , | Leave a comment

Not Excited by Linux

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

Please Fix This–T-SQL Tuesday #86

It’s T-SQL Tuesday time, and this month is an interesting topic. The invite comes from Brent Ozar, and it’s designed to get you to look at SQL Server. I spent some time thinking about this one and getting a post … Continue reading

Posted in Blog | Tagged , , | Leave a comment

SQL Server is Getting More Popular

At the db-engines.com site, SQL Server was named the DMBS of the year. This was the site’s choice based on a measure of how popularity changed from Jan 2016 -Jan 2017. Apparently SQL Server grew in popularity in a number … Continue reading

Posted in Editorial | Tagged | 1 Comment

Syntactic Sugar

There are all sort of features and enhancements that Microsoft can make to the SQL Server platform. If you look around Connect, you’ll see suggestions for improvements, such adding common checks, as well as additions like adding virtual tables. I’m … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Provisioning

This editorial was originally published on May 24, 2013. It is being re-run as Steve is on holiday. At a talk recently, the presenter talked about the time lag for an on-premises server to be installed and configured to be … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Connecting to a Specific Port–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I recently blogged about finding the port your SQL Server uses. At the end of that post I showed … Continue reading

Posted in Blog | Tagged , , | Leave a comment