Displaying Sorted Hierarchies (SQL Spackle)
Learn how you can query a hierarchy of data and also return the results in an ordered fashion. A handy T-SQL skill that you will use over and over again.
Responding to a Disaster
A few recent disasters inspire Steve to remind you to prepare now, before a disaster occurs.
Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions
In this part 2 we discuss what kind of aggregates can be obtained from a temporal database and how to express these aggregations in the SQL language.
Redgate Summit: The Database Landscape - New York
Join Redgate at the last Redgate Summit event of the year! This series of events is hosted across the globe for data professionals who want to improve their skills and knowledge about Database DevOps, learn about topics surrounding the Cloud, AI, and working across multiple databases.
SQL Server 2012 Always On Groups and FCIs Part 2
This is Part 2 of a series on Always On and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.
SQL Server 2012 Always On Groups and FCIs Part 3
Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.
Stairway to Always On Level 4: Analyse and Deploy a Windows Server Failover Cluster
In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.
Stairway to Always On Level 5: Analyse and Deploy a Failover Cluster Instance
In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).
What happens when we drop a column on a SQL Server table? Where's my space?
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers