Window Shopping the Query Store with XEvents
This article has just shared multiple tools to help you become more acquainted with the Query Store! This acquaintance is coming via an extremely powerful tool called Extended Events....
2020-03-12
Blog Posts
A Rose By Any Other Name
There is only one kind of execution plan within SQL Server. I’ve said this several times on this blog. Now, I’d like you to go and read this excellent...
2020-03-11 (first published: 2020-03-03)
328 reads
Beginner’s Mind
In the past years I would set out my year-ahead goals both on the personal and career fronts by looking ahead at the things I want to attain or...
2020-03-11 (first published: 2020-03-03)
380 reads
Join me in Victoria this Saturday
I will be presenting a new session, “Database administration through the ages,” at SQL Saturday #950 in Victoria this coming weekend. This is one of my favourite SQL Saturdays...
2020-03-11
8 reads
Query Store for Workload Replays
UPDATE: 3/16/2020The first script below was updated from setting QDS to “Read_Write” instead of “Read_Only”. Martin thank you for pointing this out in your comment below. This month’s T-SQL...
2020-03-11
2 reads
T-SQL Tuesday #124 – I’m a Query Store Newbie
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Tracy Boggiano (blog | twitter) asks us to talk about Query...
2020-03-11
4 reads
T-SQL Tuesday #124 - I'm a Query Store Newbie
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Tracy Boggiano (blog | twitter) asks us to talk about Query...
2020-03-11
1 reads
Two years of working remotely
I’ve been working remotely for just over 2 years now and my current position is my first remote post. Before joining my current company I (and them) had concerns...
2020-03-11
7 reads
Data Privacy – Playing your part
Tuesday 28th January 2020 was “Data Privacy Day 2020” Some may refer to this as Data Protection Day, but it is really just a day to draw attention to...
2020-03-10 (first published: 2020-02-03)
190 reads
Modernizing Your T-SQL: The Sequence Object
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL Server...
2020-03-10
1 reads
Blogs
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Summer Speaking Summary 2025
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
Forums
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers