Tag: SQL Consulting

SQL Server looking up and out.

Looking “Up and Out” and “Down and In”

Halfway through my morning walk, I look up and see this amazing view. No filter needed. It was naturally stunning. I just stood there a moment soaking in the majesty of the view. The wisp of the clouds, the vibrancy of the colors, the reflection of the water. It was beautiful. And I almost missed…
Read more

A properly configured SQL Server is like a well tuned race engine.

Identify Disk I/O Performance Issues for Your SQL Server Using DiskSpd

“We need faster storage.” Sound familiar? Or what about “No, the storage is good; we need to tune the database.” Often teams will have very different opinions about the root cause of a performance issue. Microsoft’s free DiskSpd utility can help identify disk I/O performance issues for your SQL server systems. Here’s a short introduction…
Read more

Is My SQL Server Configured Properly?

Installing SQL Server is surprisingly easy. Download the media, double-click the setup file, answer a few configuration questions, and in less than 15 minutes you have a fully functional database server. And the server performs well. For a while. Then it slows down and maybe even a database corrupts. You recover by restoring the prior…
Read more