Fixing WD EX2 NAS Access Issues on a Fresh Windows Installation
rssfeeds-admin I recently ran into a classic home lab problem. Everything worked perfectly before. New Windows...
SQL Authority
Local AI Models for SQL Server – A Complete Guide
What if you could bring the power of AI into SQL Server without sending a...
SQL SERVER and AI – Setting Up an MCP Server for Natural Language Tuning
Every DBA has faced that moment when SQL Server feels like a silent partner. You...
SQL SERVER Performance – JSON vs XML
During a recent consulting engagement with a premier client, I encountered a critical performance bottleneck...
SQL SERVER Performance: When MAXDOP = 1 Slowed Down the Entire Business
Recently, I had the opportunity to work with an organization that was experiencing severe performance...
First Look at Apache Airflow 3.0: A Game-Changer in Workflow Orchestration
If you’ve spent any time wrangling data pipelines, you know that Apache Airflow is a...
Automating SQL Server Deployments Across Multiple Databases Using Python
When managing multiple SQL Server environments—such as development, staging, and production—running the same deployment script...
SQL SERVER – Catching Non-SARGable Queries in Action
If you ever wondered why a query that looks harmless is performing poorly despite having...
SQL SERVER Performance Tuning: Catching Key Lookup in Action
If you’ve ever run a SQL query that looks simple but takes longer than expected,...
ANSI PADDING and Storage – SQL in Sixty Seconds 210
ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing...