Are you experiencing challenges managing Very Large Databases (VLDBs), or anticipate challenges with future growth? In this episode, we are joined by Aaron Hayes to discuss the practical advice on managing very large databases in SQL Server, focusing on common problem areas we have found, along with our own experiences. Topics include storage layout decisions, unique tuning challenges, HA/DR implications, and database restores, along with the challenges of getting backups, re-indexing and DBCC checks into your maintenance windows. No comparisons here -- we are sure you will enjoy the discussion regardless of your database size.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/03/12/episode-163-very-large-databases. Have fun on the SQL Trail!
Episode 156: Social Intelligence
Episode 155: Data Science
Episode 154: Test Driven Development
Episode 153: SQL Trail 2018 Retrospective
Episode 152: Do you use Analysis Services?
Episode 151: Azure SQL Database Managed Instance
Episode 150: The SQL Data Partners Team
Episode 149: Managing lots of databases
Episode 148: High Performance SSRS
Episode 147: Always Encrypted
Episode 146: SQL Trail Speakers
Episode 145: Is SSIS still relevant? Part 2
Episode 144: Is SSIS still relevant? Part 1
Episode 143: Transitioning from DBA to Data Warehouse Architect
Episode 142: Do You Have a HEAP of Hurting?
Episode 141: Wait, Wait, What?
Episode 140: Why data types matter
Episode 139: Getting Started with SQL Server in Azure
Episode 138: Meeting of the Minds
Episode 137: You want to work with Analytics?
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast