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

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