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 81 Indexes Part 1
Episode 80 Containers
Episode 79 SSIS Catalog
Episode 78: Conversion to 2016
Episode 77: New Reporting Options
Episode 76: Availability Group Improvements
Episode 75 Storage Testing
Episode 74: 2016 Year in Review
Episode 73: Performance Tuning
Episode 72: Test Automation in BI
Episode 71: BI Tools of the Trade
Episode 70 SQL Server on Linux
Episode 69: Our SQL Server Setup Checklist
Episode 68: SSIS Administration
Episode 67 Dear Developer
Episode 66: Microsoft's Professional Program
Episode 65: Do you have good data architecture?
Episode 64: Certifications and Career Development
Episode 63: New Data AvailabilityFeatures in SQL Server 2016
Episode 62: Ask Me Anything--Cortana Intelligence Suite
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
Lex Fridman Podcast
Elliot in the Morning