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

Loading podcasts

Fetching podcast shows and categories...

Loading page

Opening Radio and Podcast...

Ready2SERAustralia · College Radio, World Music

Live--:--

SQL Server Pain Relief: Office Hours with Brent Ozar Unlimited® Podcast Episodes Online | Radio and Podcast

Episodes

50 of 100 episodes

Office Hours - 1/2/2019

This week, Brent, Erik, Tara, and Richie discuss whether you need to premake a destination database in order to run sp_databaserestore, rest...

17:20Jan 2, 2019

Office Hours - 12/19/2018

This week, Erik, Tara, and Richie discuss disaster recovery, Python vs C# for SQL Server, whether you should perform log backups on primary...

29:43Dec 19, 2018

Office Hours - 12/12/2018

This week, Erik and Richie discuss TSQL classes, scalar functions, index reorganize vs rebuild, daily image backups on a fringe SQL server o...

20:41Dec 12, 2018

Office Hours - 12/5/2018

This week, Tara and Richie discuss deletes on heaps, Docker, using containers in production environment, advice for new DBA, downgrading ser...

25:51Dec 5, 2018

Office Hours - 11/28/2018

This week, Brent, Tara, and Richie discuss storing phone numbers in a database, forced parameterization, how AI will affect DBA jobs in the...

25:18Nov 28, 2018

Office Hours - 11/21/2018

This week, Brent, Tara, and Erik discuss update statistics, how soon it is safe to use a new version of SQL Server, VMs vs physical servers,...

30:07Nov 21, 2018

Office Hours - 11/14/2018

This week, Tara, Erik, and Richie discuss using Docker in dev environment, in-place upgrades, disaster recovery, the minimum amount of CPU a...

20:08Nov 14, 2018

Office Hours - 11/7/2018

This week, Tara and Richie discuss offline file database and log backup solutions, VSS database backups, monitoring products, parameterizati...

16:49Nov 7, 2018

Office Hours - 10/31/2018

This week, Brent, Tara, Erik, and Richie discuss load balancing, preventing auto-updates, compatibility modes, capturing deadlock chains wit...

27:25Oct 31, 2018

Office Hours - 10/24/2018

This week, Brent, Tara, and Richie discuss increasing a table's varchar field from 1 to 2, predicting how long CHECKDB should take, SQL Serv...

28:23Oct 24, 2018

Office Hours - 10/17/2018

This week, Brent, Erik, and Richie discuss small vendor apps, "Slow in the Application, Fast in SSMS?", virtualization, licensing, msdb back...

23:20Oct 17, 2018

Office Hours - 10/10/2018

This week, Brent, Tara, and Richie discuss splitting large database files across multiple files, security auditing solutions, what Brent is...

22:21Oct 10, 2018

Office Hours - 10/03/2018

This week, Tara and Richie discuss database corruption, CLR, DBCC issues, adding identity columns to databases, distributed transactions, tr...

33:57Oct 3, 2018

Office Hours - 9/19/2018

This week, Brent, Tara, Erik, and Richie discuss moving views between databases, Cluster Quorum File Share on AlwaysOn, checking for corrupt...

14:28Sep 19, 2018

Office Hours - 9/12/2018

This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, monitoring page life expectancy, cumulat...

24:37Sep 12, 2018

Office Hours - 9/5/2018

This week, Brent, Tara, Erik, and Richie discuss whether you should keep autoshrink on, AG multisite failovers, next version of SQL Server,...

30:51Sep 5, 2018

Office Hours - 8/29/2018

This week, Brent, Erik, and Richie discuss Microsoft cumulative updates, AlwaysOn Encrypted, query tuning, poison waits, the DBA career, CXP...

32:21Aug 29, 2018

Office Hours - 8/15/2018

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 col...

26:28Aug 15, 2018

Office Hours - 8/8/2018

This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy issues, problems with turning off CPU s...

33:17Aug 8, 2018

Office Hours - 8/1/2018

This week, Erik and Richie discuss monitoring tools, finding all unused tables across databases, query tuning, deleting vs hanging on to ind...

23:04Aug 1, 2018

Office Hours - 7/25/2018

This week, Erik and Richie discuss whether it's relevant to specify data in logs in SQL cloud environment, licensing, using canary tables on...

18:54Jul 25, 2018

Office Hours - 7/18/2018

This week, Brent, Richie, and Tara discuss their SQL server specialization, CPU-ready time, making SSIS changes globally rather than one at...

30:25Jul 18, 2018

Office Hours - 7/11/2018

This week, Brent, Richie, and Erik discuss best account practices for SQL Server, change tracking, disabled indexes, measuring queries to ga...

24:56Jul 11, 2018

Office Hours - 6/27/2018

This week, Brent, Erik, Tara, and Richie discuss using SQL Server 2016 vs 2017 for production environment, reporting, reindexing jobs, Azure...

29:51Jun 27, 2018

Office Hours - 6/20/2018

