SQL Server Flash
Industries & Applications

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!

Leave a Response

Jimmy May
Jimmy May is a SQL Server Certified Master and is a SQL Server Technologist for SanDisk Data Propulsion Lab.Jimmy was a Principal Architect in Microsoft IT and formerly a Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, and most interesting SQL Server apps from around the world. His last day job was Senior Database Architect for one of the world’s largest, SQL Server high-throughput OLTP DBs. He was a founder & on the executive committees of both the Indiana Windows User Group (www.iwug.net) & Indianapolis Professional Association for SQL Server (www.indypass.org).His passion is “flipping the /faster bit”; his motto is “change the world or go home”. Visit his SQL Server performance and personal productivity blog at http://sqlblog.com/blogs/jimmy_may.