Your backup is not a recovery plan until you test the restore
A green job history proves that a process ran. It does not prove the business can recover.
Read the article →Database operations and strategy
Insights
Perspectives on database reliability, troubleshooting, recovery planning, and getting the right level of DBA support.
When the database problem is really somewhere else
Why database symptoms often begin in DNS, identity, storage, networks, or application behavior.
Read the article →Seven signs you need a fractional DBA
Operational warning signs that appear long before an organization is ready for a full-time DBA.
Read the article →Maintaining SQL Indexes
This article explains four concepts that help you assess SQL Server indexes: pages, fill factor, fragmentation, and size. Understanding these concepts helps you decide whether maintenance is worthwhile. They should be considered along side query performance and the cost of maintenance.
Read the article →Index Types
In this section we will talk about nine common types of in indexes available. We will show sample index creation for each type.
Read the article →SQL Indexes
A SQL index works much like the index at the back of a book. Instead of searching every page—or, in this case, every row—the database uses the index to locate the requested data more efficiently.
Read the article →Need help applying these ideas?
Describe the symptoms and we can help determine the right next step.