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 38: SQL Server 2016 Feature Review
Episode 37: PowerBI and the DBA
Episode 36: SQL Server Virtual Machines in Azure
Episode 35: Position Yourself to Better Opportunities
Episode 34: In-Memory Tables
Episode 33: From Developer To DBA
Episode 32: Up Your Game With PowerShell!
Episode 31: What Has Virtualization Done To My Database?
Episode 30: The Best Investment You Can Make
Episode 29: You Thinking What I Am Thinking?
Episode 28: How Do You Know There Is A Problem? Baselines!
Episode 27: Testing Changes Before You Break Production
Episode 26: DevOps for the Database--Everyone is Doing it, Right?
Episode 25: Stretch Database
Episode 24 Query Store
Episode 23: IO, IO, It’s Off to Tune We Go
Episode 22: Eight Years of sp_whoisactive
Episode 21: Azure Data Factory
Episode 20: the Role of Mentors
Episode 19: How Solid State Disks Can Help SQL Server
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