Cloud Data Driven User Group 2025 – Slides & Scripts
The slidedeck and the SQL scripts for the session Indexing for Dummies can be found on Github.
The post Cloud Data Driven User Group 2025 – Slides & Scripts first...
2025-09-25
12 reads
Blog Posts
Connect with your SQL Community on Slack
Slack is a popular tool for team interaction. To describe it quickly, it's a feature-rich persistent chat room, with threads,...
2025-09-25 (first published: 2017-05-04)
607 reads
Leading Through Change: Guiding Teams in Times of Uncertainty
Change is not a disruption in technology; it is the rhythm. New frameworks appear, markets shift, customer expectations evolve, and entire strategies can be rewritten in a single quarter....
2025-09-25
14 reads
How to Avoid Knowledge Stagnation
You want the short answer? Well, the only antidote to knowledge stagnation is probably embracing the habit of lifelong learning. For the long-winded answer, read on. Have you ever...
2025-09-24 (first published: 2025-09-04)
440 reads
How to Install SQL Server 2025 RC0 on an Azure VM
I wanted to try out the new JSON index which is for the moment only available in the SQL Server 2025 preview version. I know, it’s not even available...
2025-09-24 (first published: 2025-09-05)
396 reads
SQL Server Is Slow – Part 2 of 4(?)
The 10-Minute Outside-In Triage Don’t Blame SQL First It’s 9:05 AM and your helpdesk lights up: “The SQL Server is down. Nothing works.” By 9:07, everyone is staring at...
2025-09-24
26 reads
Local LLM Models at SQL Saturday Boston 2025
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking, two sessions I think. At least one. I’m excited for this session as I’ve had...
2025-09-23
25 reads
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise applications. They power everything from e-commerce platforms to financial systems, and their reliability is non-negotiable....
2025-09-22
73 reads
Azure Networking: Designing for Change
Failing to plan is planning to fail. When organizations first begin implementing Azure networking, the focus is often on the immediate requirements: connectivity, security, and performance for your databases...
2025-09-22 (first published: 2025-09-03)
156 reads
Secure Your SQL Estate: Best Practices for Azure SQL Security
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital estate – a castle of data, with towers of insight and vaults of sensitive information....
2025-09-22 (first published: 2025-09-02)
452 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
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