SQL RNNR

One of my biggest reasons why I do what I do, boils down to the challenges that I frequently get to encounter. There is a wild satisfaction to working on a very difficult and challenging task, product, tool, profession, skill, etc. This satisfaction often involves reward and a sense of accomplishment.

Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an effort to trip up the candidate and get the candidate to doubt him/her self.

The defaults in the msdb database are about what is missing. It’s missing quite a few things that could be critical to your environment.

This is an introductory level method demonstrating how to quickly audit database objects and principals for granted permissions.

One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if the job failed because something was changed in the job? Maybe you knew about the change, maybe you didn’t.

DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.

One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing. It just means the DBA works hard to automate the repetitive mundane tasks that may be tedious and/or time consuming.

ARITHABORT can be a short termed head scratcher.  Pay close attention to what has changed in the environment.  Test alternatives.  And check those connection strings.

It isn’t very often that one would consider a short circuit to be a desired outcome. In SQL Server we have a cool exception to that rule – Extended Events (XE).

Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as desired.

Yes it is a good idea. A fillfactor of 100 is great if the data in the table is always…

When the ad account disappears, then you could see various abnormalities that could be intermittent.

That is fine.

I like to use that one as well.

In your outstanding script called "Script to auto generate a security report for your SQL Server instance" where can I…

One I ask is "How would you go about identifying and removing duplicate rows from a table…

Nice quick, and easy check on db object security...thanks.

Ɗo you mind if I quote a feѡ ⲟf your articles ɑs ⅼong ɑs I provide credit аnd…

Thanks for sharing your knowledge. Do you happen to know what would happen if the owner of the endpoint…

You have set fill factor = 90. This makes your index 10% bigger than they need to be. Is this…