Troubleshoot Chained SQL Server CTE
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
Ignoring technical debt can cause no shortage of problems for companies. Today Steve has a recent example of this.
Data Lake Implementation – Data Lake Zones and Containers Planning
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?
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 […]
Outer Join – What am I missing (SQL Spackle)
This article shows how to find missing rows in a table using a outer join.
Uncover SQL Server Missing Indexes
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
AWS Services Using SQL for Big Data Analysis
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.
The Modern Algorithm of Chance
Algorithms rule the world and Steve talks about the impact those have on the world.
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers