-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Mr. Fox SQL

Rolf Tesmer works as an Azure Data Solution Architect (DSA) in Australia for Microsoft. Rolf has an MCSE in Data Management & Analytics, an MCSE in Data Platform and an MCSE in Business Intelligence (BI). Rolf has been working with the SQL data platform since v6.0 (that’s 1994!) and has done just about everything you can around data related platforms, solutions and architectures ever since then and has scoped, designed and delivered 100’s of data solutions in that time. Rolf has had the opportunity to present extensively at Ignite, PASS, TechEd, SQL Saturday, SQL User Groups, MeetUp’s and Seminars, Roadshows, etc and really enjoys sharing and learning new ideas.

SQL Saturday 769 Melbourne & 771 Sydney

For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney

  • SQL Saturday 769 (Sat 30 Jun 2018) Melbourne.  SQL Saturday 771 (Sat 07 Jul 2017) Sydney.  For those looking for some great free local SQL / Azure /…

Read more

0 comments, 191 reads

Posted in Mr. Fox SQL on 31 May 2018

Using Elastic Query to Support SQL Spatial in Azure SQL DW

[read this post on Mr. Fox SQL blog]

Recently we had a requirement to perform SQL Spatial functions on data that was stored in Azure SQL DWSeems simple enough as spatial has been in SQL for many years, but unfortunately, SQL Spatial functions are not… Read more

2 comments, 352 reads

Posted in Mr. Fox SQL on 10 April 2018

Azure Cognitive Services API’s with SQL Integration Services Packages (SSIS)

[read this post on Mr. Fox SQL blog]

I had a recent requirement to integrate multi-language support into a SQL DW via a SQL SSIS ETL solution.  Specifically the SQL DW platform currently only supported English translation data for all Dimension tables, but the business was expanding internationally Read more

5 comments, 817 reads

Posted in Mr. Fox SQL on 12 March 2018

Database Backup Options for SQL on Azure IaaS

[read this post on Mr. Fox SQL blog]

Recently I had a requirement to collate and briefly compare some of the various methods to perform SQL Server backup for databases deployed onto Azure IaaS machines.  The purpose was to provide a few options to cater for the… Read more

2 comments, 635 reads

Posted in Mr. Fox SQL on 28 January 2018

Tuning Throughput from Azure Event Hub to Azure Stream Analytics

[read this post on Mr. Fox SQL blog]

Recently I had a requirement to load streaming JSON data to provide a data feed for near real-time reporting.  The solution streamed data into an “Ingress” Azure Event Hub, shred the JSON via Azure Stream Analytics and… Read more

1 comments, 353 reads

Posted in Mr. Fox SQL on 7 November 2017

Microsoft Ignite US 2017 – Major Azure Announcements

[read this post on Mr. Fox SQL blog]

Microsoft Ignite is probably the biggest technical event that Microsoft host yearly with many major announcements across the entire solutions portfolio suiteand this year 2017 was certainly no exception to that!

This year it was held in… Read more

0 comments, 388 reads

Posted in Mr. Fox SQL on 9 October 2017

Query Azure CosmosDB from a SQL Server Linked Server

[read this post on Mr. Fox SQL blog]

Recently I had a requirement to combine data that I already had in SQL Server (2016) with JSON document data already stored in Azure CosmosDB.  Both databases were operational and continuously accepting data so I didn’t want to go… Read more

1 comments, 1,575 reads

Posted in Mr. Fox SQL on 25 September 2017

Streaming Reporting: SQL Change Data Capture (CDC) to Power BI

[read this post on Mr. Fox SQL blog]

Extending on my previous post about redirecting SQL CDC changes to Azure Event Hub, I have had a few people ask for details/options to stream SQL data into the Power BI API.

Specifically – they were looking for… Read more

4 comments, 1,026 reads

Posted in Mr. Fox SQL on 31 July 2017

Streaming ETL: SQL Change Data Capture (CDC) to Azure Event Hub

[read this post on Mr. Fox SQL blog]

I had a recent requirement to capture and stream real-time data changes on several SQL database tables from an on-prem SQL Server to Azure for downstream processing.

Specifically we needed to create a streaming ETL solution that …

  1. Captured intermediate…

Read more

23 comments, 1,623 reads

Posted in Mr. Fox SQL on 11 July 2017

Making Phone Calls from Azure Event Hub Messages

[read this post on Mr. Fox SQL blog]

Recently I did a presentation at our local SQL Server User Group (SSUG) on Managing Streaming Data Pipelines Using Azure Data Services and as such wanted to build a compelling Azure demo that worked with simple streaming data which under… Read more

1 comments, 712 reads

Posted in Mr. Fox SQL on 30 May 2017

What Exactly is the “Data Platform” Nowadays?

[read this post on Mr. Fox SQL blog]

A couple of months ago I was presenting at SQL Saturday Melbourne (582) on Azure Cognitive Services and got chatting with some of the other presenters about our sessions.

I co-presented with Krissy Rumpff from Microsoft Data Platform Team ( Read more

1 comments, 2,200 reads

Posted in Mr. Fox SQL on 18 April 2017

A Collection of SQL Server Help Scripts

[read this post on Mr. Fox SQL blog]

Like probably every SQL DBA, consultant, architect etc etc out there that has ever worked on or used SQL Server they will likely have their own personal collection of SQL Server Help Scripts.

So not unsurprisingly I also have… Read more

1 comments, 976 reads

Posted in Mr. Fox SQL on 13 March 2017

Azure Cognitive Services Text Analytics – An API Calling Application

[read this post on Mr. Fox SQL blog]

Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in the Gold Coast on Azure Cognitive Services – and we had an absolute blast of a time!

I co-presented with Kristina Rumpff who works at… Read more

1 comments, 2,663 reads

Posted in Mr. Fox SQL on 22 February 2017

SQL Saturday 582 Melbourne (11 Feb 2017) and Ignite 2017 (14-17 Feb 2017)

For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast

  • SQL Saturday 582 (Sat 11 Feb 2017).  Melbourne.  For those looking for some great free local SQL (and related!) learning, you simply cannot go past a SQL Saturday anywhere in…

Read more

0 comments, 483 reads

Posted in Mr. Fox SQL on 17 January 2017

Azure Cognitive Services API’s with SQL Server 2016 CLR

[read this post on Mr. Fox SQL blog]

Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that have the ability to do some truly amazing things.

Before I dive into SQL and DLL code to make use of Cognitive Services, lets… Read more

3 comments, 1,914 reads

Posted in Mr. Fox SQL on 12 September 2016

Azure SQL IaaS – TempDB Performance on SSD vs Premium Disk

[read this post on Mr. Fox SQL blog]

When it comes to deploying SQL Server onto an Azure IaaS VM, it is sometimes difficult to know the best option to deploy the SQL Server tempdb database for your workload.

In many of the SQL templates on the… Read more

6 comments, 2,699 reads

Posted in Mr. Fox SQL on 26 July 2016

Azure Cortana Intelligence Suite – with Azure Data Catalog

[read this post on Mr. Fox SQL blog]

I presented at our local Melbourne SQL Server User Group (SSUG) this week on Azure Cortana Intelligence Suite – and the integration with the Azure Data Catalog.  If you are interested to see the presentation then have a look… Read more

4 comments, 1,728 reads

Posted in Mr. Fox SQL on 23 June 2016

Azure DocumentDB – Preparing, Loading and Querying Data

[read this post on Mr. Fox SQL blog]

Recently I have been using Azure DocumentDB (aka CosmosDB) to validate several business use cases for a variety of application purposes.

For those SQL DBA’s and others who are new to Azure CosmosDB, its a recent entrant… Read more

10 comments, 2,915 reads

Posted in Mr. Fox SQL on 10 May 2016

PASS – A Business Case for Attendance

[read this post on Mr. Fox SQL blog]

For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say that’s a huge number!) the PASS Summit provides one of the most fantastic and focused learning and networking experiences available. Read more

0 comments, 2,379 reads

Posted in Mr. Fox SQL on 25 April 2016

Compression Performance with Low Key Selectivity

[read this post on Mr. Fox SQL blog]

When it comes to enabling data compression in SQL Server I suspect most people don’t do a lot of testing as to the impacts of either enabling compression and its ongoing maintenance.  I assume most are interested in its… Read more

1 comments, 484 reads

Posted in Mr. Fox SQL on 15 March 2016

Older posts