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

Redgate Summit Comes to the Windy City

By

I love Chicago. I went to visit three times in 2023: a Redgate event,...

Non-Functional Requirements

By

I have found that non-functional requirements (NFRs) can be hard to define for a...

Techorama 2024 – Slides

By

You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...

Read the latest Blogs

Forums

AG listener cant be removed

By ysalem

Testing with AG on Linux with Cluster=NONE. it was all going ok and as...

Remove comma inside Comma Delimited File csv in SSIS Using Script task

By hongho2

Hi, I have two tables: one for headers with 9 fields and another for...

Inserting 100K rows Performance - Baseline Performance

By MichaelT

We're trying to understand how quick new versions of SQL server can be.  Obviously...

Visit the forum

Question of the Day

The "ORDER BY" clause behavior

Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records: 

create table t1 (id int primary key, city varchar(50));

insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);
If we execute the following query, how will the records be sorted in both environments? 
select city

from t1

order by city;

See possible answers