AdventureWorks2025 to an Azure SQL VM, part 5: restore

Part 5 of 6. The series: 1. The plan and the lab · 2. Check what is there · 3. Export what the target needs · 4. Back up and upload · 5. Restore (this post) · 6. Check post-migration, and clean up. Part 4 left everything the VM needs in one place: the backups, … Continue reading AdventureWorks2025 to an Azure SQL VM, part 5: restore →

AdventureWorks2025 to an Azure SQL VM, part 4: back up and upload

Part 4 of 6. The series: 1. The plan and the lab · 2. Check what is there · 3. Export what the target needs · 4. Back up and upload (this post) · 5. Restore · 6. Check post-migration, and clean up. Part 3 left the laptop with AdventureWorks2025 encrypted (and the laptop in … Continue reading AdventureWorks2025 to an Azure SQL VM, part 4: back up and upload →

AdventureWorks2025 to an Azure SQL VM, part 3: export what the target needs

Part 3 of 6. The series: 1. The plan and the lab · 2. Check what is there · 3. Export what the target needs (this post) · 4. Back up and upload · 5. Restore · 6. Check post-migration, and clean up. Part 2 ended with a VM that passed all ten gates: it … Continue reading AdventureWorks2025 to an Azure SQL VM, part 3: export what the target needs →

AdventureWorks2025 to an Azure SQL VM, part 2: check what is there

Part 2 of 6. The series: 1. The plan and the lab · 2. Check what is there (this post) · 3. Export what the target needs · 4. Back up and upload · 5. Restore · 6. Check post-migration, and clean up. Part 1 ended with a VM in Azure, a storage account, a … Continue reading AdventureWorks2025 to an Azure SQL VM, part 2: check what is there →

AdventureWorks2025 to an Azure SQL VM, part 1: the plan and the lab

Part 1 of 6. The series: 1. The plan and the lab (this post) · 2. Check what is there · 3. Export what the target needs · 4. Back up and upload · 5. Restore · 6. Check post-migration, and clean up. A week ago I wrote about site-to-site migration and rollback: the method, … Continue reading AdventureWorks2025 to an Azure SQL VM, part 1: the plan and the lab →

Site-to-site migration and rollback

First things first: Hugo, one of the best humans to have walked the face of the Earth passed away. You can read about his last moments here: https://sqlserverfast.com/blog/hugo/2026/11/final-post/. I, for once, am lost for words.Go grab his video trainings (basically for free for the depth of knowledge you will get), that is the least we … Continue reading Site-to-site migration and rollback →

Using Performance Monitor Lite with Local LLMs

The one and only Erik Darling (homepage) is doing his best to help us to make our lives easier by providing a fully fledged monitoring solution (two, actually) for SQL Server, all this for free. Yes, FREE: https://github.com/erikdarlingdata/performancemonitor. Due to the nature of my job I can only use the Lite version, not the fully … Continue reading Using Performance Monitor Lite with Local LLMs →

Find and Change (N)VARCHAR(MAX) to (N)VARCHAR(XXX)

I know, I know, everything I do is rushed and not properly explained, apologies for that. Anyway.During some investigation, I came across some badly designed tables where most of the columns meant to hold character data were NVARCHAR(MAX), all this while the maximum length of the strings were something in the area of 30-50 characters. … Continue reading Find and Change (N)VARCHAR(MAX) to (N)VARCHAR(XXX) →

Script to update the dates on AdventureWorks database

In case you ever needed this: IF OBJECT_ID('tempdb..#GeneratedScripts') IS NOT NULL DROP TABLE #GeneratedScripts; CREATE TABLE #GeneratedScripts (Id INT IDENTITY(1,1), SqlScript NVARCHAR(MAX)); -- 1. Setup global ceiling INSERT INTO #GeneratedScripts (SqlScript) VALUES ('DECLARE @TargetCeiling DATETIME = GETDATE();'); DECLARE @SchemaName NVARCHAR(256), @TableName NVARCHAR(256), @AnchorColumn NVARCHAR(256); DECLARE @Sql NVARCHAR(MAX), @ColumnUpdates NVARCHAR(MAX); DECLARE tbl_cursor CURSOR FOR SELECT DISTINCT … Continue reading Script to update the dates on AdventureWorks database →