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
Blog Posts
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
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To help you answer that question, I’ve recently launched a free 30-minute SQL Server Health Check. In...
2025-09-21
19 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
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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