Recently PASS Data Community Summit sessions were selected and the wounds were opened on Twitter around speaker diversity in the community. I heard from several people via my DMs...
2022-07-15 (first published: 2022-06-30)
215 reads
Deb Melkin (b | t) is hosting T-SQL Tuesday this month and is letting us rant. Who doesn’t like to rant about databases and the famous “it depends”. She...
2022-07-13 (first published: 2022-07-12)
26 reads
Over the last four years, ok it seems longer than that, I’ve started four jobs. A couple just weren’t good fits. One I was at for three years. I...
2022-07-11 (first published: 2022-06-27)
674 reads
In my previous post, I expounded on my first 30 days I had at four jobs in the last four years. and how to setup your jobs box. I...
2022-07-05
48 reads
Now that your CFS has been setup it’s time to get the word out first. There are many ways to this. I start with using the Cfs secret page...
2022-07-01
48 reads
Having recently taken a new job and introducing a number of new tools to my new coworker I thought I’d share how I setup my jump box to and...
2022-06-28
25 reads
SQL Server can run in any Virtual Machine that has the appropriate operating system (yes, I said that because I have some hope, that we will one day learn...
2022-06-20 (first published: 2022-06-03)
453 reads
It’s that time of the month again, the blog party, woohoo! This time Mala Mahadevan (b | t) has invited us to blog about our T-SQL coding standards. I...
2022-06-14
47 reads
I had a problem at work recently where a record was getting updated, and no one knew where or what was updating the record. Our team discussed the best...
2022-06-14
164 reads
I jumped on the bandwagon early so to speak to use the user group feature of Sessionize and since then I’ve walked at least five user groups through setting...
2022-05-31
33 reads
One feature that I have been waiting for years! The new announcement around optimize...
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
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...
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
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