Tag: Sero Group

SQL Server Security

What Takes Precedent db_datareader (GRANT) or db_denydatareader (DENY)?

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

disaster recovery in SQL Server

Where to Start with Disaster Recovery in SQL Server

Backup and restore? Log shipping? Maybe Failover Clustered Instances or Availability Groups can be used? Oh, what about Azure or another cloud provider? Some data centers offer “push button DR,” will that work? There are so many options. Where should we start with Disaster Recovery for our SQL Server? The point of Disaster Recovery Disasters…
Read more

Learning SQL Server

Learn SQL Server with PluralSight’s FreeApril

“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

Testing sql server backup files before you need them

How to Test SQL Server Backups Using dbatools

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 future of the SQLSaturday community

The Future of SQLSaturday

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 in sql server are scary but not dangerous

Scary and Dangerous Things in SQL Server

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

SQL Server upgrade time

End of Mainstream Support for SQL Server 2016

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?

money to buy more SQL Server resources

Should I Add Hardware Resources to My SQL Server? Do This First.

“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

Power plan settings limit resources to sql server

SQL Server Performance and Windows Power Plan

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

SQL Server views and their performance

How do Views Affect SQL Server Performance?

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