Monday Monitor Tips: AI Query Analysis
AI is everywhere. It’s in the news, it’s being added to every product, management wants everyone to be more productive with AI. Redgate Monitor isn’t immune from this wave....
2026-03-09
24 reads
Blog Posts
Semantic Model Power Query vs Dataflow Gen2 in Fabric
In my recent blog post, Building Power BI Reports: Desktop vs Fabric, I talked about the evolving authoring experience in Microsoft Fabric and how report development is increasingly moving...
2026-03-09
53 reads
TempDB Internals – What’s New (SQL Server 2016 to 2022)
I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-09 (first published: 2026-03-02)
493 reads
The First Steps: Understanding the Basics of FinOps
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out of control without the right practices in place. That’s where FinOps comes in—it’s a powerful...
2026-03-09
18 reads
Advice I Like: In 100 Years
In 100 years a lot of what we take to be true now will be proved to be wrong, maybe even embarrassingly wrong. A good question to ask yourself...
2026-03-06 (first published: 2026-02-20)
595 reads
The Book of Redgate: Mistakes
This is kind of a funny page to look at. The next page has more detail. This is the text from the facing page: What we do is very...
2026-03-06
37 reads
What is ALM in Fabric?
As someone who’s worked with data for over 20 years and with many cloud platforms, my main focus has always been on helping teams streamline their development process. A...
2026-03-06 (first published: 2026-03-02)
605 reads
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we will discuss more on different free notebooks available to write / code LLM and get...
2026-03-05
19 reads
A bespoke reporting solution doesn’t have to cost the earth
You could be tolerating limited reporting because there isn’t an off the shelf solution that meets your needs and you’re scared about the costs of a fully bespoke reporting...
2026-03-04 (first published: 2026-02-22)
358 reads
The Most Successful Startups in 2025 — And What They Have in Common
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll see companies like OpenAI, Anthropic, Gemini, Lovable, and Poolside AI dominating the conversation. Different names,...
2026-03-03 (first published: 2026-03-02)
27 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
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
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...
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