Category Archives: Security
-
What you can do is based on more than your direct permissions.
1October 6, 2022 by Kenneth Fisher
What you have access to is not just what you have direct permissions to. The other day I needed to …
Continue reading -
Viewing errors with extended events
1September 27, 2022 by Kenneth Fisher
A little while back I came across this post: Identifying failed queries with extended events. It has a script to …
Continue reading -
Creating a SERVER ROLE created a LOGIN as well.
1September 6, 2022 by Kenneth Fisher
One of my co-workers came to me the other day and told me that they found their network id as …
Continue reading -
Why is security important in a dev environment?
6August 23, 2022 by Kenneth Fisher
I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve …
Continue reading -
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
Leave a commentAugust 18, 2022 by Kenneth Fisher
I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in …
Continue reading -
Creating a Database Audit Specification can create new users & schemas in the background
2June 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 Studies 