Відео

"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

Really appreciate these free sessions, they helped me so much in my optimization task as a junior backend dev with terrible knowledge of SQL Server.

Hi Brent, it looks that you are not famous enough yet for Google Gemini to know what you think about it. But keep on good work ! And thanks for the informative and entertaining videos.

It was two minutes, five minutes ago!

The joke about the temp = Public toilet, oh my God :)

Camera model and lens pleasee

Hi brent I want to ask somethin’ about using MacBook the person who fond of SQL Server and DBA is it a good or bad thing for daily usage in comparison to windows?

Yes! The error message, please!! I can't count how many times I am asking that question! The little things...

Sir, i would like to know if you have an idea on how to monitor the 25 servers that are already merged/replicated? What I'm only using is the Replication Monitor. SQL Server 2019

Can we have a video explaining SQL server pricing and differences/use-cases of different editions?

I have 8 10GB temp dbs :)

We store pdfs and excel files in our SQL tables at work, growing about 70GB per year. Good to know 2TB is still considered small-ish.

Great topic! I also like the analogies used in making things easier to understand 😅

www.youtube.com/@ITJOBsSmartNetwork?sub_confirmation=1

Shoutout to SSMS for Microsoft SQL! Recently had to switch to AWS through dataspell. Miss ssms so much!