The world is a better place because you're in it. Even if you are the lesson that other people will learn to avoid.

reply to jasona.work

We have a means to do that by identifying the IP source of the login and from there identifying the owner of that IP. Query snippet below. There's...

I'm using AI but have found ways to make my worklife better. I've used Visual Studio Code's AI to help generate PowerShell code to renew SQL Certificates and then have...

Nice article and I appreciate the Why and the Step by Step. Well written.

All your statements are true but then I'm sure you already know that SQL Server has temporal tables, when designed well removes the need for audit tables. I have made...

This stinks of AI.

This has nothing to do with a web page. This is just performance enhancements with SQL Server that have been around for a long while.

Also Analytics aren't really needed to...

I agree. This seems like an AI generated article. and unfortunately made it through.

Thank you. I enjoyed the article very much.

___

It would have been helpful to know what prerequisites are required for a command to run successfully. For example,

-- Run this on each server instance participating in...

• This reply was modified 2 years, 5 months ago by andre.quitta.

I very much enjoyed this article. One of the best ones I've seen in a while.

The nice part about this article is that it is generic and the principles could be applied to any database platform. Same with the execution, with Python just executing T-SQL...

Also Active Directory groups and reduced use of SQL logins helped us a lot. We also rename the SA account and disable it.

I've found that bigger teams require Leads to represent the group or else Stand Up takes a long time. You're right that management is very hard, especially in IT. I've...