GroupBy is Back – Spring 2021 Edition
GroupBy Conference is coming back May 25-26 for it’s Spring 2021 Edition. There will be 20+ FREE data sessions spread across the two days. Sessions for Americas’ time zones...
2021-05-19
17 reads
Blog Posts
GroupBy is Back – Spring 2021 Edition
GroupBy Conference is coming back May 25-26 for it’s Spring 2021 Edition. There will be 20+ FREE data sessions spread across the two days. Sessions for Americas’ time zones...
2021-05-19
117 reads
Query Compile Time
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-19 (first published: 2021-05-10)
539 reads
Daily Coping 18 May 2021
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...
2021-05-18
11 reads
Testing SQL Server backups and offloading integrity checks
We have a fair number of pretty large databases, and I was having a hard time scheduling full integrity checks to run at least once a week. For a...
2021-05-18
20 reads
2020 Advent of Code – Day 5
This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 5. I’m going to do this...
2021-05-17
16 reads
All jobs that ran during a given time frame.
Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of ... Continue reading
2021-05-17 (first published: 2021-05-06)
675 reads
Daily Coping 17 May 2021
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...
2021-05-17
8 reads
One-click Portfolio Designs, Instant PDF Embeds, and More Improvements to the Block Editor
We have some exciting new block editor updates to share with you today including fresh collection of Portfolio block patterns, a new and improved way to embed a preview...
2021-05-17
22 reads
Powershell Practice with a War Game
I attended part of the recent PowerShell + DevOps summit, and one of the sessions was from Fernando Tomlinson (@wired_pulse and @underthewire_ps) on incident response. He talked about a number...
2021-05-17 (first published: 2021-05-05)
515 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
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