is week, Brent, Erik, and Richie discuss using foreign keys in a data warehouse, SQL Server virtualization on Hyper-V clusters, having all o...

29:28Jun 20, 2018

Office Hours - 6/13/2018

This week, Brent and Richie discuss using full-text index, Elasticsearch, server restart issues, sp_blitzfirst, Always On availability group...

24:50Jun 13, 2018

Office Hours - 6/6/2018

This week, Brent, Erik, Tara, and Richie discuss index maintenance, stats updates, the acquisition of GitHub, using linked servers to move t...

26:37Jun 6, 2018

Office Hours - 5/30/2018

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, a...

24:57May 30, 2018

Office Hours - 5/23/2018

This week, Brent, Tara, and Richie discuss relaying SQL Server performance updates to upper management, differential backups in AlwaysOn Ava...

23:10May 23, 2018

Office Hours - 5/16/2018

This week, Brent, Erik, Tara, and Richie are back in action again to and are discussing sys.dm_db usage stats, Availability Group troublesho...

25:46May 16, 2018

Office Hours - 4/25/2018

This week, Brent, Erik, Tara, and Richie to discuss cloud server disaster recovery, Availability Groups troubleshooting, SQL Server deadlock...

26:15Apr 25, 2018

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

This week Drew Furgiuele joins Brent and Richie to discuss patching, job interview suggestions, using PowerShell to solve various SQL Server...

34:55Apr 18, 2018

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

This week Edwin M Sarmiento joins Brent, Tara, Erik, and Richie to discuss high availability disaster recovery, migrating from on-prem serve...

32:39Apr 11, 2018

Office Hours - 4/4/2018 with Special Guest Pinal Dave

This week, Pinal Dave joins Brent, Tara, and Richie to discuss replication latency, partitioning tables, transactional replication, troubles...

36:46Apr 4, 2018

Office Hours - 3/28/2018

This week, Erik and Richie discuss what to do first at a new job that never had a DBA before, basic vs advance DBA skills, tempdb files, dow...

32:18Mar 28, 2018

Office Hours - 3/21/2018

This week, Brent, Erik, and Richie discuss replication, SQL Source Control with Git, installing service packs in cumulative updates in SQL S...

28:56Mar 21, 2018

Office Hours - 3/14/2018

This week, Brent, Tara, and Richie discuss VLF issues, SSAS tabular performance support, certification tests, query documentation tools, wha...

29:39Mar 14, 2018

Office Hours - 3/7/2018

This week, Brent, Erik, Tara, and Richie discuss database restores, opening a case with Microsoft, buying a pre-built server vs building you...

26:47Mar 7, 2018

Office Hours - 2/28/2018

This week, Erik, Tara, and Richie discuss cloning databases without 3-rd party software, tips for upgrading from 2005 to 2017, archiving dat...

30:01Feb 28, 2018

Office Hours - 2/14/2018

This week, Brent, Tara, and Richie discuss the lack of backward compatibility for SQL Server backups, deploying SQL Server on VMs with share...

29:52Feb 14, 2018

Office Hours - 1/31/2018

This week, Brent, Tara, and Richie discuss a simple way to fill tempdb, tools for retrieving data from transaction logs, tools for diagramin...

32:36Jan 31, 2018

Office Hours - 1/17/2018

This week, Tara, Erik, and Richie discuss 3rd-party tools for object-level restore, patching, stringing multiple CTEs, Meltdown and Spectre,...

30:28Jan 17, 2018

Office Hours - 1/10/2018

This week Brent, and Richie discuss validating backups using the backup set table, how to figure out if you're a Mid-Level or Senior DBA, ro...

27:38Jan 10, 2018

Office Hours - 1/3/2018

This week Brent and Richie discuss the latest big Intel CPU security flaw, distributed transactions, rebuilding indexes, SQL Server health c...

32:28Jan 3, 2018

Office Hours - 12/20/2017

This week Brent, Erik, and Richie discuss truncating & repopulating, failed logins, their choice for high availability, PowerBI, read commit...

30:29Dec 20, 2017

Office Hours - 12/13/2017

This week Tara, Erik, and Richie discuss virtualization, replication & mirroring, switching SQL service logins to an AD account, temporal ta...

31:14Dec 13, 2017

Office Hours - 12/6/2017

This week Brent, Erik, and Richie discuss filestream waits, what to use instead of filestream, Availability Groups & clusters, implicit data...

32:58Dec 6, 2017

Office Hours - 11/29/2017

This week Brent, Erik, and Richie discuss whether you need to know T-SQL to be a Senior DBA, if you should use SQL Server 2017 for productio...

33:47Nov 30, 2017

Office Hours - 11/22/2017

This week, Brent and Richie discuss the new Power BI Dashboard, designing a new backup structure, creating SSRS reports, the difference betw...

35:21Nov 22, 2017

Office Hours - 11/15/2017

This week Brent, Erik, Richie, and Tara discuss Docker, writing to different servers in different locations, SAN Replication, reducing the s...

34:43Nov 15, 2017