SQL Server Careers: Still a Goldmine, or a Dead End?
When you're searching about the future of a career in MS SQL Server, you're not just looking for a pat on the back. You want to know the truth....
2025-07-05
104 reads
Blog Posts
AI Destroying Creativity or Creative Industry
In 2025, artificial intelligence is no longer a futuristic concept—it’s a central force in the creative world. From music and film to fashion, literature, and visual arts, AI is...
2025-07-04
22 reads
DP-300 : How to Pass Azure Database Administrator Certification
As businesses increasingly migrate their databases to the cloud, the demand for skilled database administrators is skyrocketing. The DP-300: Administering Microsoft Azure SQL Solutions certification is designed for professionals...
2025-07-04
83 reads
Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance
In a recent video, I took a hands-on look at the Next Gen General Purpose service tier in Azure SQL Managed Instance—and it brings some exciting advancements to the...
2025-07-04 (first published: 2025-06-19)
242 reads
Moving to Rancher Desktop
I’ve been very happy with Docker Desktop for years, running it on both laptop and desktop. However, a corporate decision was made to move to Rancher Desktop, so I...
2025-07-04 (first published: 2025-06-16)
358 reads
How To Call Microsoft Graph API From SQL Server
Calling APIs directly from SQL Server has been available in Azure SQL DB since 2022, but now it's available in on-prem in SQL Server 2025...
2025-07-03
6 reads
Speaking Engagements 2025
It’s been a minute since I’ve gotten out to speak at events, but the second half of 2025 is going to be packed.
2025-07-03
27 reads
ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted to republish every single object, claiming they were new, despite having incrementally published changed objects...
2025-07-02 (first published: 2025-06-15)
214 reads
PASS Summit on Tour in New York City
The PASS Summit goes on tour this year, with an August stop in New York City. This is the first event in the series, and I’m excited to go...
2025-07-02
13 reads
SQL Server Agent Jobs: Set It and Forget It?
Useful tips to make your jobs more stable Too many IT teams treat SQL Server Agent jobs like a coffee timer “Set it and forget it!” Unfortunately, that mindset...
2025-07-02 (first published: 2025-06-11)
569 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
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