Backup the ResourceDB with Minion Backup
It’s easy to backup the ResourceDB with Minion Backup. And while it’s not a setting (yet), it only takes one step. Here, we show you exactly how to do it.
Backup the ResourceDB with Minion Backup Read More »
Tech
Tech Corner: Be obsessive about comments
Code comments are a support feature that people widely ignore. Jen’s new session named “T-SQL’s Hidden Support Feature†explains this valuable resource, and how to best use it.
Tech Corner: Be obsessive about comments Read More »
Xp_cmdshell isn’t evil, so get with the program
Many companies are worried that enabling xp_cmdshell is a security hole. In fact, xp_cmdshell is limited to SQL Server administrators by default. In order for a non-admin user to use xp_cmdshell, an administrator must specifically grant permissions to them. In short: xp_cmdshell is not a security hole.
Xp_cmdshell isn’t evil, so get with the program Read More »