Machine Learning in the Database
Steve talks about Machine Learning Services in SQL Server and whether using this is a good idea.
Indexes That Have Not Been Used but Are Being Updated
Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.
Using Power BI in a Hybrid Environment
This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.
Be Prepared with Baselines
Analyzing performance often requires you to understand what is normal and what is not. Steve talks about the importance of baselines.
Improving SQL Server 2016 Large Database Performance
This article aims to save you days or weeks of troubleshooting when using SQL Server 2016 for large databases
Converting a Database to In-Memory OLTP
In-Memory OLTP was introduced with SQL Server 2014 as a way to improve transaction performance. There are several scenarios that are not supported, such as some data types, and Darko Martinovic describes the issues and provides workarounds. He also has provided a tool to assist in migrating disk-based tables to In-Memory optimized tables.
Better Comments
Is there a best way to comment code? Or maybe just different styles. Steve Jones asks what you think today.
I thought my database was collation agnostic
My struggles with a customer's database that used a different collation sequence. The easy way is never the right way, or is it?
How to Create Deadlocks and Troubleshoot Them
Watch in awe and wonder as Brent Ozar creates a deadlock, then uses sp_BlitzLock after the fact to show you which queries and tables were involved.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers