A New Word: Anderance
anderance – n. the awareness that your partner perceives the relationship from a totally different angle than you – spending years looking at a different face across the table,...
2025-09-12
510 reads
Troubleshooting SQL Server – Starting with the Error Log
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?” What’s your first move? For me, it starts with the SQL Server Error log. I...
2025-10-03 (first published: 2025-09-11)
566 reads
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly efficient, OLTP systems were the workhorses of enterprise data. They handled the daily grind: purchases,...
2025-10-08 (first published: 2025-09-11)
307 reads
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend. The first one is at Retro Data (20th of September), a new virtual conference focusing...
2025-09-12 (first published: 2025-09-11)
385 reads
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved a mystery alone. Scooby and Shaggy could sniff out a clue between snacks, but it...
2025-10-03 (first published: 2025-09-10)
227 reads
SQL Server Availability Groups
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups (AGs), they changed the HA/DR game. Unlike Failover Cluster Instances (FCIs), which protect the whole...
2025-09-10
24 reads
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing a Power BI report. It’s easy to forget the active page since it’s just set...
2025-10-01 (first published: 2025-09-09)
173 reads
New AI capabilities in SQL Server 2025
(Side note: Excited to share that the audio version of my book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh” is...
2025-10-01 (first published: 2025-09-09)
826 reads
T-SQL Tuesday #190–Mastering a New Technical Skill
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great invitation that is near and dear to my heart: mastering a new or existing technical...
2025-09-09
77 reads
Getting Started with the MSSQL AI Agent in VS Code
Recently I was working in VS Code and I saw a walkthrough for the new Copilot chat features. I decided to give those a try in trying to get...
2025-09-08
516 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers