SQL Consulting: SQL Server Is Our Only Business.
To get your attention, I thought I would start with this statement from the abstract of a new study of Solid State storage devices (SSD) done by researchers at Ohio State University. Our …
Continue Reading about Don’t Confuse High Availability with Data Safety →
Monitoring and Troubleshooting SQL Server the Easy Way SQL Server is such a big, multi-faceted product that it is difficult to become familiar with all its features. One very useful but little-used …
Too Much Available Memory Can Spoil Performance I like to think I know a lot about SQL Server, but every now and then something comes along and knocks that silly notion out of my head. One of my …
Performance monitoring for SQL Server is big business, not only for the many 3rd party vendors of performance monitoring tools, but also for the SQL server magazines, blogs, forums, events and other …
Continue Reading about SQL Server Performance Monitoring Tools →
The data in your database is going to be corrupted someday. It is not a question of IF. It is just a question of WHEN. Corruption is caused by errors and failures in your storage media and\or power …
Deadlock, Blocking Lock Deadlocks and blocking locks are often confused. The symptoms are similar and both are related to contention for database resources by multiple processes. However blocking …
