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
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
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
“People don’t want to buy a quarter-inch drill. They want a quarter-inch hole!” In the world of databases, stakeholders don’t care about SQL backups. They care about the ability to restore a SQL database.
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
Fortunately, DBCC CHECKDB will log each time it completes without finding any errors or corruption in the database. That’s known as the Last Known Good date. Let’s look at three ways you determine the Last Known Good date. We’ll use a T-SQL query, a PowerShell command with dbatools, and the SQL Server Logs via Management Studio.
Checking the number of tempdb data files is straightforward. Here are three easy ways: one graphical, one T-SQL, and one PowerShell, so you can use your tools of choice.
“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
SQL Server hardware can be powerful. Lots of CPU cores and memory. Just what a crypto miner may need in their quest to generate cryptocurrency. In the case of the MrbMiner exploit, numerous SQL Servers have been exploited with brute-force attacks. These attacks are scanning for servers exposed directly to the internet and are using…
Read more
Recent Comments