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
104 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)
281 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
36 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)
535 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
56 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
44 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)
844 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
22 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
79 reads
Getting Started with SQL Server 2025 Public Preview: A Step-by-Step Installation Guide
A step-by-step guide to installing SQL Server 2025 Private Preview.
2025-06-04
3 reads
Blogs
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers