Tools I Use on My Jump Box
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
17 reads
Blog Posts
Alert Filtering in SQL Monitor
SQL Monitor has improved a lot over the last couple of years. We have multiple teams building features and addressing issues, and each month when we have a readout...
2022-06-27
38 reads
Daily Coping 27 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-27
9 reads
dbatools - Exceptions
Who doesn’t like a good red and verbose exception? At PowerShell community we often call it a “sea of red” which we found as something that can be intimidating....
2022-06-27 (first published: 2022-06-07)
355 reads
How To Create A SQL Server 2022 Learning Sandbox In Few Easy Steps
Microsoft has recently released the public preview of SQL Server 2022. You can find info here. Microsoft peddles SQL Server 2022 as “the most cloud enabled version Microsoft has...
2022-06-27 (first published: 2022-06-08)
880 reads
A Few Thoughts on SQL Saturday Jacksonville
I was lucky to attend SQSQL Saturday Jacksonville 2022L Saturday Jacksonville 2022 a couple of weeks ago. This was the first SQL Saturday of 2022 for me, and the...
2022-06-24 (first published: 2022-05-25)
168 reads
Daily Coping 24 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-24
12 reads
TSQL Tuesday #150: Your first technical job. Rollup.
This months subject for T-SQL Tuesday was Your first technical job. I have to say I really really enjoyed reading ... Continue reading
2022-06-24 (first published: 2022-05-24)
235 reads
Daily Coping 23 Jun 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-06-23
16 reads
Backing up to s3 Compatible Object Storage with SQL Server
Introducing S3 in SQL Server 2022 S3 compatible object storage integration is a new feature introduced in SQL Server 2022. There are two significant areas where SQL Server leverages...
2022-06-22 (first published: 2022-06-06)
225 reads
Blogs
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting...
Forums
SQL server help (converting rows to columns)
I am using the following sql to convert rows into columns for each pid,...
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Comments posted to this topic are about the item Ingesting Data From REST API...
Separate Reads
Comments posted to this topic are about the item Separate Reads
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers