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 116: Are people still using PSSDiag?
Episode 115: The Companero Conference Retrospective
Episode 114: How do you start consulting?
Episode 113: Standing on the shoulders of giants
Episode 112: Keeping up with patching
Episode 111: How do you prepare for conferences?
Episode 110 How do I build trust with my team
Episode 109: To certify or not to certify?
Episode 108: The Future of the Relational Database
Episode 107 BI for the Little Guy
Episode 106 Temporal Tables
Episode 105 When is enough, enough?
Episode 104: Keeping up with technology
Episode 103 Plan Reuse
Episode 102 Monitoring Availability Groups
Episode 101 Inspecting a new Database
Episode 100 Role Reversal
Episode 99 Imposter Syndrome
Episode 98: The first change you make
Episode 97 Transactional Replication
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