Tag Archives: security
-
Auditing with “C2 Auditing” and “Common Criteria Compliance”
Leave a commentSeptember 7, 2021 by Kenneth Fisher
I’m going to be fairly high level on these because to be honest, if you are going to use them …
Continue reading -
A new presentation on Auditing your databases
Leave a commentAugust 19, 2021 by Kenneth Fisher
I’m giving a presentation at the PASS Data Community Summit 2021 being put on by Redgate! It’s going to be …
Continue reading -
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?
2May 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
SQL Studies 