SQLSaturday 264 slide deck

Hi all, here are the slides of our recent speech at SQLSaturday 264 in Ancona (http://www.sqlsaturday.com/264/eventhome.aspx). You will also find the demo scripts. Feel free to share your thoughts. Happy Coding, Francesco Cogno (@MindFlavor) and Giuseppe Zagarrio (@ZagaMimmo) [View:~/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-00-87-37/6-degrees-of-separation.pdf:550:0] [View:~/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-00-87-37/6254.Demos.zip:550:0]

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

SQLCLR: string or SqlString?

One of the most asked question regarding the SQL CRL is whether to use string instead of System.Data.SqlString (see [MSDN] SqlString Structure for further details). You might guess that, from a performance point of view, using string is better. Let’s confirm (or reject) this assumption. First we need to create two very simple SQLCLR functions:…

1

SQL CLR Functions and parallelelism

If you develop your own SQLCLR functions, you know you should decorate the method with this attribute class: [MSDN] SqlFunctionAttribute Class. You might wonder what these options will do. The DataAccess Property, according to the documentation, “Indicates whether the function involves access to user data stored in the local instance of SQL Server”.  You might be…

2

Call Copy Blob (Azure REST API) from SQL Server

Following my recent post Call Azure REST API from SQL Server I’ve received many requests about how to call the new API Copy Blob. Its description is here: http://msdn.microsoft.com/en-us/library/windowsazure/dd894037.aspx. As before, let me show you what we want to achieve:   We want to have a simple stored procedure to call with a storage account, a source…

0

Sneak peek on SQL 2014: Parallel SELECT … INTO!

We are all exited about SQL 2014. I’m sure you have already downloaded the CTP. In this short post I would like to show you a welcome feature that you might not know about :). Suppose to have a large, parallel query. Until now if you wanted to create a table out of that query…

2

Call Azure REST API from SQL Server

Microsoft Azure platform can be managed in a number of ways. You can use PowerShell, you can use the Management Portal or you can use the http REST interface. If you happen to manage a lot of Azure items (containers, blobs, etc…) you might have to do some serious PowerShelling. But would not be wonderful…

1