SQL Server 2014 and Windows Azure Blob Storage Service: Better Together

Just a quick post to point you to this new SQL Server 2014 whitepaper: SQL Server 2014 and Windows Azure Blob Storage Service: Better Together. You will find many interesting best practices and a WSFC-like framework. Summary: SQL Server 2014 introduces significant new features toward a deeper integration with Microsoft Azure, thus unlocking new scenarios and…

0

About Container Shared Access Signature for SQL Server XI

Hi all, Ever since the MSDN post about SQL Server XI, available from SQL 2014 (see  http://blogs.msdn.com/b/igorpag/archive/2013/10/23/create-a-sql-server-2014-database-directly-on-azure-blob-storage-with-sqlxi.aspx) there is a lot of buzz about Azure Storage in the SQL Server community. One recurring question is: What is the Shared Access Signature (SAS) and why SQL Server XI needs it? First some background: in the Azure…

0

Backup to Azure using TSQL (and CLR)

Hi All, as a sample of how to use Microsoft SQL Server To Windows Azure helper library let me show you how to perform a backup to azure using the TSQL. As prerequisite, of course, you should have downloaded and installed the helper assembly (for how to do that please refer to the project documentation). …

0

SQL Server To Windows Azure helper library - A SQL Server open source CodePlex project

Hi all, since my last SQLRally presentation in Amsterdam people kept asking for a working build of the SQLCLR Windows Azure REST API  DLL. Many snippets of it can be found in this blog; however most of you don’t really care about the implementation boilerplate. On the contrary, some of you might actually like to…

0

Blob leases: how to break them from SQL Server (using SQL CLR and Windows Azure REST API)

SQL 2014 will give you a terrific feature: SQL XI. It will allow you to store your datafiles and tlogs directly in Windows Azure Page Blobs. You can read about it in this great post: http://blogs.msdn.com/b/igorpag/archive/2013/10/23/create-a-sql-server-2014-database-directly-on-azure-blob-storage-with-sqlxi.aspx. As you can see, however, SQL Server places a lease on each blob in use. Think about Azure leases…

0