“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
The call comes in. “Something’s happened. We need to restore the production database. Can you do it? And how long will it take?” No DBA wants to receive that call but, frankly, answering those calls and the ensuing questions are part of a DBA’s job. And there’s no better way to know that you can,…
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
Views in SQL Server are really just queries that have been given a name so that they can be referenced as if they are tables. This can be convenient, especially for code reuse. However, it can also have some unanticipated consequences. Let’s look at an example. Let’s consider the affect joining two views can have…
Read more
“Do I really need the SQL Server Enterprise Edition license? Or will SQL Server Standard Edition work for us?” That’s a question most every CFO, CIO, VP, and Director with a SQL Server environment and budgetary responsibilities has asked. The reason is obvious. SQL Server Enterprise Edition is expensive. How expensive? According to Microsoft’s web…
Read more
We’ve made it! The start of a new year. Now is a great time to reflect on what you’d like to accomplish over the next 12 months at work, and more specifically, what you would like to do with your SQL Server environment this year. To help with that, here are five activities or goals…
Read more
In SQL Server, when someone creates a database, they own it. That means they have elevated permissions on the database. The SQL Server database owner can change configuration parameters, perform maintenance, and grant permissions on the database to other users. The database owner can even drop the database altogether. In highly secure environments (and what…
Read more
Securing and protecting your SQL Servers from the ever present threats of data breaches, ransomware, and even accidental data losses due to errant code or faulty systems is crucial. It’s one of the core responsibilities of a DBA. It would be great if there was a one-size fits all approach to data protection – one…
Read more
Recent Comments