Office Hours: I Feel Like An Amateur Edition
Вставка
- Опубліковано 1 чер 2024
- I went through your top-voted questions from pollgab.com/room/brento, but I had audio problems, then I had camera problems, hahaha. Here's what we covered:
00:00 Start
01:52 Does Time Really Exist: Hi Brent!
What is the best way to ETL? web application, SSIS, linked server, ...
03:55 MyTeaGotCold: What is your vision for what SQL Server will be like in 2030? I feel like a fool for thinking it will involve In-Memory OLTP.
05:49 mailbox: Hey Brent, What's your take on switching to specializing in Open Source Database platforms( on-prem or cloud)? What would the career impact be? Seems like there are a lot of new jobs focusing on open source technologies, such as python, linux, postgreSQL,mariaDB, mongo, etc..
07:03 DBANoob: Hi Brent, our company has been adopting Objective Key Results (OKR) and each team is tasked with creating new OKRs. Are you familiar with OKRs? Do you have any suggestions for a database administration team?
10:38 mailbox: What's the value of high reputation/achievement on dba.stackexchange.com or sqlservercentral.com? Have you ever seen that land someone a job or negotiate a raise?
11:58 Joe Gleason: Hello Brent! Since you have been performing PolGab for many years now, do you perceive the quality of the SQL Server questions being asked going up or down? I scratch my head sometimes, but I have not been at this for a very long time.
18:57 Carlini Tassio: Recently start tu learn about IA and saw about copilot being used in many microsoft tools, you think studio in the future will be launched with copilot and can help people work with data to use T-SQL?
20:31 Chevy 409: What's your favorite vintage American car? - Наука та технологія
"Watch Brent Tune Camera Settings"... jokes aside, keep up the fantastic work.
Hahaha, yeah!
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)
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.
Yeah, translations will probably get a lot of interest, even though it could be done just as effectively on app servers.
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?
I’d ask if they can show you deadlocks lasting for 2 days. My complete guess would be blocking may have taken place that lasted that long, then resulted in a deadlock. Deadlocks also need to rollback the lowest cost or lowest priority query too which could also add to time.
Whilst the deadlock scanner executes every 5 seconds by default, the queries themselves may take longer, it may be that that’s getting confused here.
Run a query for a day, it deadlocks, has to rollback which takes another day as a wild example.
@@James-gu7di thank you for your reply buddy, i am clear
Deadlocks fix themselves automatically within 5 seconds. They were probably thinking blocking.
@@BrentOzarUnlimited yeah thought the same , thank you brent