Black Box vs. Gray Box vs. White Box Testing
If your organization is spending money, then meaningful results are a must. Pen testing isn't supposed to be a pat on the back. It's supposed to be a tool...
2026-03-17
12 reads
Blog Posts
Tooling for Success: The Best FinOps Tools and Technologies
As a DevOps person, I know that to make FinOps successful, you need more than just a good strategy—you need the right tools and technologies to execute that strategy...
2026-03-17 (first published: 2026-03-16)
41 reads
T-SQL Tuesday #196 Roundup: What career risks have you taken?
I hosted this month’s T-SQL Tuesday invitation in which I asked, “What career risks have you taken?” I got some great responses which I’ll recap here, Career risks? Rob...
2026-03-17
6 reads
Balancing Life with a Career–Slides
I had a great time at SQL Saturday Atlanta 2026 this past weekend. I had some good comments and a few questions. I’ll write a bit more on this,...
2026-03-16
5 reads
Flyway Tips: Multiple Projects
One of the nice things about Flyway Desktop is that it helps you manage your database code as a project and see what changes are being built. However, many...
2026-03-16 (first published: 2026-03-04)
154 reads
What DevOps Look Like in Microsoft Fabric
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps) is an integrated data and analytics platform designed for modern data-driven workloads, such as data...
2026-03-16 (first published: 2026-03-04)
323 reads
Advice I Like: Knots
Learn how to tie a bowline knot. Practice in the dark. With one hand. For the rest of your life, you’ll use this knot more times than you would...
2026-03-13
17 reads
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI, Today on Day 3 I would like to write about LLM models — Open Source...
2026-03-13 (first published: 2026-03-03)
349 reads
Rolling Back a Broken Release
We had an interesting discussion about deployments in databases and how you go forward or back from the point when you discover a problem. You can watch the episode...
2026-03-13 (first published: 2026-02-23)
277 reads
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as cloud adoption has matured, I’ve come to realise that building and running great systems isn’t...
2026-03-12
20 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