Monthly Archives: June 2022
-
What’s next? Pt 2
5June 30, 2022 by Kenneth Fisher
Well, it’s only been about a week and a half but here’s an update. First a piece of advice. You …
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 -
How do I tell if identity_insert is turned on and if so what table?
4June 24, 2022 by Kenneth Fisher
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty …
Continue reading -
What’s next?
19June 21, 2022 by Kenneth Fisher
As I’m sure a fair number of you already know I was told my position had been eliminated. They are …
Continue reading -
Too many coding standards : T-SQL Tuesday #151
4June 14, 2022 by Kenneth Fisher
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding …
Continue reading -
SQL Homework – June 2022 – SQL Agent Jobs continued.
2June 2, 2022 by Kenneth Fisher
A few years ago I gave you homework to create a SQL Agent Job and play with it a little …
Continue reading