Bring your own SQL licenses to Azure

data_Illustration_cloudA few days ago, we announced that Microsoft Enterprise customers is now allowed to bring their own SQL Licenses to Azure VMs. This means that if a customer already have a SQL License, this license can be used on SQL Server VM images from Marketplace.

This means that they do no longer need to build their own VM, but instead can just provision a server from the marketplace and use the existing license.

Read a lot more on the official blog post

https://azure.microsoft.com/da-dk/blog/easily-bring-your-sql-server-licenses-to-azure-vms/

Found a possible bug in MDS

image.png

UPDATE : Upvote the connect task

UPDATE : Tested on SQL 2016 CTP3.1

Today, working on Master Data Services 2014 (MDS) at a client, I ran into some strange behavior from both the MDS website and the MDS Excel Add-In.

For some reason there is a limit to the length on attributes in an entity, in my opinion there should not be limitations on the attribute length, as it should be up to the users to decide. Continue reading →

Microsoft acquires Datazen Mobile BI

visual02Yesterday was a really good day for all doing Mobile BI on Microsoft BI Stack, as Microsoft acquired Datazen. Datazen has been in the mobile BI market for quite some time now and their product is really stable and delivers a great front-end for data in the any company. Continue reading →

SQL Server 2014 CU5 Master Data Service Excel Addin

image This update was released yesterday, and it is a highly anticipated update, as it will introduce performance factor 4 in the Excel Addin.

This performance upgrade will come in very handy when working on larger datasets, and should speed the user experience up. Continue reading →

Audit on SQL Server

ShowImageThe other day one of my clients asked me if there was any way to audit what users did on their data, and in particular some tables of importance. I had to look it up, well I knew that there was some Audit possibilities build into SQL Server, but I had never had the need for it before. Continue reading →