SQL Server Pain Relief: Office Hours with Brent Ozar Unlimited®-logo

SQL Server Pain Relief: Office Hours with Brent Ozar Unlimited®

Technology Podcasts >

SQL Server Pain Relief: Office Hours is like listening in while patients bring their SQL Server pains to the emergency room, and the doctors give their opinions. Join your host, performance tuning specialist Brent Ozar, and his highly-qualified SQL Server Medical Team as they give you an inside look into some of the best solutions to your server problems. Tune in to get the best tips for performance tuning, virtualization, disaster recovery and much more. When you’re ready to do your own surgery, grab our free First Responder Kit at www.BrentOzar.com.

SQL Server Pain Relief: Office Hours is like listening in while patients bring their SQL Server pains to the emergency room, and the doctors give their opinions. Join your host, performance tuning specialist Brent Ozar, and his highly-qualified SQL Server Medical Team as they give you an inside look into some of the best solutions to your server problems. Tune in to get the best tips for performance tuning, virtualization, disaster recovery and much more. When you’re ready to do your own surgery, grab our free First Responder Kit at www.BrentOzar.com.
More Information

Location:

United States

Description:

SQL Server Pain Relief: Office Hours is like listening in while patients bring their SQL Server pains to the emergency room, and the doctors give their opinions. Join your host, performance tuning specialist Brent Ozar, and his highly-qualified SQL Server Medical Team as they give you an inside look into some of the best solutions to your server problems. Tune in to get the best tips for performance tuning, virtualization, disaster recovery and much more. When you’re ready to do your own surgery, grab our free First Responder Kit at www.BrentOzar.com.

Language:

English


Episodes

Office Hours - 9/19/2018

9/19/2018
More
This week, Brent, Tara, Erik, and Richie discuss moving views between databases, Cluster Quorum File Share on AlwaysOn, checking for corruption, rebooting/restarting SQL server after applying cumulative updates, how many drive letter to use for a VM, decimal precision and scale value settings on SQL Server 2016 vs 2008, nested views, and Tara's recent booze cruise.

Duration:00:14:28

Office Hours - 9/12/2018

9/12/2018
More
This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, monitoring page life expectancy, cumulative update issues, when to change MAXDOP, doing SQL Server install on AWS, connecting to SQL Server instance on a virtual box from the desktop where the virtual box is running, and what real DBAs drink.

Duration:00:24:37

Office Hours - 9/5/2018

9/5/2018
More
This week, Brent, Tara, Erik, and Richie discuss whether you should keep autoshrink on, AG multisite failovers, next version of SQL Server, SQL Server 2017 Vulnerability Assessment, SELECT INTO vs INSERT INTO, using Node.js with SQL Server, Using PowerShell for DBA tasks, the future of SQL Server for Linux, memory gateway query compile, VB.NET, patching, and more!

Duration:00:30:51

Office Hours - 8/29/2018

8/29/2018
More
This week, Brent, Erik, and Richie discuss Microsoft cumulative updates, AlwaysOn Encrypted, query tuning, poison waits, the DBA career, CXPACKET waits, THREADPOOL issues, reporting services, and more.

Duration:00:32:21

Office Hours - 8/15/2018

8/15/2018
More
This week, Brent, Tara, Erik, and Richie discuss error log issues, issues with moving a 2-node AG to a different VM, adding a rowversion column gotchas, using indexes, Docker & CI/CD, RESOURCE_SEMAPHORE query compile, table locks, Query Store, and best places to eat in NYC.

Duration:00:26:28

Office Hours - 8/8/2018

8/8/2018
More
This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy issues, problems with turning off CPU schedulers, coordinating two jobs across servers, adding additional log files to an almost-full partition, tips for getting a new SQL Server DBA job, using alias names for SQL Servers, database going into suspect mode during disaster recovery, SQL Constant Care "Too Much Memory" warning, index operational statistics, running newer versions of SQL Server...

Duration:00:33:17

Office Hours - 8/1/2018

8/1/2018
More
This week, Erik and Richie discuss monitoring tools, finding all unused tables across databases, query tuning, deleting vs hanging on to indexes, sharding databases, query editors, aggressively-locked indexes, why a plan would not be in the plan cache, and Richie's current housing situation.

Duration:00:23:04

Office Hours - 7/25/2018

7/25/2018
More
This week, Erik and Richie discuss whether it's relevant to specify data in logs in SQL cloud environment, licensing, using canary tables on Availability Groups, how Entity Framework limits tuning, reusing older databases, and more.

Duration:00:18:54

Office Hours - 7/18/2018

