SQL Server in the Cloud – Are DBAs Still Needed?
Things your cloud vendor may not tell you Here’s a common theme I hear from small IT teams: “Our SQL Server is in the cloud now. We don’t...
2025-06-18
38 reads
Blog Posts
Are Your Disks Lagging?
Recently, one of my clients was experiencing performance issues with their SQL Server. Although the server was not underpowered from a...
2025-06-17
2 reads
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
In an era where cloud computing drives innovation, understanding its fundamentals is no longer optional—it’s essential. The AZ-900: Microsoft Azure Fundamentals certification is the perfect starting point for anyone...
2025-06-17
29 reads
Becoming a Presenter: My Journey and Tips
I still remember my very first presentation many years ago. Someone in my team asked me to demo a project I’d been working on, and I was absolutely terrified....
2025-06-17
14 reads
Getting Started with Vector Search in SQL Server 2025 Using Ollama
Ollama SQL FastStart streamlines the deployment of SQL Server 2025 with integrated AI capabilities through a comprehensive Docker-based solution. This project delivers a production-ready environment combining SQL Server 2025,...
2025-06-16 (first published: 2025-05-19)
815 reads
Invoking Another Pipeline in Microsoft Fabric
At the moment there are two activities in Fabric pipelines that allow you to execute a “child” pipeline. They are both named “Invoke Pipeline” but are differentiated by the...
2025-06-16 (first published: 2025-06-04)
758 reads
Beginner’s Guide: Create a File Organizer CLI Tool in Rust
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface is a terminal or console interface which allows the user to interact with a software...
2025-06-14
149 reads
How AI Could Have Prevented the Bengaluru Stampede
Bengaluru Stampede Tragedy: When Celebration Turned to Chaos On June 4, 2025, what began as a joyous celebration of Royal Challengers Bengaluru’s (RCB) historic IPL win ended in a devastating tragedy. Thousands...
2025-06-13
14 reads
Is Air Travel Still Safe? | Ahmedabad Plane Crash 2025 Explained | Aviation Safety & AI Solutions
Is Air Travel Safe? Yes, air travel remains statistically the safest mode of transportation. In 2024, the global accident rate was 0.80 per million flights, with fatal accidents being extremely rare....
2025-06-13
22 reads
The Book of Redgate: Ingeniously Simple
Redgate has been known for many useful tools that are easy to use. We’ve tried to do that in all our point tools. We talk about simplicity all the...
2025-06-13 (first published: 2025-06-06)
290 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