T-SQL Tuesday #187–Solving Problems
This month we have a great invite from Joe Fleming, a first time host of T-SQL Tuesday. Joe reached out when I requested some hosts and I’m glad he...
2025-06-10
95 reads
Blog Posts
KDA: Echoes of Deception - Case 3
The crime spree in Digitown is not ending. This time 20 cars have been stolen and we need to find where they’re stored.
The problem
This is the abridged case description....
2025-06-09 (first published: 2025-05-16)
265 reads
Monday Monitor Tips: Customizing Data Retention
One of the biggest challenges with monitoring data is managing the volume over time. Lots of bespoke/home-grown solutions don’t do this well, and some commercial products have a gross...
2025-06-09
28 reads
SQL Server 2025: Enterprise AI Without the Learning Curve
With the release of SQL Server 2025, Microsoft is firmly positioning its flagship database platform as an enterprise-ready AI solution. Having spent time with the preview builds and working...
2025-06-09 (first published: 2025-05-19)
513 reads
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure Container App: A…
Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure Container App: A Step-by-Step GuideBuilding scalable, portable, and easy-to-maintain applications has become necessary in today's...
2025-06-08
25 reads
Building a Todo List RESTful API in C++ with Docker, GitHub Actions, Azure ACR: A Beginner’s Guide
C++ is a highly versatile language for developing console applications, batch processing, and performance-critical applications. While it has traditionally been less explored for building RESTful APIs, modern libraries like...
2025-06-06
15 reads
T-SQL Tuesday #186 Roundup - Managing Agent Jobs
Thank you to everyone who contributed to this month’s T-SQL Tuesday!
Here’s a roundup of the posts.
2025-06-06 (first published: 2025-05-21)
827 reads
Techno Security East: Quantum Computing Slides
I always try and ensure that I post my slides to my talks here on my blog. Here are the slides that I used for my Quantum Computing and...
2025-06-05
7 reads
A Basic Update Trigger: #SQLNewBlogger
I had someone ask me about using triggers to detect changes in their tables. As I explained a few things, I thought this would make a nice series, so...
2025-06-04
22 reads
IndiaAI Mission: Transforming India with AI Power!
IndiaAI Mission: Empowering India Through Artificial Intelligence🔹 Mission VisionThe IndiaAI initiative aims to harness the power of artificial intelligence to drive innovation, improve accessibility, and catalyze socio-economic development across...
2025-06-04
2 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers