Steve I very much appreciate the effort you and the crew take to keep our information both secure and out of the hands of marketers.  At this point, I've lost...

There's always going to be a place for some form of a DBA, changes in technology are just going to change WHAT the day-to-day work looks like.

Reading David.Poole's comment made...

Heh, it's bad enough getting people (myself included!) to keep documentation up-to-date, imaging managers' frustration (and the workers) trying to keep two different formats (human-readable / automation-agent-AI) of the same...

I've done the DP900 data fundamentals, DP300 Database administrator, AZ900 Azure Fundamentals & AZ104 Azure administrator

Can't say that they've enhanced my career but my company were prepared to pay...

The problem is that the thumbprint of the certificates is different, because the certificates are different.

Easy fix, you need to take the backup of the certificate you created on Prod...

I've only been to a few conferences (SQL in the City way back when, PASS twice now, a few SQL Saturdays, and PASS Chicago) so far.  Generally if I don't...

So by default a SQL Audit will capture ALL activity by all Logins, with no filtering.  The filters are for excluding users / particular actions / individual databases (if you...

I'm not sure what you're trying to do here.

You have a SQL Audit, you have an AD Group with members, and you're trying to filter on something, but I'm not...

I think I see the disconnect between what you're saying and what I'm saying.  I'm coming at this from a "production DBA" mindset, where I don't normally develop code for...

Steve,

I'm torn on the vibe coding point you raise.  On the one hand, at least if the code is coming from a person, it's possible to go to them and...

David, I'm not one of those "reject AI output out-of-hand" people (and I know you weren't calling me out, either,) but I do take the comment Steve made in the...

I'm going to buckle down and watch the Satya interview you linked later, but right now I'm very firmly in the "distrustful of so-called AI" camp.

I think part of the...

I'd say the biggest downside / risk of not using encryption between the clients and the SQL Server would be the possibility of someone "sniffing" your network traffic, getting a...

So clarifying a few things here...

TDE is not a "service," it's a method to encrypt the database(s) both in-use and at-rest (ie, SQL Server service stopped.)  This generally has a...

On my 1st Big Data project, our POC was running fine, was scalable, and impressed everyone who saw it.

It didn't impress the architects.  "We are an Oracle shop. What...