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)

Blogs

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Humble Bundle of Java Books

By

I try to keep an eye on the Humble Bundle bundles for books. The...

How Redgate’s Test Data Manager Can Enhance Automated Testing

By

A brief overview of the benefits and challenges of automated testing and how Redgate’s...

Read the latest Blogs

Forums

Filestream Filegroups on state RESTORING

By M@dboy

Hello All, I have a question. My SQL Servers are running SQL Server 2019...

Find dependencies on a table

By water490

I am in the process of doing a re-write for my project so I...

Career Advice

By sqlenthu 89358

hello folks, I am posting this question with heavy heart. I have been a...

Visit the forum

Question of the Day

Updatable Views II

I have this view:

CREATE OR ALTER VIEW dbo.City 
AS
SELECT TOP 10 
 cn.CityNameID, cn.CityName
 FROM dbo.CityName AS cn
 WITH CHECK OPTION
GO
How can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')

See possible answers