Generating Random Strings with GenAI
One of the things I’ve been experimenting with in AI is taking things other people do and seeing how well the AI works. In this case, I took a...
2025-06-20
22 reads
Blog Posts
Heading to SQL Bits 2025
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day of the conference. I wasn’t selected to speak, but since I’m in Cambridge next week...
2025-06-20
23 reads
Introducing FabricTools (PowerShell module)
🔍 The Challenge: DevOps for Microsoft Fabric In the world of Microsoft Fabric, DevOps is still maturing. Unlike Azure Data Factory (ADF), which has been around long enough to...
2025-06-20
32 reads
Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very important for ensuring that there is a smooth deployment and maintainable code quality. Building a...
2025-06-19
71 reads
Why India’s NEW Tax Regime is a GAME CHANGER for the Job Market
India’s 2025 tax reforms have introduced a bold shift in how income is taxed, and the ripple effects are already being felt across industries. With a focus on simplification,...
2025-06-19
14 reads
Apply for a 2025 PASS Summit Scholarship
Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket to the main part of the PASS Summit, but also $1400 towards travel and accommodations....
2025-06-18 (first published: 2025-06-04)
249 reads
Better Trigger Design: #SQLNewBlogger
I had someone ask me about using triggers to detect changes in their tables. This is the third post in the series. The first one Another post for me...
2025-06-18
31 reads
Comparing Microsoft Fabric Alternatives in AWS, GCP, and OCI in 2025
Microsoft's unified analytics platform, Fabric, simplifies integration across various tools in Azure by offering seamless authentication and a comprehensive set of features. Although alternatives exist in AWS, GCP, and...
2025-06-18 (first published: 2025-06-05)
742 reads
How To Test SQL Server Disk IO Throughput
When managing large databases or high-transactional databases, the performance of your underlying storage system is crucial, whether it...
2025-06-18
5 reads
SQL Server error 18456
Working with thousands of instances of Microsoft SQL Server, I often encounter users having issues. A common error is 18456 which indicates a login failure.
The post SQL Server error...
2025-06-18
109 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
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers