Tag Archives: sql server

Upgrading SQL Server on Linux

I saw this week that there was a new CTP (v1.3) of SQL Server v.Next. I haven’t had a lot of time to work on the Linux version lately, but I thought I’d try and see how well the upgrade … Continue reading

Posted in Blog | Tagged , , | Leave a comment

What’s a DACPAC and a BACPAC?

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. If you’ve worked with SQL Server development and database projects, you might have heard about DACPACs. However, if you … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Let NonAdmins Get Logins

I saw a question recently about how to allow some users to see the logins on a server without being a sysadmin or securityadmin. This was in support of a migration effort, so users needed read rights without being able … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Your Favorite Feature that Needs Work

The SQL Server platform has grown tremendously since I started working with SQL Server v4.2. We’ve had various subsystems added, lots of enhancements, and even new languages. There have also been a few parts of the platform that have been … Continue reading

Posted in Editorial | Tagged | 1 Comment

Using a DMK in TDE

When you setup TDE, you need to create a DMK (Database Master Key) in the master database if one doesn’t exist. This key forms the basis of a chain of protection for your data inside of the SQL Server instance. … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

The vNext Bleeding Edge

Microsoft has had early access programs for years. I worked at a few companies that were a part of the TAP (Technology Adoption Program) program, and we would get access to code early in exchange for providing feedback and working … Continue reading

Posted in Editorial | Tagged , | Leave a comment

What’s a Database Encryption Key (DEK) in TDE

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 New SQL Server 2016 Edition Limits

I was thrilled with SQL Server 2016 SP1. I’ve been asking for all features to be in all editions for a long time, and now we have most of the features available. There are still a few enterprise only items, … Continue reading

Posted in Editorial | Tagged | Leave a comment

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 , , | 3 Comments