Daily Coping 11 Aug 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-08-11
25 reads
Blog Posts
Join me on 13 August 2021 for Dativerse
This coming Friday the 13th (August 2021) is the first ever Dativerse virtual conference, hosted by our DataGrillen friends William and Benjamin. According to their site: We try to...
2021-08-11
17 reads
Last Non-NULL Date in SQL Server
The simplest of requests are often the most difficult to execute. For example, a finance team needs to know every time a customer did not invoice for 90 days...
2021-08-11
5 reads
Using Variables in Power Automate Desktop
In this video Devin continues building on a previously created Power Automate Desktop Flow design to show how to leverage variables to make solutions dynamic.
2021-08-11 (first published: 2021-07-20)
270 reads
Daily Coping 10 Aug 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-08-10
31 reads
Faster, More Flexible Editing of Your Sidebars, Headers, and Footers: Blocks for Widgets
Great news: the block editor you’re familiar with in pages and posts is now part of the widgets editor.
2021-08-10
31 reads
T-SQL Tuesday #141 Work/Life Balance
This month’s T-SQL Tuesday is hosted by TJay Belt (@tjaybelt). I find this month’s topic, balancing work and life, intriguing, and after a hiatus of non-blogging, I’m happy that...
2021-08-10
28 reads
Creating SQL Databases in AKS with PVC – Part 2
Last week I created the below with a dummy database and is something that I will do against SQL server but this time that has a persistent volume claim....
2021-08-09
60 reads
Daily Coping 9 Aug 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-08-09
22 reads
Data Mesh: Centralized ownership vs decentralized ownership
I have done a ton of research lately on Data Mesh (see the excellent Building a successful Data Mesh – More than just a technology initiative for more details),...
2021-08-09 (first published: 2021-07-23)
375 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers