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
45 reads
Blog Posts
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)
762 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
4 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
3 reads
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
16 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)
354 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)
428 reads
Daily Coping 2 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-02
39 reads
Daily Coping 1 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-01
40 reads
Experiment: Does sp_recompile on a table update associated views.
tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the ... Continue reading
2021-09-01 (first published: 2021-08-17)
304 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers