Test Data Management (TDM) is essential in software development to ensure your application runs smoothly and reliably across different environments. When deploying applications in Azure, Test Data Management can...
2024-05-29 (first published: 2024-05-13)
237 reads
This blog post is about Test Data Management – or my take on it. I just saw that a video I did for my good mates at Redgate is...
2024-05-01 (first published: 2024-04-30)
72 reads
Are you looking to boost your skills and knowledge in Database DevOps, learn how to transition to the cloud, and work across multiple databases? Join me and fellow speakers/experts...
2024-05-01
5 reads
A few weeks ago I did an interiview with Nagaraj Venkatesan – a good friend of mine who works for Microsoft Singapore. You can watch video below – I...
2024-04-01 (first published: 2024-03-20)
177 reads
In November 2023 I did a session at PASS Summit and one of my sessions was voted https://passdatacommunitysummit.com/about/news/have-you-watched-some-of-the-most-popular-sessions-from-summit-2023/ That session was called DevOps is about Growing People rather than...
2024-03-27 (first published: 2024-03-20)
191 reads
Way back in 2019 I set some goals…. well I wrote some goals and posted them here 2019 seems a lifetime ago…..that was the year I travelled 200,000 air...
2024-03-20
30 reads
I love KQL so much I even made a video and if you compare it to my last blog post – yeah my hair has changed a bit…And my...
2023-04-07 (first published: 2023-03-20)
431 reads
If you have read any of my last few posts on provisioning Azure Data Explorer then you will probably be wondering….. Will he write about Powershell? Ok, I will....
2023-04-03 (first published: 2023-03-20)
205 reads
Background: Azure Data Explorer is a powerful analytics service that allows us to quickly ingest, store, and analyze large volumes of data from various sources. Azure Data Factory is...
2023-03-27 (first published: 2023-03-19)
339 reads
I recently did a talk to the Data Platform Down Under User group and it covers a whole heap of stuff that I’ve written about in this series. Check...
2023-03-20
9 reads
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...
This may or may not be helpful in the long term, but since I’m...
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Widespread New Technology Adoption
Comments posted to this topic are about the item Multiple Sequences
In SQL Server 2022, I run this code:
CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1; GO CREATE TABLE NewMonthSales (SaleID INT , SecondID int , saleyear INT , salemonth TINYINT , currSales NUMERIC(10, 2)); GO INSERT dbo.NewMonthSales (SaleID, SecondID, saleyear, salemonth, currSales) SELECT NEXT VALUE FOR myseqtest , NEXT VALUE FOR myseqtest , ms.saleyear , ms.salemonth , ms.currMonthSales FROM dbo.MonthSales AS ms; GO SELECT * FROM dbo.NewMonthSales AS nmsAssume the dbo.MonthSales table exists. If I run this, what happens? See possible answers