Tag Archives: security
-
SQL Homework – August 2021 – Security Standards
1August 3, 2021 by Kenneth Fisher
A few years back (wow time flies) I had you Work with Security. It’s been a while so if you …
Continue reading -
How do I unlock a SQL Server Login using T-SQL (without changing the password)?
2July 22, 2021 by Kenneth Fisher
We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a …
Continue reading -
DDL Trigger to log database level security commands.
4June 24, 2021 by Kenneth Fisher
In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in …
Continue reading -
Why are my permissions missing?
Leave a commentJune 22, 2021 by Kenneth Fisher
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz …
Continue reading -
#PowershellBasics: Finding a common AD group for a set of users.
3June 17, 2021 by Kenneth Fisher
A while back (almost 7 years 😲) I wrote a post on finding the common AD groups of a set …
Continue reading -
What account is xp_cmdshell using?
3May 25, 2021 by Kenneth Fisher
It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. …
Continue reading -
What is the CONTROL permission?
1January 19, 2021 by Kenneth Fisher
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: …
Continue reading -
Adding a user to an Azure SQL DB
1November 5, 2020 by Kenneth Fisher
Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t …
Continue reading -
Permissions script for Azure Synapse
3October 15, 2020 by Kenneth Fisher
I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for …
Continue reading -
As a DBA, am I a gatekeeper?
7August 27, 2020 by Kenneth Fisher
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and …
Continue reading