It’s T-SQL Tuesday again! In fact, it’s the first of the year and our intrepid host is Reitse Eskens (blog|twitter). ... Continue reading
2024-01-24 (first published: 2024-01-09)
516 reads
It’s the last Friday of the year and I’ve been struggling to think of a good way to close things ... Continue reading
2024-01-12 (first published: 2023-12-29)
303 reads
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE ... Continue reading
2024-01-05 (first published: 2023-12-26)
1,049 reads
In one of the sessions I attended during the Pass Data Community Summit the speaker asked “If master is in ... Continue reading
2023-12-29 (first published: 2023-12-19)
269 reads
Running a bit late this month for T-SQL Tuesday (it’s not exactly Tuesday is it!) but that’s Grant Fritchey’s (blog|twitter) ... Continue reading
2023-10-04 (first published: 2023-09-14)
551 reads
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading
2023-09-27 (first published: 2023-09-05)
384 reads
I’m going to start out by saying I don’t know a tremendous amount about this subject. I’ll tell you what ... Continue reading
2023-09-13 (first published: 2023-08-22)
224 reads
Three batch jobs that run all night.Seven for the DBAs to maintain and protect.Nine quick little jobs run by the ... Continue reading
2023-09-01
25 reads
My current position involves a lot of work with SQL Server Managed Instances so you’ll probably be hearing a lot ... Continue reading
2023-08-23 (first published: 2023-08-03)
438 reads
It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We ... Continue reading
2023-08-16 (first published: 2023-08-01)
480 reads
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...
Comments posted to this topic are about the item Introduction to PostgreSQL for the...
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 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