New Windows installation done. Coffee ready. And suddenly my WD EX2 NAS decided to pretend it did not know me at all.
SQL Server Maintenance Techniques: A Comprehensive Guide to Keeping Your Server Running Smoothly
This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.
Choosing a Processor for SQL Server: Count the Licensed Cores
Choosing a processor for SQL Server starts with the license, because SQL Server is licensed per core and the cores you buy decide the bill. This post reads what the server reports, counts the cores that matter, and explains the edition limits and the per-core speed trade. It ends with a way to size cores from measured CPU use.
Windows Power Plan for SQL Server: Use High Performance
The Windows power plan decides how fast the processors run, and an energy saving plan can slow SQL Server without raising any error. This post shows how to check the active plan, how to switch it and undo the change, and how to time the difference with a repeatable T-SQL loop.
SQL SERVER – Error: 825 – A Read of the File at Offset Succeeded After Failing 1 Time(s)
One of my clients contacted me to give advice about an error. In this blog, we would discuss error message – A read of the file at offset succeeded after failing 1 time(s)
Collecting Server Hardware Facts Before a Tuning Session
Capture server hardware facts from SQL Server views, keep an inventory, and distinguish visible resources from workload sizing evidence.
SQL SERVER – OS Error 13 – The Data is Invalid OS Error 87 – The Parameter is Incorrect – Various Errors due to Faulty Media or Hardware
I offered them quick 15-minute time to see what the errors are and whether I have some techniques to recover the data for invalid OS error 87.