As my colleagues and I at the SanDisk® Data Propulsion Lab (the home of application performance on flash) travel and speak in venues around the world, we’re struck by a hunger for validation of best practices for SQL Server.
I’ve long evangelized the importance of fundamentals. Flash can seem like a magic bullet—it can mask many performance, configuration, and design challenges. Yet best practices remain fundamental. There is no substitute for engineering discipline in terms of application & database design. I often open my presentations with the following:
If you don’t have time to do it right, when will you have time to do it over?
—John Wooden
Our team has a multi-faceted plan to remediate this deficit and help you make the best of flash and SQL Server.
Two New Initiatives
I want to share with you two initiatives:
- A series of practical, SQL Server best practices blog posts to help you take advantage of our lessons learned on flash. I’ll discuss Optimizing Power Settings in my first post.
- A SQL Server on Flash webinar where I’ll share configuration best practices for the hardware, Windows, and SQL Server. I’ll emphasize best practices for all implementations & highlight considerations specific to flash.
In addition, we’re incubating some exciting plans for additional presentations in collaboration with our friends at Microsoft. Stay tuned for that announcement!
Part 1: Best Practices
In the meantime, I invite you to join our forthcoming webinar:
What: SQL Server on Flash | Part 1: Best Practices
Who: Jimmy May
When: December 16, 2015
Where: On demand here
Let us know in advance if you have any questions we can cover for you in the comments below, or reach out to me directly at jimmy.may@sandiskoneblog.wpengine.com and @aspiringgeek on Twitter. We’re looking forward to your joining us!
