Microsoft recently released SQL Server 2014, and along with it came a fascinating white paper on Windows Azure Blog Storage Services. This white paper delves into the new feature called SQL Server Data Files in Windows Azure, which is available in all editions of SQL Server 2014.

One of the most exciting aspects of this feature is that it enables SQL Server 2014 to become a hybrid cloud database. It provides native support for database files stored as Windows Azure Blobs, allowing data to be accessed simultaneously from both local storage and the cloud. This means that you can host your SQL Server instance in the Azure cloud and utilize Windows Azure Blobs, just as you would with an on-premises SQL Server.

Let’s consider a scenario where you have stored your database files in the cloud and have backups on Windows Azure Cloud. In the past, if you wanted to restore your backup, you would have to bring it back to your on-premises server before restoring it. However, with SQL Server 2014, you can now restore your data directly from Windows Azure Storage to your SQL Server 2014 instance in a Virtual Machine. This eliminates the need for extensive data movement between cloud and on-premises servers.

The white paper that accompanies this feature provides an in-depth exploration of its capabilities. With over 116 pages and a 2.5 MB file size, it is a comprehensive resource for understanding and implementing SQL Server Data Files in Windows Azure. What sets this white paper apart is its step-by-step approach, starting from the basics and gradually building up with examples. The appendix of the white paper contains all the necessary code and additional reference material, making it a valuable learning tool.

If you’re eager to dive into the world of SQL Server 2014 and Windows Azure Blob Storage Service, I highly recommend downloading and reading this white paper. It offers a wealth of knowledge and insights that will enhance your understanding of this powerful feature.

Image included in this blog post is courtesy of the white paper itself, and it brilliantly summarizes the story of the entire white paper in just one image.

Download the white paper SQL Server 2014 and Windows Azure Blob Storage Service: Better Together.