SQL 2012 – discontinuità nella generazione dei valori associati alla proprietà IDENTITY

Recentemente mi è capitato di lavorare presso due differenti clienti che avevano un problema simile. Tale problema consisteva nel fatto che in alcune situazioni, i valori generati tramite l’attributo IDENTITY presentavano delle discontinuità. Questo fenomeno è dovuto ad una differente modalità di generazione dei valori da SQL Server 2012 in poi.Nelle versioni precedenti, ad ogni…


How to set up an Hyper-v Linux (CentOS) server with Microsoft® SQL Server® ODBC Driver

Have you ever tried to query a SQL Server instance from linux? It might be scary for a senior Microsoft DBA. Even if you just want to play with it a bit the you might lose yourself in the Linux inner workings. For this reason I've put together a simple how-to guide that should ease the pain of the initial configuration of…


Time normalization: a SQL CLR approach to address unevenly-spaced data samples

One very common challenge in the IT department is to represent time driven data. Think about performance counter values, weather data or, more simply, your own weight tracking. This kind of data is taken in samples: each sample is defined by the collection time. When we try to visualize the data, we often need to…


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…


SQL Server 2014 Dynamic-link library load

Have you ever wondered how SQL Server 2014 accomplishes the “Native compilation” feature? In this post I’ll show you how to inspect what SQL Server is doing behind the scenes while “compiling” your native code. This will be a deep post that will require a non production instance since we will restart it many times….


Streaming in SQL Server using SQL CLR

The SQL Server engine execution operators are of two kinds: blocking and non-blocking. Blocking operators need to consume the complete dataset before returning an output. Think about the COUNT(*) operator: in order to tell you the result it has to go over all your rows. Another example of blocking operator is the Sort operator. Proper…


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]


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…


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). …


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…