Daily Coping 7 Sep 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-09-07
16 reads
Blog Posts
Azure Purview Best Practice: Naming your scans
If you’ve ever been a DBA and seen the mess that you get with SQL Agent Jobs without a clean naming standard for your job schedules and job names...
2021-09-06 (first published: 2021-08-13)
318 reads
Daily Coping 6 Sep 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-09-06
9 reads
Heraflux turns 8 – and gift for you
My company, Heraflux Technologies, just celebrated eight years in business! First, here’s a huge thank you to Molly and Jon at Heraflux. We couldn’t have done this without both...
2021-09-06
39 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-09-06 (first published: 2021-08-11)
752 reads
Publications
SQL Server on Kubernetes - Designing and Building a Modern Data Platform Build a modern data platform by deploying SQL Server in Kubernetes. Modern application deployment needs to be...
2021-09-06
1 reads
Training
Centino Systems provides online training though Pluralsight. Access our resources anytime and from anywhere. Pluralsight offers the highest quality online training available with very affordable options. Check it out...
2021-09-06
Daily Coping 3 Sep 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-09-03
13 reads
Get the month end dates of last N years
Here is a simple T-SQL script that may come handy if you need the month end dates of last N years. N is the number of years. The output...
2021-09-03 (first published: 2021-08-13)
350 reads
Work requests: It’s broke. Fix it.
Many years ago I was given a work request that literally just said: It’s broke. Fix it. I’m sure you ... Continue reading
2021-09-03 (first published: 2021-08-12)
425 reads
Blogs
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers