Tag Archives: security
-
Creating a Database Audit Specification can create new users & schemas in the background
1June 28, 2022 by Kenneth Fisher
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on …
Continue reading -
I’m writing a SQL Server security presentation and I need your help.
5February 24, 2022 by Kenneth Fisher
I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going …
Continue reading -
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