DBA Questions To Ask Software Vendors

Questions for a DBA To Ask a Software Vendor

Do you buy software from independent software vendors? Does it run on SQL Server? Are you responsible for supporting that software? Here are some questions that you can ask a software vendor about the way they use SQL Server. It’s best to ask these questions before you are a customer, too; you’ll have a bit … Read more

Are Power Saving Settings Killing Your SQL Server Performance? [Quick Tip]

At Straight Path Solutions, we love performing SQL Server Health Assessments. These are our exams that dig quickly into the root of your SQL Server instance and find problems that you are currently suffering from. Then we give you an action plan to stop suffering from them today. Rather than just performing the checks and finding the … Read more

Check SQL Server Configuration – Free Script

free dba tool of the week

I do a lot of SQL Server Health Assessments on SQL Server environments. I’m always checking  sys.configurations to look for problematic instance level configuration settings. I almost always find configurations worth changing. But the approach I’ve always used is a bit manual and I wanted to fix it.  So I finally wrote a script to … Read more