7/18/2018
More
This week, Brent, Richie, and Tara discuss their SQL server specialization, CPU-ready time, making SSIS changes globally rather than one at a time, creating an Always On AG farm, Azure managed instances, going from log shipping to Availability Groups, tracking folks that executed queries, moving databases into Availability Groups, an exciting update to SQL Server 2016, and Brent's upcoming move across country.

Duration:00:30:25

Office Hours - 7/11/2018

7/11/2018
More
This week, Brent, Richie, and Erik discuss best account practices for SQL Server, change tracking, disabled indexes, measuring queries to gauge their speed, overcoming issues between Management Studio and integration services, deadlocks and long-running processes, query tuning, and lock escalation.

Duration:00:24:55

Office Hours - 6/27/2018

6/27/2018
More
This week, Brent, Erik, Tara, and Richie discuss using SQL Server 2016 vs 2017 for production environment, reporting, reindexing jobs, Azure vs Amazon, parameter sniffing, creating custom alerts for agent jobs, activity monitor, troubleshooting SQL Server 2014, replication, turning off auto-updating stats on tempdb, and why Brent can't get a tan.

Duration:00:29:50

Office Hours - 6/20/2018

6/20/2018
More
is week, Brent, Erik, and Richie discuss using foreign keys in a data warehouse, SQL Server virtualization on Hyper-V clusters, having all of your SQL Server instances under the same active directory account, updating stats, changing job ownership, why you would want to go to SQL Azure, and why they have an issue with replication.

Duration:00:29:28

Office Hours - 6/13/2018

6/13/2018
More
This week, Brent and Richie discuss using full-text index, Elasticsearch, server restart issues, sp_blitzfirst, Always On availability groups, issues with users connecting to SQL Server, learning the basics of Python on SQL Server 2017, VMWare Hyper-V configuration issue, and more.

Duration:00:24:50

Office Hours - 6/6/2018

6/6/2018
More
This week, Brent, Erik, Tara, and Richie discuss index maintenance, stats updates, the acquisition of GitHub, using linked servers to move tables across, talking to developers as a DBA, the best cloud option, setting the number of tempdb files, and their favorite SQL Server features.

Duration:00:26:37

Office Hours - 5/30/2018

5/30/2018
More
This week, Brent, Erik, Tara and Richie discuss severity 16 error warning, best way to move databases from SQL 2008 R2 to SQL Server 2014, adding Analysis services to a cluster, taking to higher management, deadlocks in a transaction log shipping setup, syncing date between an on-prem and Azure SQL DB server, log backups, renaming SQL Server VMs, Docker, SP_Blitz question, and more.

Duration:00:24:56

Office Hours - 5/23/2018

5/23/2018
More
This week, Brent, Tara, and Richie discuss relaying SQL Server performance updates to upper management, differential backups in AlwaysOn Availability environment, replication, Troubleshooting THREADPOOL Waits, an acceptable amount of preemptive waits, Postgres, and the technologies Richie is working with these days.

Duration:00:23:10

Office Hours - 5/16/2018

5/16/2018
More
This week, Brent, Erik, Tara, and Richie are back in action again to and are discussing sys.dm_db usage stats, Availability Group troubleshooting, ASYNC Network IO issue, reasons for using a contained database, whether you need to add more CPUs if facing THREADPOOL waits, auto-tiering tempdb, and query tuning.

Duration:00:25:46

Office Hours - 4/25/2018

4/25/2018
More
This week, Brent, Erik, Tara, and Richie to discuss cloud server disaster recovery, Availability Groups troubleshooting, SQL Server deadlocks, slow tempdb latency, migrating to Azure, SQL Server 2017 gotchas, how to set up your dev environment when looking for a job, best allocation unit size for disks hosting data files and good replacement for linked servers.

Duration:00:26:15

Office Hours - 4/18/2018 with Special Guest Drew Furgiuele

4/18/2018
More
This week Drew Furgiuele joins Brent and Richie to discuss patching, job interview suggestions, using PowerShell to solve various SQL Server issues, roles and responsibilities of a SQL or a database architect, enabling query store on production servers, SARGability, moving SSRS from the main production server, tempdb issues, Availability Groups troubleshooting, Drew's upcoming Powershell class, and more.

Duration:00:34:55

Office Hours - 4/11/2018 with Special Guest Edwin M Sarmiento

4/11/2018
More
This week Edwin M Sarmiento joins Brent, Tara, Erik, and Richie to discuss high availability disaster recovery, migrating from on-prem server to Amazon's RDS, AlwaysON Availability Groups, auto-growth issues, rebuilding vs dropping/re-creating indexes, log shipping, using Service Broker with AlwaysOn, updating stats issues, VLF counts, measuring transaction log usage, upgrading AlwaysOn versions, and much more.

Duration:00:32:39