Get started using Data Science tools fast on AZURE

logo-131029674714477966Did you know that Microsoft have made it really easy to get started using various data science tools? How, you ask! Well Microsoft have compiled a few Virtual Machine Images, ready to be spun up/provisioned on Azure – all you have to do is to select the data science flavor of your choice. Continue reading →

Azure SQL Datawarehouse and Premium Storage

SQLAzureDatawarehouse2Today Microsoft have announced that Azure SQL Datawarehouse will support Premium Storage, this will allow the customers to see greater performance and predictability on queries. As of today, all newly created SQL Datawarehouse will be created with Premium Storage, at least in regions where Premium Storage is available. In the remainder of the preview period, the billing will continue to be based on standard pricing.

 

To read the full blog post – go to -> https://azure.microsoft.com/da-dk/blog/azure-sql-data-warehouse-introduces-premium-storage-for-greater-performance/

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/

SQL Server 2012 SP3 CU1 released

sql-option-aToday is the releaseday of SP3 Cumulative Update1 for SQL Server 2012, this update addresses 8 areas, where issues have been resolved.

These areas are:

BI\reporting Services
SQL Engine\Access Methods
SQL Engine\Core Security Infrastructure
SQL Engine\Distributed Query
SQL Engine\Query Execution
SQL Engine\Replication
SQL Engine\Search
SQL Engine\Service Broker
SQL Engine\Storage Management

You can read more at this Knowledgebase article and find the Update here.

 

SQLSUG meeting at IMS Rehfeld February 2

entity_imageThe next meeting in SQL Server User Group SQLSUG will be held at IMS Rehlfeld on February the 2nd

SQL Server MVP Erik Erik Ejlskov Jensen, will guide you through the Entity Framework, and how to use it for application developing and data modeling.

As this is a Hands-On lab, bring your laptop and get your hands dirty coding ;o) Continue reading →

That attribute bug in MDS will be resolved in CTP3.3

Hi there,

Happy New Years to each and everyone 😉

Just looked at the connect ticket for the MDS attribute bug I blogged about before christmas, and it turns out that the bug will be resolved in SQL Server 2016 CTP3.3

Posted by Nithesh [MSFT] on 12/22/2015 at 4:59 PM
The resolution for this issue will be provided in upcoming monthly release of SQL Server 2016 – CTP3.3
https://connect.microsoft.com/SQLServer/Feedback/Details/2108307
Great news.

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 →