Daily Coping 29 Oct 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
What do they want to hear? from Blog Posts – SQLServerCentral
I was helping my 16yo write his first college essay the other day. He’s always struggled a bit with writing essays so this isn’t...
DAX Logic and Blanks from Blog Posts – SQLServerCentral
A while back I was chatting with Shannon Lindsay on Twitter. She shares lots of useful Power BI tips there. She shared her syntax...
Using Write-Debug from Blog Posts – SQLServerCentral
I wrote a post about PoSh output recently, noting that in general we ought to use Write-Output or Write-Verbose for messaging. In there, I...
T-SQL Tuesday Retrospective #002: A Puzzling Situation from Blog Posts – SQLServerCentral
For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we were asked one of three options, and I elected to...
Daily Coping 28 Oct 2020 from Blog Posts – SQLServerCentral
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the...
Azure Databricks and Azure Key Vault from Blog Posts – SQLServerCentral
The key vault should always be a core component of your Azure design because we can store keys, secrets, certicates thus abstract / hide...
Hans-Juergen Schoenig: PostgreSQL: Sophisticating temporary tables from Planet PostgreSQL
Temporary tables have been around forever and are widely used by application developers. However, there is more to temporary tables than meets the eye....
Scott Mead: Tracking Postgres Stats from Planet PostgreSQL
Database applications are living, breathing systems that behave in unexpected ways. As a purveyor of the pgCraft, it’s important to understand how to...
Alexey Lesovsky: Postgres 13 Observability Updates from Planet PostgreSQL
New shiny Postgres 13 has been released and now it’s the time for making some updates to “Postgres Observability” diagram.
New release includes many improvements...