Tag Archives: sql server

What’s a DACPAC and a BACPAC?

Posted on February 22, 2017 by way0utwest

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

Let NonAdmins Get Logins

Posted on February 8, 2017 by way0utwest

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 , , | Comments Off on Let NonAdmins Get Logins

Your Favorite Feature that Needs Work

Posted on February 3, 2017 by way0utwest

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

Posted on February 2, 2017 by way0utwest

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 , , , | Comments Off on Using a DMK in TDE