Sharing Data with Azure

Data sharing is challenging GDPR – Essential considerations from Safeguard individual privacy with the Microsoft Cloud GDPR and Data Governance: Your guide to Microsoft tools and technologies What data is to be shared? Data classification Azure SQL Database Data Discovery and Classification Azure SQL Database Data Discovery and Classification: Data Discovery & Classification (currently in…


PowerShell Scipt for generating events for Azure Event Hub

A useful PowerShell script I use for sending events to Azure Event Hub demos Login-AzureRmAccount Select-AzureRmSubscription -SubscriptionID ‘<your subscription number>’; Set-ExecutionPolicy Unrestricted Install-Module –Name Azure.EventHub $Token = Get-AzureEHSASToken -URI “<your event hub account><your event hub name>” -AccessPolicyName “<your policy name>” -AccessPolicyKey “<your policy key>” $EventHubUri = “<your event hub account><your event hub name>” $EventHubTimer =…


Getting Started With R

I’ve been helping a customer to get started with R – here’s my digest which no doubt I’ll be adding to over time. The first decision is the R version you wish to use CRAN R Microsoft R Open Machine Learning Server From SQL Server Microsoft Machine Learning Services Install – IDE R Tools for…


Getting Started with Power BI

As often happens – I meet a series of customers who are keen to learn about something, Power BI in this case, and I collate a growing list of useful links and things to get started with. So here’s my current list for Power BI. Complete Power BI course Also on YouTube Data Analysis Expressions…


Getting Started with Microsoft Azure AI

For a list of Microsoft Azure Cognitive Services and demonstrations you can use with your own inputs (voice, images, text etc), please see (Exploring these services has to be one of the most fun activities you can have whilst maintaining a legitimate claim to be working diligently.)   Microsoft’s Machine Learning capability is very…


I’m back, but I’m not who I used to be

After an 11 year break – I’m coming back to blogging – but I’m not who I used to be. I started this blog way back in 2005, when I was a SQL Server Evangelist. In 2006 I returned to Enterprise sales and I couldn’t the find time to properly share my learnings on this…


Free SAP Customer Workshops "How Microsoft Runs SAP" Munich on February 7, 2006 and in Brussels on February 9, 2006.

These courses rarely come to Europe – so if you’re interested be quick! From the blurb:- We would like to invite you to attend the upcoming SAP Customer Workshop about How Microsoft Runs SAP. The same session will be held in Munich on February 7, 2006 and in Brussels on February 9, 2006. The heart…


SQL 2005 Metadata Samples Toolkit and whitepaper now available

Reposted 10/1/06 to include in ‘free tools’ category  I’m constantly asked “what’s Microsoft doing about metadata and do we have a solution.” In the old days (SQl 2000 and 7), Microsoft provided Meta Data Services, a platform designed to help tools and applications manage metadata and information models more effectively. It included the Open Information…


New Performance Troubleshooting Guide for SQL2005

Many things have changed with SQL 2005, correspondingly we have to change the way we think about troubleshooting performance problems.  The most significant change is the advent of the new Dynamic Management Views (DMV), these are going to take some getting used to and this article helps significantly.  There’s some really good stuff around identifying…


New SQL 2005 code samples available

I guess now the pressure is off to release the product we’ll see more useful samples comming out of corp; here’s a link to the latest December update: