What do they want to hear?
I was helping my 16yo write his first college essay the other day. He’s always struggled a bit with writing ... Continue reading
2020-11-03 (first published: 2020-10-29)
321 reads
SQLStudies
How do I test if a linked server works using T-SQL?
I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they ... Continue reading
2020-10-29 (first published: 2020-10-27)
842 reads
SQL Virtual Machines
I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) ... Continue reading
2020-10-22
177 reads
My 800th post!
It took me a little bit longer to get here than I expected but I finally made it. 800 posts. ... Continue reading
2020-10-20
6 reads
Permissions script for Azure Synapse
I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for ... Continue reading
2020-10-22 (first published: 2020-10-15)
266 reads
A table is like a library : T-SQL Tuesday #131
Rob Volk (blog|twitter) is our host for TSQL Tuesday this month and wants us to Explain a database subject like ... Continue reading
2020-10-20 (first published: 2020-10-13)
459 reads
All triggers have to be able to handle multiple row operations.
Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s ... Continue reading
2020-09-11 (first published: 2020-09-03)
468 reads
SQL Homework – September 2020 – More DML Triggers
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading
2020-09-01
97 reads
As a DBA, am I a gatekeeper?
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading
2020-08-27
182 reads
SQL Homework – August 2020 – More DML Triggers
Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was ... Continue reading
2020-08-13
85 reads
Blogs
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers