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
Blog Posts
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)
267 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
30 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
27 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
26 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
59 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
21 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)
370 reads
How do I unlock a SQL Server Login using T-SQL (without changing the password)?
We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a ... Continue reading
2021-08-09 (first published: 2021-07-22)
810 reads
Podcast and presentation decks on data architectures
Tomorrow (Tuesday (8/10/21) I will be on a podcast for SaxonGlobal called “The Alphabet Soup of Data Architectures” where I will talk about the modern data warehouse, data fabric,...
2021-08-09
6 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers