Introducing sp_CheckSecurity

free sql server dba tool sp_CheckSecurity

Are your SQL Server instances secure? With new threats to your data emerging every day, it’s a difficult question to answer. And what is even included in the word “secure”? Sure, maybe you’re confident you have security against hacking (or maybe not?), but what about internal security? Are you protected against oops moments? Are there … Read more

6 Common Pitfalls of SQL Server Migrations and Upgrades

common sql server migration pitfalls

If you’ve ever tried migrating a SQL Server database from one server to another, you know it can be a white-knuckle ride from start to finish. You need to wait forever while you backup and restore, change all your connection strings to point to the new server, and forget to change the data sources for … Read more