SQL Server error 18456
Working with thousands of instances of Microsoft SQL Server, I often encounter users having issues. A common error is 18456 which indicates a login failure.
The post SQL Server error...
2025-06-18
109 reads
ColumnStore Indexes: The Secret to Fast SQL Queries
🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍 What Are Columnstore Indexes? Unlike traditional row-based indexes, Columnstore Indexes organize and store data by...
2025-07-07 (first published: 2025-06-18)
1,049 reads
How To Test SQL Server Disk IO Throughput
When managing large databases or high-transactional databases, the performance of your underlying storage system is crucial, whether it...
2025-06-18
5 reads
Becoming a Presenter: My Journey and Tips
I still remember my very first presentation many years ago. Someone in my team asked me to demo a project I’d been working on, and I was absolutely terrified....
2025-06-17
14 reads
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
In an era where cloud computing drives innovation, understanding its fundamentals is no longer optional—it’s essential. The AZ-900: Microsoft Azure Fundamentals certification is the perfect starting point for anyone...
2025-06-17
29 reads
Are Your Disks Lagging?
Recently, one of my clients was experiencing performance issues with their SQL Server. Although the server was not underpowered from a...
2025-06-17
2 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)
360 reads
Logging in Azure Data Factory data flows
(2025-June-15) Long gone are the days when a data engineer could simply focus on building a new data integration solution. You’d establish connections to one or more source datasets, review...
2025-06-30 (first published: 2025-06-16)
465 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
Beginner’s Guide: Create a File Organizer CLI Tool in Rust
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface is a terminal or console interface which allows the user to interact with a software...
2025-06-14
149 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
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers