2024-12-27
628 reads
2024-12-27
628 reads
I was asked recently why Halloween Protection was needed for data modification statements that include a self-join of the target table. This gives me a chance to explain, while also covering some interesting product bug history from the SQL Server 7 and 2000 days.
2024-12-18
2024-12-18
1,359 reads
2024-12-16
1,744 reads
2024-12-09
607 reads
2024-12-06
604 reads
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
2024-12-06
2024-12-04
619 reads
2024-12-03 (first published: 2024-12-02)
674 reads
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
2024-12-02
The other day I came across an interesting repo on github, KubeDiagrams. What this...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
SQL Server migrations are a headache, ask anyone who’s been through the pain of...
Hi we know (or believe) ssas saas gets stood up separately when a company...
Good Afternoon. I have been manually running an SSIS package on an adhoc basis,...
I have an always on availability group of 3 servers (1 primary and 1...
I have this code:
SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x FROM ProductSales;What is a good name for the column alias? See possible answers