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
4 reads
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)
334 reads
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)
388 reads
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
9 reads
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
5 reads
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
10 reads
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
2 reads
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
13 reads
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)
197 reads
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
5 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers