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.

Using a Service Account in Microsoft Fabric

by Additional Articles

SimpleTalk

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA and password expiration.

When Companies Fail

by Steve Jones

SQLServerCentral

Uncategorized

The challenge of software pervading all aspects of our lives and inside many products is going to be create an interesting world when companies fail.

Troubleshoot Chained SQL Server CTE

by Additional Articles

MSSQLTips.com

This article will explore how SQL Server chained CTEs might make troubleshooting code harder and whether you should stop using CTEs altogether.

Tech Debt Perils

by Steve Jones

SQLServerCentral

software development

Ignoring technical debt can cause no shortage of problems for companies. Today Steve has a recent example of this.

The GitHub Web Platform

by Daniel Calbimonte

SQLServerCentral

GitHub

Learn the basics of working with files and automation on GitHub.

Data Lake Implementation – Data Lake Zones and Containers Planning

by Additional Articles

SQLServerCentral

Data Lake

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.

Are We Dinosaurs?

by Grant Fritchey

SQLServerCentral

Uncategorized

Let's talk about the elephant in the room right up front. Yes, I'm old. I remember when Buck Woody was a little tyke on the day the last of the Tyranosaurs died (I'm older than Buck). So, I'm not asking if I'm old. Yes. I'm old. No, I'm asking if that massive meteor strike over […]