Best Practices

Restoring SQL Server – Are you Ready?

It’s 5 AM on Wednesday. Your CIO has called your cell phone at home. “We need you to log in right now! Someone or something deleted all of the inventory. I tried to help out the team right before the inventory disappeared, and I was running some SQL commands I found and a couple of … Read more

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

Create a SQL Server Baseline with the PAL Tool

Calibrate your budget and resources with a good SQL Server baseline

When we do a SQL Server Health Assessment, we quickly dive into SQL Server performance and Windows/Physical/Virtual resource usage counters. During our kick off interview  we always ask if you have a SQL Server baseline from the past to compare. Usually the answer is no, unfortunately. Like monitoring and alerting, many of the tools vendors make automated baseline collection tools. Also like alerting, though, … Read more