Published on December 18th, 2014 | by Warner Chaves7
Presentation: Best Practices for SQL Server Very Large Databases (VLDBs)
I had the great opportunity last April to present “Best Practices for SQL Server Very Large Databases” for SQLSaturday in Chicago. I got great attendance and the audience made some great comments and had great questions as well. During the preparation stage I asked every Database Consultant at Pythian what were some of their favorite tips/tricks/techniques to manage SQL Server Very Large Databases. As the amount of data we accumulate continues to get bigger this is becoming more and more of a challenge for every company.
I compiled all of their advice and came up with these categories that I called the VLDB Pyramid:
- Data Safety
Each tip or trick falls into one of these, either about handling corruption, implementing compression, picking the proper data types, etc.
At this point I have added many annotations to the main points I cover in the presentation. If you’re currently being challenged with managing one of these Very Large Databases then I invite yo to check the presentation. There might be a thing or two that you might not have thought about and might help you out now or some day in the future!
Here’s the link: Best Practices for SQL Server Very Large Databases
Feel free to add any comments or questions to this post. It’s a very broad topic and there’s a lot to cover, I find that I still continue to learn about it to this day.
UPDATE: as a follow up to the feedback I’ve received from this presentation I created a related post of the “Top 10 Must-do Items for your SQL Server Very Large Database”. Please check that one out as well for added resources!