When a SQL Server database is the backbone of your application, its design will have a huge impact on the application’s performance. While many developers just view the database as a container for storing data, the truth is that a well-designed database is critical to your application’s speed, reliability, and ability to scale with your…
Read more
“Why is SQL Server memory usage high?” If you haven’t been asked this question, you haven’t supported SQL Server long enough. I’ve encountered managers, systems administrators, and developers who’ve wondered this. Simply put, data reads are much faster in RAM than from disks. RAM latency is typically measured in nanoseconds. By contrast, disk latency is…
Read more
I read 50 to 60 books a year, a habit I’ve maintained for most of my life. Some of those are just-for-fun fiction books. Others are educational nonfiction books that give me glimpses into other disciplines or subjects. Still others, like the books I’ll share in this post, help me to improve in my various…
Read more
As 2025 kicks off, organizations are eagerly setting new goals. For DBAs, a top priority might be preparing thoroughly for the next IT audit. Whether planned or unplanned, an audit can significantly impact how others perceive your IT department’s reliability. A seamless audit highlights strong governance and dependable systems, while missteps can reveal vulnerabilities and…
Read more
Recent Comments