Category Archives: Security

Domain Security Groups – Who is in the group?

As we all know, user access is one of the tasks that DBA’s are responsible for in their environment.  And if we are following best practices and want to make our lives easier, we should be handling user access with … Continue reading

Posted in PowerShell, Security, TSQL | Tagged | Leave a comment

Encrypted Database Objects … How to Guide

Time and again, I have talked about security as being a high concern for DBA’s. So, that is why it is good to familiarize ourselves with the various types of security within SQL Server. In a previous post, I discussed … Continue reading

Posted in DBA, Security | Tagged | Leave a comment

Security Cleanup … Identifying Invalid Logins and Orphaned Users

Imagine that we own a large apartment building. And naturally, over time different tenants will come and go. But, what if we never bothered to change the keys to the apartments and we never attempted to get the keys back … Continue reading

Posted in Security | Tagged | Leave a comment

How SQL Server Can Make Things More Secure … Use Encryption!

One of the hottest topics in the technology world is security.  This topic is important because there are few things that can hurt a company more than stolen or misused data.  So, it is easy to see why security should … Continue reading

Posted in DBA, Security | Tagged , | 1 Comment

Sysadmins Locked Out of SQL Server – Now What?

As a DBA, have you ever inherited a SQL Server that you were not able to access because you were locked out of the instance as a system administrator? Perhaps a group within your company managed this SQL Server until … Continue reading

Posted in DBA, Security | Tagged , | Leave a comment

The Kerberos Double Hop Problem

I have heard some IT professionals call it, “the impossible IT problem” or even a “showstopper”.  Others are utterly amazed when it is solved because they view it as an overly complex problem.  But, what are we talking about? … … Continue reading

Posted in DBA, Security | Tagged , , , | 1 Comment

Is it Safe? Is it Secure?

Everyone to some extent is concerned about safety or security.  We may be concerned about our physical safety and avoid dangerous areas.  We may be concerned about the safety of our belongings and that may be why we lock the … Continue reading

Posted in DBA, Security | Tagged , | 3 Comments