Channel Title: Brent Ozar Unlimited Channel Description: Learn to make Microsoft SQL Server go faster. <video> Where to Put Backups Description: #sqlserver #sql #dba #database #azure #microsoft #hacks #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careertiktok #CapCut #Postgres 09:39 Josef: Should backups be stored on a separate network drive rather than the SAN used for the databases in an SQL Server failover cluster? What are the pros and cons of this approach? Where to Put Backups </video> <video> A Long One on "Bad" Managers Description: #sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql 13:21 Ricardo: How should I handle my manager who insists on changing production data himself to fix immediate application issues. When all my advice and coaching is ignored. A Long One on "Bad" Managers </video> <video> Office Hours in my Vegas Backyard Description: I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second gin & tonic. I, uh, might have lost my temper on the last one. Here's what we covered: 00:00 Start 02:38 Frozt: are you familiar with SQL Server assemblies? and if they can cause assertion or IAM corruptions? Thank you Happy New year Brent 04:41 SQL_Linux: Hey Brent, My company is wanting to use AI for data analytics. What common misconceptions have you seen companies hold concerning using AI to find "insights"? 07:12 Culloden: my company is small and we don't have devs for reporting. Finance team use prod for report development bc data is near real-time. I want to move them to a dev instance, but data can only be a few hours old. What are options for this? we only use simple recovery model in prod. 09:38 App Developer At Crossroads: When did you decide to stick with SQL Server? After 3 jobs over 8 years all with quite different tech stacks I'm feeling like its time to become an expert in something (tech and business domain)/have a long stay at a company so I can become more and more senior/have a big impact. 11:24 MyTeaGotCold: Did resumable online index rebuilds change any of your opinions on or approaches to index maintenance? I love them too much. </video> <video> Setting Max Memory Description: #sqlserver #sql #dba #database #azure #microsoft #hacks #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careertiktok #CapCut #Postgres 10:54 chris: Hi Brent. For setting max mem you suggest leaving 4GB or 10% (whichever is more) for the OS. Can you help me understand why more memory is needed for the OS as you scale up the RAM? For example, with 200GB of RAM why would one need 20GB reserved for the OS instead of just 4GB? Setting Max Memory </video> <video> Tracing Apps Description: #sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql 07:36 Craig: If you want to find out what procs get called when a user does something on an application, what tools do you use? Profiler, Extended Events, or something else? Tracing Apps </video> <video> connection Timeouts Description: #sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql 07:10 Dopinder: How do you like to troubleshoot Connection Timeout errors at the client? We originally thought ours was a server side issue but turns out the VM / Client had a CPU pressure issue. connection Timeouts </video> <video> Postgres vs SQL Server Description: #sqlserver #sql #dba #database #azure #microsoft #hacks #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careertiktok #CapCut #Postgres 08:52 Dynomutt: How does PostgreSQL query tuning compare with SQL Server query tuning? Postgres vs SQL Server </video> <video> Learning the FRK Description: #sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql 01:25 Josef: Our app slows under heavy load, but Task Manager shows no high CPU/memory on the DB server. Suspect network issues or heavy disk reads by SQL Server. How can I identify the root cause? Which First Responder Kit stored procedures should I use first? Learning the FRK </video> <video> Downsizing Datatypes Description: #sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql 01:35 SQL_Linux: Brent! I have a server that has many tables using nvarchar(MAX) columns. Most of the nvarchar(MAX) cols contain a max datalength of 80 or less. Will i see performance boost by changing size of nvarchar cols to 100? E.G. will this prevent data being written to off-row pages? Downsizing Datatypes </video> <video> Mastering New Tools Description: #sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql 20:02 KyleDevDBA: How do you go about trying new skills/concepts that you are learning? When trying to learn something, I often get stuck at the "I have a hammer, where can I find a meaningful nail to hit" stage. Mastering New Tools </video> <video> Biggest Servers Description: #sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql 08:26 ayed: Hello Brent, thanks for providing free content! Throughout your career, what is the maximum number of CPU cores and the largest amount of memory you've encountered in an operational SQL Server VM? Biggest Servers </video> <video> Copilot Queries Description: #sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql 09:11 Mary Puppins: What's your opinion of the new copilot support in azure SQL DB for generating queries from English prompts? Seems like this could generate some inefficient queries. Copilot Queries </video> <video> Bypassing Constraints Description: #sqlserver #sql #dba #database #azure #microsoft #hacks #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careertiktok #CapCut #Postgres 12:21 MustangKirby: Loading a table with 93M records. There is a check constraint enforced by a UDF which includes data access so it's slow. I can disable the constraint but then it takes forever to make it trusted again. Is there a way to directly update is_not_trusted in sys.check_constraints? Bypassing Constraints </video> <video> Extended Events Description: #sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql 00:37 MyTeaGotCold: When was the last time you did something interesting with Extended Events? Extended Events </video> <video> Show Me the Query Description: #sqlserver #sql #dba #database #azure #microsoft #hacks #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careertiktok #CapCut #Postgres 08:15 VegasDBA: Hey Brent! I set up a distributed AG to a reporting server and when I change a certain proc on that reporting server from linked server to cross DB connections, the query runs forever. A single table with 1.7m rows is the culprit. LS: 6s. XDB: never finishes. No errors. Show Me the Query </video>

Contacts and Links

Description

Learn to make Microsoft SQL Server go faster.

Videos from channel