Learn how you can sum data by hour and by day while showing 0 values in your result sets for those time periods without a sum in this short article by Patrick Cahill.
2024-10-25 (first published: 2011-06-13)
10,075 reads
Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA and password expiration.
2024-10-25
This article will explore how SQL Server chained CTEs might make troubleshooting code harder and whether you should stop using CTEs altogether.
2024-10-23
2024-10-21
1,863 reads
The Azure Data Lake is a massively scalable and secure data storage for high-performance analytics workloads. We can create three storage accounts within a single resource group.
2024-10-21
This article shows how to find missing rows in a table using a outer join.
2024-10-18 (first published: 2013-11-12)
24,184 reads
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
2024-10-18
AWS offers a robust suite of tools designed to manage big data effectively. This article explores focusses on how SQL is leveraged within Amazon Redshift and Amazon Athena. We will delve into the technical features, practical applications, and step-by-step examples for using these services, highlighting how they can transform raw data into actionable insights for your business.
2024-10-16
337 reads
This next article looks at how a Logic App in Azure can start and stop various database services and save money.
2024-10-16
1,812 reads
Learn how to get started with Elasticsearch with data in your SQL Server database.
2024-10-14
2,046 reads
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Comments posted to this topic are about the item Merry Christmas 2025
Comments posted to this topic are about the item The Reindeer Count
I have listed the event names present in my system_health extended event report. Based...
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers