Видео

Oh man!! I was so hoping my question was going to get wiped LOL. After I submitted it, I saw another of your videos where you went into page splits and fill factors. You said exactly where my brain went too. Yes; it's a cool thing you can do but 'cool' isn't where you need to spend your time. I so hope I make it to one of your in person/live courses. Please keep up the amazing work!!!!!

Good questions. At times the picture looked like a Sony Wii and other times it looked like a summoned spirit from a Ouija board. Not quite the "uncanny vally" but weird. Thank fully still identifiable as fake. No one would cast you as Vinnie Barbarino from "Welcome Back Kotter"

omg its Brent AI

4:51 my friend says maybe the existing index has the key columns in the wrong order, because missing index recommendations don’t necessarily list the key columns in order

I mostly love videos with timestamps, but all the same great video

Thanks for the free class, I couldn't see this document in the first responder kit that I downloaded. Is there a different kit? Or is the document somewhere else? Thanks!

Nice office

2:32 if support and security patches weren’t problems to solve I would still have servers on 2008

01:06 Does Brent also prefer log shipping to snapshot isolation? I don't know how the costs compare with that of database snapshots, but all of his arguments against database snapshots seem to apply to snapshot isolation. In both cases, you're out of date from the moment you run a query and you're paying extra performance costs to maintain the snapshot. Snapshot isolation is easier to keep up to date and doesn't need synonyms, but you're also paying for it at all times.

Yes, learned something. Thanks for the heads up on SQL 2022. "Insert a negative Zero into a decimal or numeric" I'm a bit more hesitant to put our PeopleSoft on 2022 now. It took almost two years to find that bug?

01:19 If snapshot is populated with “old” data, then inserts are out of scope. We get “old” data by deletes and updates, don’t we?

The C in Winchester is a G. No way you could convince me otherwise. Lake Michigan looked cold!

Another good vid, thanks Brent. By the way, you've got red on you.

Great video. Learned quite a lot. Time to go optimize my maintenance jobs! 😅

"Why are you carrying a ham" thud

While that Map reference was terrifying, it was surprisingly effective. 😎

Cloud changes every day

I am moving over to SQLServer from the SYBASE world. In many cases we used non clustered indexes as our PK and clustered indexes to reduce contention for the last page. In current MS SQL is best practice to clustered on the PK ?

Speed Round of issue we don't have since moving to letting Microsoft manage our databases. Pro's and Con's of course, but damn, I don't miss having to worry about this stuff.

That buzzer is way louder than your vocal audio and I never want to hear it again.

Unfortunately the Shao Kahn / NoobSaibot joke went unnoticed. Guess Brent isn't a Mortal Kombat fan. 😀

my ears...

On the cost of labor vs licensing - my Father In Law told me a story about a data migration that they had to do, where the Vendor had some proprietary application and database system and a separate proprietary tool for exporting the data. They wanted $X million (or some other relatively obscene number) to license the export tool just for this project. FIL decided that for the amount of data, it was cheaper to hire something like a dozen uni students to copy-paste the data from the old system to the new system for 2 weeks. The Vendor accused them of reverse engineering the database, but backed down when they saw the receipts

have you tried goat simulator?

Fallout? Really??? I thought you were kidding. Couldn't get past the first 30 minutes of that total piece of dog dung.

A.I. - more interesting answer than "our future brains" who will tell us what to do and when.

The old interplay PC Fallout games from the 90s are amazing CRPGs and all turned based. Might be more your speed.

When you gonna get rid of the granny lights, BrentO?

Great episode Brent. By the way - what are you thoughts on dBase? 😅

Visual Fox Pro ... bruhhh

super appreciative for you and all of the content you produce. many thanks Brent!

There is not enough blogs on Postgress and material

"Watch Brent Tune Camera Settings"... jokes aside, keep up the fantastic work.

You as a DBA don't want Copilot on the SQL server, but translations/generations on the SQL server probably ensures another core or two that MS can make you pay for,, and they're happy to see who'll bite.

Hi Anyone , i have a doubt .Do deadlocks persist more than 1 hour ? .I argued with my seniors that it will be only 5 seconds but they shut my mouth by saying they have seen 2 days of Deadlock in their previous environment(legacy versions) , am i missing out something?

18:30 The abbreviation for “Artificial Intelligence” would be spelled “IA” rather than “AI” in both Italian and Spanish. (It’s definitely true in Spanish. It should be the same in Italian, but I admit I haven’t actually checked discussions about it in Italian and Italian is more prone to adopting anglicisms than Spanish, so I might be wrong there)

Answer to question #1: Pants. The first thing I reach for is pants.

for the DB and AG question @4:04...I would have just said, use an AG listener and point to that DNS entry.

Mailbox - the 14:53 - Broadcom's decision has made us, one small group, look at LINUX. The cloud turns a capitol expense into an operating expense allowing for faster hardware changes (for a price. Plus we do not scale up or down often) HOWEVER mission should drive on-prem vs. cloud "in my opinion" Why? Cloud adds many more pieces that can go wrong or break. If it is ok to have the production system down for how ever long it takes another company to fix the cable, DNS entry, or data center then ok. Ask if TEAMS, OUTLOOK or another service has ever been slow or had an outage. For me 9-1-1 emergency system will be the last thing put in the cloud as our primary. Also if going off prem, con sider two sites - else it is still a single point of failure.

For that “why” question at 6:23: I wager even Microsoft wouldn’t “know”. You would really need to ask the original programmers employed by Sybase back in the mid-1980’s.

Often the case with ERP systems is that the major vendors are moving to the cloud and direct database access through customer developed enhancements cannot be tolerated in a shared cloud infrastructure. Epicor Kinetic ERP is a prime example. They are blocking use of key .Net libraries that provide direct database or filesystem access.

very hairy chest there Brent!

Anonymous Indians😢 (AI)

Guitar string for the painting

Excellent. Nice combination of good advice and practicality. Good work!

Hello Brent, Really nice videos you've got there. You're a great orator. I really wanted to know based on your overall years of experience, can you create a pie chart for creating distribution of most important points (as labels) and their weightage (as percentage) when it comes to performance tuning and optimization? Also, if I am asking too much over here, then please reply over here in comment section like the following. Indexes : 25%, statistics : 35% and so on .... Thank you for the work that you put in. :)

Sometimes an index is so badly fragmented that the recommendation query assumes that it must not have one.

Count Clipula

Use floss or fishing line to remove the painting by running it behind it and using a sawing motion. I blow dryer or heat gun would also soften the adhesive.

Hi there