Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Learn how to automate OpenStreetMap data refresh on Power Bi's Azure Maps reference layer.
2026-08-17
327 reads
Articles
SQL Server index tuning: common mistakes and how to fix them
This guide walks through the most common SQL Server index tuning mistakes seen in production environments, such as over-indexing, oversized INCLUDE lists, unnecessary fill factor settings, misuse of SORT_IN_TEMPDB, over-aggressive index maintenance – and the myth that heaps are a shortcut to speed. Features real examples.
2026-08-17
The Hidden Danger of Wildcard Operators In Join Operations
This article looks at one of the killers of performance at scale, SELECT *.
2026-08-14
1,635 reads
How to get clean, usable data out of SQL Server into Python
Build scalable data pipelines by pushing transformations into SQL and keeping Python focused on analysis.
2026-08-14
OUTER APPLY Fundamentals: Part 2
In Part 2 of this series we learn how OUTER APPLY can be used in your queries to return data, even when there are no matches between tables.
2026-08-12
2,425 reads
Create SQL Server 2025 Availability Groups with SSMS Wizard
SQL Server Availability Groups are great for DR and HA purposes. In this article, we look at how to setup a SQL Server 2025 Availability Group using the features in SQL Server Management Studio.
2026-08-12
How to Work with On-Premises AI Models to Generate T-SQL Code
See how a small local model performs on some SQL tasks. This shows how Ollama can run a model on your laptop.
2026-08-10
2,554 reads
How SQL Server maintenance becomes an attack path – and what to do about it
The article covers four connected areas: over-privileged database users, msdb and SQL Server Agent exposure, privileged maintenance jobs, and trigger-based permission hijacking.
2026-08-10
BIT_COUNT in SQL Server
Learn how the BIT_COUNT() function works and how it enabled operations where data is stored in bits.
2026-08-07
3,664 reads
Power BI Best Practices
In this tip, we’ll look at some best practices to help you get the most out of your models. We will also look the DAX formula language.
2026-08-07
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Learn From History
Comments posted to this topic are about the item Learn From History
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers