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

Mr. Fox SQL

Rolf Tesmer works as an Azure Cloud Data Solution Architect (DSA) in Melbourne, Australia. Rolf has an MCSE in Data Platform and an MCSE in BI. Rolf has been working with the SQL platform since v6.0 (that’s 1994!) and has done just about everything you can around data related architectures ever since then having scoped, architected and delivered 100’s of solutions over that time. Rolf has been lucky to have the opportunity to present extensively at TechEd, SQL Saturday, SQL Pass, SQL User Groups, Big Data Seminars, Microsoft Technology Roadshows, Breakfast Seminars, ++ and really enjoys sharing and learning new ideas.

What Exactly is the “Data Platform” Nowadays?

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 (https://www.linkedin.com/in/krumpff/) – and for those interested our session is… Read more

1 comments, 1,286 reads

Posted in Mr. Fox SQL on 18 April 2017

A Collection of SQL Server Help Scripts

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 such a collectionand this is the purpose of… Read more

1 comments, 481 reads

Posted in Mr. Fox SQL on 13 March 2017

Azure Cognitive Services Text Analytics – An API Calling Application

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 Microsoft in the Data Platform team as a Solution Architect Read more

1 comments, 1,548 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, 153 reads

Posted in Mr. Fox SQL on 17 January 2017

Azure Cognitive Services API’s with SQL Server 2016 CLR

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 take a second to understand what I am talking about… Read more

1 comments, 1,345 reads

Posted in Mr. Fox SQL on 12 September 2016

Azure SQL IaaS – TempDB Performance on SSD vs Premium Disk

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 marketplace it is often deployed to the C:\ by default… Read more

4 comments, 1,875 reads

Posted in Mr. Fox SQL on 26 July 2016

Azure Cortana Intelligence Suite – with Azure Data Catalog

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 here – https://mrfoxsql.wordpress.com/presentations/

One of the things which stood out… Read more

2 comments, 1,276 reads

Posted in Mr. Fox SQL on 23 June 2016

Azure DocumentDB – Preparing, Loading and Querying Data

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

For those SQL DBA’s and others who are new to Azure DocumentDB, its a recent entrant to the NoSQL document database world, and as its a PaaS document database cloud… Read more

1 comments, 2,160 reads

Posted in Mr. Fox SQL on 10 May 2016

PASS 2016 – A Business Case for Attendance

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.

I simply cannot think of any other SQL/BI event that… Read more

0 comments, 2,111 reads

Posted in Mr. Fox SQL on 25 April 2016

Compression Performance with Low Key Selectivity

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 ongoing performance for queries, and you know that’s damn fair… Read more

1 comments, 293 reads

Posted in Mr. Fox SQL on 15 March 2016

SQL Filegroup/File Proportional Fill Algorithm

I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup in a user database.  There was a mention that data was not being distributed evenly across files and also that a trace flag was needed… Read more

1 comments, 1,649 reads

Posted in Mr. Fox SQL on 24 February 2016

SQL Saturday Melbourne (#464) – 20 Feb 2016

For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016.

SQL Saturday is an excellent free learning resource for all things SQL Server – all costs are covered by donations and sponsorships.  Some of the excellent sponsors this year are PASS, RockSolid… Read more

0 comments, 409 reads

Posted in Mr. Fox SQL on 18 January 2016

A “Business Intelligence” (BI) Definition

Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions using the Microsoft BI solutions stack.

In all of my sessions, regardless of the specific focus, each time I always start with the same 2 content slides.

  • The first is always the positioning graphic…

Read more

3 comments, 2,497 reads

Posted in Mr. Fox SQL on 11 January 2016

Calculating Table Partition Sizes in Advance

Continuing on with my Partitioning post series, this is part 7.

The partitioning includes several major components of work (and can be linked below);

  1. partitioning large existing non-partitioned tables
  2. measuring performance impacts of partitioned aligned indexes
  3. measuring performance impacts of DML triggers for enforcing partitioned unique indexes
  4. rebuilding tables…

Read more

8 comments, 1,108 reads

Posted in Mr. Fox SQL on 23 November 2015

PASS 2015 Session Report – Azure SQL DW Integration with the Azure Ecosystem & End of PASS 2015

PASS 2015 continues (and finishes up today!) in Seattle.

Its been an amazing conference this year with a few things really hitting home;

  • Amazing technology announcements around SQL 2016 CTP3
  • Incredible advances in almost every component in Azure Data Services
  • Full and seamless SQL/Azure ecosystem integration – and…

Read more

0 comments, 525 reads

Posted in Mr. Fox SQL on 31 October 2015

PASS 2015 Session Report – Understanding Real World Big Data Scenarios

PASS 2015 continues in Seattle, and today was my session at 1045am on Using Azure Machine Learning (ML) to Predict Seattle House Prices.  The background and info on my session is here http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=7794

Overall I was pretty happy with how it went - and I think everyone who attended…

Read more

1 comments, 489 reads

Posted in Mr. Fox SQL on 30 October 2015

PASS 2015 Session Report – KeyNote and SQL Server on Azure Virtual Machines: Features, Best Practices & Roadmap

So PASS officially kicked off this morning leading into the next 3 days of back to back sessions.

You could certainly tell that the keynote was on… I mean the dining room was pumping…!



Oh that’s right, everyone is at the keynote!



So the Keynote Read more

1 comments, 362 reads

Posted in Mr. Fox SQL on 29 October 2015

PASS 2015 Session Report – Optimize “All Data” with a Modern Data Warehouse Solution

PASS 2015 has kicked off in Seattle, well the precon’s have anyway on Mon & Tue.  The actual conference starts on Wed-Fri!

I attended a precon session today called Optimize “All Data” with a Modern Data Warehouse Solution held by Bradley Ball and Josh Luedeman of Pragmatic Works.

The session… Read more

0 comments, 296 reads

Posted in Mr. Fox SQL on 28 October 2015

House Price Predictions @ PASS 2015

The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or so selected to speak at the conference (…and as a quick aside I also note a reasonably… Read more

0 comments, 486 reads

Posted in Mr. Fox SQL on 7 September 2015

Older posts