Remote Work
This is going to be the first time I’m working remotely today in over a year. I’m in Omaha, and while I’ve gone to a few cities, I haven’t...
2021-04-30
18 reads
Blog Posts
Daily Coping 29 Apr 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-04-29
18 reads
Modernizing Your T-SQL: String Aggregation
This is another in a group of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. SQL Server 2016 gave us the STRING_SPLIT()...
2021-04-29 (first published: 2020-02-18)
1,270 reads
T-SQL Copy & Paste Pattern – Increasing a performance problem
Disclaimer: The title is my assumption because I saw it in the past happening this way. This blog post aims to make you remember something: something that is obvious...
2021-04-29 (first published: 2020-02-21)
1,291 reads
WITDC Mental Health and Wellness Day- May 7th
Next Friday WITDC is having a Mental Health and Wellness Day virtual event and I’ll be speaking! I can’t tell ... Continue reading
2021-04-29
41 reads
.NET PowerShell Notebooks – Using Pester
My last post had a lot of information about the new .NET PowerShell notebooks including installation instructions. .NET Notebooks are Jupyter Notebooks that use .NET core to enable C#,...
2021-04-28 (first published: 2020-02-22)
272 reads
2020 Advent of Code–Day 4
This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 4. I’m going to do this...
2021-04-28
26 reads
Ambling through undocumented DBCC commands may result in boredom
There comes a time when we heed a certain call. The call is to avoid dangerous undocumented DBCC commands in SQL Server, especially those that bypass built-in protections. I’m...
2021-04-28
31 reads
Daily Coping 28 Apr 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-04-28
15 reads
My Deadlock Resolution Progress Report
As I wrote last month, I went through a period of feeling personally and professionally deadlocked, and flailed about for some time before I found the answer of making...
2021-04-28 (first published: 2020-02-21)
411 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Inventory Snapshot for missing Period
Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers