Mr Fox SQL

My name is Rolf Tesmer (aka Mr. Fox SQL) - and I work as an Azure Cloud Architect (Data | Analytics | AI/ML) for Microsoft in Melbourne (Australia).
...
I started working with the SQL platform on Version 6.0 (that’s 1994!) – and have probably scoped and delivered 100’s of successful data solutions over that time. I’ve had the opportunity to present extensively including at PASS, TechEd, Ignite, SQL Saturday, Australian Computer Society (ACS), SQL User Groups, Customer & Partner Roadshows, etc to audiences both large (500+) and small (5+) and really enjoy sharing new ideas.
...
From a personal tech interest perspective, I love All Things Cloud + Data (Azure, Data Warehousing, Streaming Data / IoT, Machine Learning / Artificial Intelligence, BI / Visualisation / Story-Telling and Spatial).
...
From a day-to-day BAU work angle, as an Azure Data & AI Cloud Architect (CSA) at Microsoft I focus on Azure cloud technology, solutions design/architecture, migrations, best practices and deployment guidance in the Azure Cloud.
...
Contacts & Information
Blog Email... rolf.tesmer@mrfoxsql.com.au
Blog Website... https://mrfoxsql.wordpress.com/
You Tube... https://www.youtube.com/channel/UCf4voJ1GYsFmQ96XIFUYg3Q/playlists
Linked In... https://au.linkedin.com/in/rolftesmer
GitHub... https://github.com/rolftesmer
Twitter... (no presence)
  • Interests: Databases, DW, BI, AI, ML, SQL, Visualisation, Streaming, Architecture, Security, Automation
  • Skills: Anything Data, AI, ML or Analytics in the Cloud (Azure or AWS)

All authors

All authors

Blogs

Query deadlock info in Azure SQL DB

By

A couple of weeks ago, a developer came to me and wanted to know...

MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

By

Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...

Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines

By

When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...

Read the latest Blogs

Forums

Baseball Everywhere

By Ryan Booz

Comments posted to this topic are about the item Baseball Everywhere

How to run custom python module on SQL Server?

By yyang5823

I am working on a small test script on SQL server 2022 using python...

Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps

By ralahari

Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and...

Visit the forum

Question of the Day

Sensitivity Ranks

I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code? 

ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
    dbo.sales.discount
WITH (
    LABEL = 'Highly Confidential',
    INFORMATION_TYPE = 'Financial',
    RANK = 'INTERNAL ONLY'
);

See possible answers