SQL Server. Many business depend on it. But how can you tell if your SQL Server is healthy? It’s not always obvious. SQL Server can be pretty forgiving in many ways, until it’s not. And that can put your performance and even your data at risk. The right configuration settings are critical. Unfortunately, it’s easy…
Read more
“What’s the difference in SQL Server FCIs and AGs?” That question comes up frequently when talking High Availability and Disaster Recovery (HADR). It’s especially important when “Everything stops and people can’t do their jobs if SQL Server is unavailable.” There are a lot of how-to articles on the internet for setting up Always On Failover…
Read more
You’ve manually started DBCC CHECKDB to verify the integrity of a database. It churns. And churns. You check the Messages tab on Management Studio. Nothing. So, you start to wonder: Just how much longer will CHECKDB take to complete? A couple of minutes? A couple of hours? Who knows? How long will DBCC CHECKDB take?…
Read more
If a user is a member of db_datareader, which grants access to a table, and db_denydatareader, which denies access to a table, which role will take precedent? That’s the question someone on LinkedIn recently posted in the SQL Server Administrators group recently. Here’s a link to the question. The LinkedIn poster essentially wanted to know…
Read more
“I want to learn [a technology]. Where should I start?” Since I’ve spent the last 25 year working with SQL Server (no exaggeration, see footnote), the question is usually about learning SQL Server. Sometimes it’s about learning related technologies such as data analytics and visualization, scripting languages such as Python or PowerShell, or the burgeoning…
Read more
The SQL Server community is vibrant, caring, and close-knit. Now, with recent news about the future of SQLSaturday, we can add resilient to that list. The gift of SQLSaturday If you’ve been around SQL Server very long, you know just how wonderful the SQL Server community is. People around the world regularly and selflessly share…
Read more
Some things are scary. Other things are dangerous. And in SQL Server, you can have both scary and dangerous at the same time. Scary, that we can deal with. But dangerous, particularly things that are deceptively dangerous, is bad. Scary things Let’s start with scary. Some things give us pause. We see them, think about…
Read more
The end of Mainstream Support. Is that really as dire as it sounds? Because it sounds like I’ll be completely on my own. No support. At least no “mainstream” support, whatever that means. What happens if something goes wrong?
“The server is seriously slow! Can’t we add memory or something?” We’ve all heard this before. You may have even thought it yourself. Adding resources could be an easy fix to a troublesome performance problem. After all, SQL Server hungers for memory. The more the better. And a side of processor goes a long way,…
Read more
Conserving energy is good. It’s good for the environment and it’s good for the bottom line. That’s why Windows Server has built-in power settings. But there’s a trade off. With reduced power comes reduced performance for most SQL Servers. The Windows Power Plan Setting Windows Server has three pre-defined power settings: Balanced, High Performance, and…
Read more
Recent Comments