Where I work, we have a polling process that runs daily and sends email notifications about databases that havn't been used for X days. The same goes for SQL and...

2021 was the year I was tired all the time - perhaps it was recovery from 2020.

In regards to SQL Server, auditing and compliance was front and center. I developed...

Does anyone here remember FoxPro for DOS and Clipper?

Old timers in the IT outback will occasionally see these things still living in the wild.

So, apparently smart contacts are not immutable after all - or at least the programming that implements them is mutable. But this guy brings up the point that programmers are...

Thanks for taking the time to write this article, Kathi.

What's even worse than what you mention is that the quality of the "official" documentation has totally tanked as is...

Two people authenticate a process. For example, I want to turn auditing off, but I can't do it alone. I ALTER AUDIT SET OFF, but until another admin does...

Steve,

When you mentioned "perhaps even two-person authentication" in your editorial, what were you thinking about?

On out production servers, we do have login auditing enabled, and a daily email report of...

"Recently I saw someone suggest MFA for SQL Server. I would hope that we would get not only more complex authentication for the platform, perhaps even two-person authentication. but I'm...

Depending on the AI platform, maybe Microsoft, Amazon, or Google should get the Nobel award. The data scientists are just script kiddies.

Search JIRA tickets, Git repositories, Octopus deployments, etc. to see what they were working on recently.

Interesting, but what are the advantages of row based security versus simply creating views with filtering and restricting access to these using role based or domain group GRANT SELECT permission?

Eric,

Are you saying that any database object is always going to be tightly coupled with other objects? That a table or a stored procedure or even a function can...

Except that, unlike microservices, and I'm thinking specifically about web services here, database objects are tightly coupled by things like dependencies and foreign keys. Also database deployment may involve altering...

Good article. To master a platform like SSIS, it's important to understand it's evolution and to be at least somewhat familiar with the various iterations of the toolset. You never...

At least up until now, the problem with Query Store and AlwaysOn Availability Group secondaries has been that Query Store data is contained within each database, and if the database...