ON the linked server.. well most of the time the user connecting to linked server is normally locked down to read only access and normally never to a production DB it's always a copy. That is what the main purpose is for a linked server in most cases. So linked server does NOT mean you have full access to the remote server unless the user you are connecting as does. And any good DBA knows this and sets up the remote server and user correctly.

Or just use the root drive and grant permissions for the service accounts :)

I do chores around the house during Teams meetings, helps me focus and listen vs. continuing coding etc. which leads me to stop listening. Suits me and my attention span 🙂 and keeps the house in shape

After all that you're up and recording with this kind of energy???

To be fair to them, 'should' is doing some heavy lifting

The SQL IaaS agent extension now does this for you on Azure VMs.

$10k for a MySQL license... They can keep it.

Sat here just doomscrolling after coming home from pub quiznight and after endless assorted videos you popped up. Hello. When did you start doing YT shorts?

Get paid to scratch someone elses itch :)

Yes can do transactional replication from AG listener, sp_redirect_publisher Subscriber as listener is nothing special, just like a regular subscriber

LOL.

...and those policies usually ignore actually securing the data. CEO is not an excuse for having access to PII, etc.

Lol . DBA's thinking they are the top tier in IT.😂

Changes to schema or database config should definitely go through source control with a code review. Not sure about the "break glass" aspect of the comment.

“Post mortem?” More like GET BACK TO WORK!

THE dr disrespect?

You got it boss 💪

Awesome performance presenation

how do I become you? By that I mean a SQL guru.

I believe using a Euclidean metrinization of k-fold contrivariant remnant tensor field would matriculate much more cogently.

Have you been in Postgres long enough to know what people need to know? How will you avoid being the Postgres equivalent of someone who does index maintenance every night but skips corruption checks? I'm trying to avoid becoming that myself!

Florian?

But for functionality and learning (&implementation) surely MS is immensely better

Postgres made point in time recovery hard? Wow. I can't even imagine it being hard. That's how easy SQL Server makes it.

You could just enable/disable a trigger, instead of dropping/creating it :)

Brent I love watching your Office Hours but my colleagues are wondering why there is a shirtless man in the hot tub up on my screen! NSFW 😛

I know it's a long shot if anyone answers this, but I'm following along here at 28:55, and my estimated subtree cost for the query with the order by is only 7 .1 something. I'm trying to figure out why, but I'm not having any luck. Any ideas?

Brent I feel so dumb! That was such a stupid question. I wanted to delete I was late. Anyway, demo was great and every dev agreed on switching to rcsi! Thanks as always for your time!

What is the point of KZfaq shorts ¯\_(ツ)_/¯ ?

I had to search for your channel on KZfaq and watch a few of your recent videos in order to get you back on my "suggested for you" list. That's how the algorithm works, I guess...

What if you don't use tiktok ???

I'm sure you're right, but I was distracted by you t-shirt. I want to spend more time with my dog too

I had to do a double take at your hat - for a second it looked like something... 1930s-ish xD

Good evening I'm your subscriber for last 2 months recently I'm working on a project where I need to update data about minimum 20 crores data with the help of inner join which takes almost 4 to 9 hours.can u please make a video how can we update huge amount of data in a effectively fast.

In India Tiktok is banned. Please allow us to participate some other ways.

I suggest you remove all AV/XDR from your databases and also leave the default admin accounts. Thanks.

I completely agree, but it's a slippery slope leading to putting your entire database in Hekaton.

Why would you make a clustered index on a GUID !!!

I didnt understand any of that. But i wish i did.

Very interesting their 💯

My work won’t pay for more than 16gb

Who is count distinct? 🤔

Good time to review their ci/cd pipeline 😅

“Well, Lanai’s power bill isn’t going to pay for itself.” ~Oracle

Somedays I wonder Brent 😂😂

I'm sorry it's hard to watch a video when I'm so distracted by the beauty behind you 😢😅

Probability of Insanity increases linearly with the number of years stuck working in the same database system.

Count "The Stink" oh AI captions 😂

Unfortunately this is Corp requirement for all VMs. Maybe they will change their tune.

If you work in any industry that uses crowdstrike, you mean, lol