Do All SQL Servers Need to Be Upgraded? Running production systems on a platform that is no longer supported by the vendor is worrisome. If something goes wrong, you’ll no longer be able to call the vendor and receive technical support. But worse, you’ll no longer release updates, fixes, security patches, etc, for the out…
Read more
“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
Unfortunately malware attacks attempting to exploit vulnerable SQL Servers are often successful. Last spring, Guardicore announced that the Vollgar attack that was making its way around the internet. Just last month, it was MrbMiner in the news. And there have been countless other attacks targeting SQL Server over the year. So, how can your protect…
Read more
I’ve been pondering a question recently. “Has PASS outlived its purpose?” To help answer that question, I went to the PASS website to look for its mission statement. I couldn’t find it in the dropdown menus. I searched the site. No results found. That’s disappointing. And perhaps it explains why the organization is struggling as…
Read more
Last week, Guardicore released information about a newly discovered attack that uses SQL Servers to compromise servers and networks. Here’s a link; I’d really encourage you to read it. The attack known as Vollgar uses a simple brute force attack to gain access to SQL Servers exposed to the internet. It then uses the elevated…
Read more
We’ve all asked that question at some point. Maybe we inherited a new-to-us SQL Server that hasn’t been maintained regularly. Or, perhaps we’re prepping for a maintenance window and we want to get the latest update into Test as soon as possible. Regardless, we want to know two things. First, what product version is my…
Read more
“What gets us into trouble is not what we don’t know. It’s what we know for sure that just ain’t so.” – Mark Twain Each year I read approximately 30 books for the pure pleasure of creating in my imagination the sights and sounds and smells of the world that the author has created in…
Read more
Recently, I had the pleasure of sitting down to talk with Thom Coats of The Unstuck Business Academy for their “Stories from the C|Suite” podcast. Thom is a wonderful host and we had a lot of fun talking about everything from camping and hiking, to professional development, to effectively managing SQL Server infrastructures. Here’s a…
Read more
Many companies have lean IT organizations and find themselves with five, ten, or even twenty production SQL Servers and no dedicated Database Administrator to care for them. Instead, they rely on other IT Professionals to ensure the database servers are performant. We’ve worked with many companies where SysAdmins, Application Developers, and Network Administrators have been…
Read more
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
Recent Comments