Тёмный

Office Hours: Ask Me Anything About Microsoft Databases 

Brent Ozar Unlimited
Подписаться 45 тыс.
Просмотров 3,6 тыс.
50% 1

Post your questions at pollgab.com/room/brento and upvote the ones you'd like to see me cover. Here's what we discussed today:
00:00 Start
00:38 Steve E: Hi Brent, Have you ever come across any environment using Application Roles? If so, what was the use case?
02:05 Broken_hearts_are_for_assholes: You discourage the use of AUTO_SHRINK because of fragmentation. But then you say "Stop Worrying About SQL Server Fragmentation", especially on SSD. So is that OK to use AUTO_SHRINK on Azure SQL Database that use SSD? I've been doing that for 6 months now and I see problems.
02:49 Ol' CornCob: I attempted to hit the StackOverflow database on smartpostgres. I couldn't figure out what I was missing in my DBeaver connection settings, just got "SSL error: Connection reset". I tried a few SSL settings but no dice. Is there a how-to-guide that could help out Ol' CornCob?
03:31 Eduardo: What are your pros / cons of running SSIS on your one and only single SQL server vs a dedicated server? As bad as SQL instance stacking?
05:13 MyTeaGotCold: Where can I read up on the risks of having a database owned by someone who is going to leave my business? Google failed me and I what I could invent myself didn't scare me. It's not in your First Responder Kit URL either.
05:53 Robinson511: When opening SSMS Activity Monitor state automatically changes to Paused. The small Icon on SQL Cylinder in Object Explorer shows a question mark. An outside monitoring tool also fails reporting The RPC Server is Unavailable.Unable to find solution that works. Would like help.
08:48 Insecure DBA: New 3rd party app requires a cert for SSL connections to our SQL server. Will adding one require any additional work for all the other databases on the server?
09:36 Romullo Araujo: Hi Brent, Is there any other way to dynamically save the stored Procedure results into a temp table without knowing the structure of the table and also not using OPENROWSET?
10:07 Yusef: New Microsoft keyboards are adding a ChatGPT button. Good / bad idea? Will you be purchasing a Microsoft keyboard with this new button?
11:28 Dimitra M: How do the DBA job opportunities differ for when a DBA specializes broadly but shallow vs narrowly but deep?
13:08 Golshifteh F: SQL 2019... Updating fact table with linked server query takes over 20 hours. Does this prevent transaction log from clearing on both sides? Is NOLOCK helpful here?
14:08 Soji: Is rows per page a good table metric? Is it actionable?
14:27 Berglind I: What is your favorite app for generating synthetic data needed for query testing of large data in dev environment?
15:10 DBA Emeritus: I'm having trouble with deadlocks in a proc that inserts records and then immediately updates the same records to calculate an expression based on identity values. I've tried every fix I could divine from your videos and sp_BlitzLock + RCSI. Any advice for this specific pattern?
16:08 Eduardo: Do you ever forsee Azure SQL DB growth eclipsing boxed SQL Server?

Наука

Опубликовано:

 

14 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 11   
@FlaggedStar
@FlaggedStar 4 месяца назад
05:11 The question could have done with being shorter, but I'm surprised that nobody in chat pointed out that Brent's answer was to give a URL that the question says doesn't have the answer.
@BrentOzarUnlimited
@BrentOzarUnlimited 4 месяца назад
@FlaggedStar sorry, I should have been more specific - you have to actually read the words & links on the page. You can't just look at the pictures. Hope that helps!
@SuperCharlesPeter
@SuperCharlesPeter 3 месяца назад
Hi Brent. I can't find your reference to Michael Googlay. What is the correct spelling please?
@BrentOzarUnlimited
@BrentOzarUnlimited 3 месяца назад
It's French - Googlé
@simondungeon1218
@simondungeon1218 3 месяца назад
Which car do you own Brent ?
@BrentOzarUnlimited
@BrentOzarUnlimited 3 месяца назад
I have a few right now: a 2024 Land Rover Defender, a 1964 Porsche 356 SC, an 86 Ferrari 328 GTS, a 71 VW Type 3 Squareback, and a 56 Porsche Speedster replica.
@totanlj18
@totanlj18 4 месяца назад
02:06 Maybe he/she confused data fragmentation with index fragmentation (That recently I saw a video of Brent saying that is more important update statistics than make the index reorganize-rebuilt when you have it on SSD)
@user-jg1yq7vs4v
@user-jg1yq7vs4v 4 месяца назад
I didn’t know Brent was gay
@BrentOzarUnlimited
@BrentOzarUnlimited 4 месяца назад
Close! Pansexual.
@user-jg1yq7vs4v
@user-jg1yq7vs4v 4 месяца назад
I didn’t know Brent was gay
@BrentOzarUnlimited
@BrentOzarUnlimited 4 месяца назад
Close! Pansexual.
Далее
Office Hours: The Question Isn't The Problem Edition
21:16
Office Hours: Lumberjack Edition
34:00
Просмотров 3,3 тыс.
КТО ПЕРВЫЙ ДО МОСКВЫ / 3 СЕМЬИ
29:30
Regular Season vs. PLAYOFFS part 2 #pavelbarber
00:14
How to add database to an availability group
26:05
Просмотров 7 тыс.
Always on Availability group (AG) cluster in SQL Server
31:40
PowerBI and Fabric Q&A with Eugene Meidinger
23:42
Просмотров 2,6 тыс.
Office Hours: I Don't Have All the Answers
13:17
Просмотров 1,4 тыс.
Office Hours: The Long One
49:47
Просмотров 3,8 тыс.
Office Hours: 3 Answers at Lake Michigan
6:33
Просмотров 1 тыс.
Office Hours in Telluride Colorado
16:38
Просмотров 2,2 тыс.
Query Store Best Practices
50:18
Просмотров 8 тыс.
Office Hours: Creepy Vancouver Edition
12:07
Просмотров 2,1 тыс.
Holographic transparent flexible LED panel.
0:20
Просмотров 3,3 млн
Holographic transparent flexible LED panel.
0:20
Просмотров 3,3 млн
wireless switch without wires part 6
0:49
Просмотров 3,6 млн