Why my way of writing SQL is superior
⚠️ It’s hard to convey sarcasm over the text. I’m putting this disclaimer at the top so I don’t come off egoistic. This post is meant as hyperbole, and...
2022-04-13
36 reads
Blog Posts
Daily Coping 12 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-12
26 reads
T-SQL Tuesday #149 – T-SQL Advice you’d give to your younger self
It’s the second Tuesday of the month, so it’s time for the T-SQL Tuesday blog party! This month’s topic is chosen by Camila Henrique (blog): what T-SQL advice would...
2022-04-12
33 reads
T-SQL Tuesday #149–Advice about T-SQL to a Younger Me
It’s that time of the month again, when we have the T-SQL Tuesday blog party. This month we have a new host, Camilia Henrique with an invitation on advice...
2022-04-12
154 reads
Webinar – Intro to Azure Data Factory
I’m excited to announce I’m giving a webinar for MSSQLTips.com, with “Introduction to Azure Data Factory” as the subject. The webinar will take place at Tuesday May the 3th,...
2022-04-12
60 reads
Azure IoT Central
This is a short blog to give you a high-level overview on a product called Azure IoT Central. I saw this fairly new Azure product (GA Sept 2018) in...
2022-04-11 (first published: 2022-03-31)
190 reads
Daily Coping 11 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-11
15 reads
KQL Series – how not to waste $ running ADX clusters
This blog post is based on my personal experience running an Azure Data Explorer (ADX) cluster. I was doing a presentation for Data Platform Summit in India, I spun...
2022-04-11 (first published: 2022-03-31)
153 reads
Query Hash and Query Plan Hash Mapping
The problem
As a fan of Dynamic Management Objects (DMOs), Query Store and Extended Events, I often work with the Query Hash and Query Plan Hash (I’ll refer to them...
2022-04-11
52 reads
Daily Coping 8 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-08
33 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers