Script to review replications
This script is from my library and I use it to review what is going on with my transactional replications, try to remove statements that didn't get purged for...
2018-04-18
28 reads
Blog Posts
Script to review replications
This script is from my library and I use it to review what is going on with my transactional replications,...
2018-04-18
421 reads
SSMS: Batch Separator (Day 35)
SSMS (and other SQL Server utilities) utilize a batch separator to, well, separate batches of T-SQL statements. Before we go...
2018-04-18
2,066 reads
What’s in a Name?: Inside the Wacky World of T-SQL Identifiers
(last updated: 2018-04-28)
Today we are going to take a look into an area that you probably are thinking has very...
2018-04-18 (first published: 2018-04-09)
2,910 reads
Fix WHERE clause AND/OR/NOT confusion with truth tables
The ANDs, ORs, and NOTs in a T-SQL query's WHERE clause can get confusing, especially if you're thinking of it...
2018-04-17
2,029 reads
Guide for Set Up of Telegraf for Monitoring Windows
Problem
As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system...
2018-04-17
1,982 reads
Guide for Set Up of Telegraf for Monitoring Windows
Problem
As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system...
2018-04-17
2,446 reads
In-Memory OLTP: A Case Study
Watch this week's video on YouTube
When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it. All I could think was "my queries...
2018-04-17
9 reads
In-Memory OLTP: A Case Study
Watch this week's video on YouTube
When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it. All I could think was "my queries...
2018-04-17
6 reads
Power BI Custom Visuals Class (Module 98 – Hierarchy Chart by Akvelon)
In this module you will learn how to use the Hierarchy Chart. The Hierarchy Chart displays hierarchical data in a...
2018-04-17 (first published: 2018-04-12)
2,502 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
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
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