Daily Coping 2 Sep 2020
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...
2020-09-02
13 reads
Blog Posts
Group By 2020 Fall Edition – Call For Speakers
The Call for Speakers for the 2020 Fall edition of GroupBy is open, but it closes in just 3 days! We’re currently using Sessionize to help us organize this...
2020-09-02
47 reads
Recursively Querying Row Groups
Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....
2020-09-02 (first published: 2020-08-25)
588 reads
The final word on storage for DATETIME2
Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest because one of the...
2020-09-02
23 reads
Who is your Fail-Safe Agent??
Did you know it is possible for SQL Server Agent to alert you of problems if something goes haywire with your Agent? Have you ever had an issue with...
2020-09-02 (first published: 2020-08-25)
400 reads
Creating Azure SQL Database AAD Contained Database Users with an SPN using PowerShell, Secrets Management, Azure Key Vault, and dbatools
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case. After creating Azure SQL Databases...
2020-09-01 (first published: 2020-08-21)
558 reads
Daily Coping 1 Sep 2020
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...
2020-09-01
18 reads
Fun with Power BI and Color Math
I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast...
2020-09-01 (first published: 2020-08-20)
411 reads
SQL Homework – September 2020 – More DML Triggers
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading
2020-09-01
101 reads
A kubectl plugin to decode secrets created by Helm
Last week I wrote a blog post about Decoding Helm Secrets. The post goes through deploying a Helm Chart to Kubernetes and then running the following to decode the...
2020-08-31 (first published: 2020-08-18)
239 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Kapuk Muara Telpon/wa.085373737699
BCA KCP Kapuk Muara Telpon/wa.085373737699.Jl. Duta Harapan Indah Jl. Kapuk Muara Raya No.33 Blok...
BCA KCP Plaza Medan Fair Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Gedung Plaza Medan Fair, Jl. Gatot Subroto No.30 GF-1G, Sekip, Kec. Medan Petisah,...
Cara buka blokir permata bank salah pin 3×
Cara buka blokir Bank Permata (rekening/ATM/mobile) dapat dilakukan melalui PermataTel di 1500-111, whatsapp, 0821"3737"9963...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers