An Alternative (Better?) Method to UNPIVOT (SQL Spackle)
Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later.
I may need to re-think the use of table variables
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
Migrate a SQL Server Database to a PostgreSQL Database
Learn about various options to migrate an entire SQL Server database to a PostgreSQL database.
Thinking About Technology
Steve is thinking about technology today, inspired by a developer/architect that asks some philosophical and moral questions of software.
Microsoft Fabric, the Land of Wizards and Trolls
In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about and whether it brings anything new to the data insights domain.
SQL Server 2012 Always On Groups and FCIs Part 1
Learn how to get a Failover Cluster Instance set up and configured with Windows and SQL Server. This is part of a series showing how to combine a Failover Cluster Instance of SQL Server with an Always On availability group.
SQL Server 2012 Always On Groups and FCIs Part 4
This is Part 4 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.
Stairway to Always On Level 1: What is "SQL Server Always On"?
Level 1 of the stairway looks at exactly what the technologies "Always On", "Failover Cluster Instance" (FCI) and "Windows Server Failover Cluster" are. We'll look at each in detail and summarize where in the High Availability stack they sit.
Stairway to Always On Level 2: Storage 101
In this new level of the stairway, we examine the storage knowledge you need for an Always On configuration.
Stairway to Always On Level 3: Infrastructure 101
In this next level of the Stairway to Always On, we will look at the components required to implement a Windows Server Failover Cluster.
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