What does a Tesla Model S and an Apple MacBook Air have in common? Apart from being trendsetters in their categories and immensely popular with consumers, they were original products of imagination—not a result of incremental improvement. In that same vein, flash storage has revolutionized the data center. DBAs and IT architects must take that into account before designing their SQL Server platform.
It is easy to think about requirements and operations in the context of how it has been done a few decades ago and then make incremental improvements. However, it is a whole new shiny world if you take a few steps back, look at the flash storage options and then come up with an architecture. Doing so will lead to new levels of efficiency and performance for the IT operations, and it will lead to a distinctly positive business transformation that was not even possible before.
The world has and continues to change rapidly. Before the adoption of flash storage, even Microsoft’s best practices cited data-access latencies of 10ms as acceptable. Now a delay a couple of millisecond or more is painful and will likely lead to financial loss. Look at the capabilities of Microsoft SQL Server 2016. Gone are the days of simple multi-site disaster recovery strategies. Integration of Azure Cloud is central. With the performance and robust capabilities of flash solutions today, if anyone is designing their transactional and data warehousing systems in separate silos, then they are introducing a lot of inefficiency. Think about data restores. Are you still relying on having to restore your backup in case of emergency? Can you afford to be ‘Out of Order’ while the backup is being restored? There are many who are still running MS SQL Server 2005 and have run out of official support by Microsoft. Are you one of them? Are you dreading the cost implications of upgrading from Standard Edition of MS SQL Server to the enterprise?
We recently collaborated with SQL Server MVP David Klee, and vExpert James Green to create an easy-to-read book on Modern Storage Strategies for SQL Server. If you want to leave incremental gains behind and think about your MS SQL Server platform in a more modern and holistic way, then is the book for you.
Over the coming weeks, I will be writing a series of blogs detailing how you can achieve performance, cost-effectiveness, and operational simplicity out of your MS SQL Server environments using the modern solutions that are available today. Of course, you don’t have to wait for my blogs to come out. You can download David and James’ book today.