Dedicated Admin Connection (DAC): Your Key to Troubleshooting and SQL Server Security

dedicated admin connection

This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. In … Read more

SQL Server Migration Considerations from a Jr. DBA

SQL Server migrations are a necessary and expected part of keeping a modern SQL Server deployment. We have worked with many clients on migration projects, and I have organized some considerations for you and your team before, during, and after your SQL Server migration. We recommend working with a SQL server DBA on these kinds … Read more

What Service Pack Are Your Client Tools At?

So you have a plan to apply service packs to your SQL instances. You test them out and try to keep a regular schedule to ensure they are up to date. That is great. What About SQL Server Management Studio? What about the copy of SSMS that a developer is using to create scripts? This … Read more