SQL Server Best Practices on Flash Series

SQL Server Best Practices on Flash Series

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

Jimmy May Webinar Invitation

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!

Related Stories

What is the 3-2-1 Backup Strategy?