The Importance of New Speakers–#NewStarNovember
Many of us have learned how to research and get new information online. I certainly think the written word, whether from formal articles at places like SQL Server Central...
2022-11-14
7 reads
Blog Posts
PASS Data Community Summit 2022
As I write this, it’s the weekeend before PASS Data Community Summit 2022 and depending upon when I finish, it’ll post either shortly before SQL Saturday Oregon, or in...
2022-11-12
39 reads
Cloning in Snowflake
Cloning is a powerful feature within snowflake (also known as zero copy clone). You can obviously clone at the database or schema level but also tables too. It’s a...
2022-11-11
93 reads
Create Service Principal Names Along with a Managed Service Account
In a few previous articles, I have talked a lot about Managed Service Accounts (MSA) and Service Principal Names (SPN) and given examples of managing the separately. As a...
2022-11-11 (first published: 2022-11-01)
328 reads
Daily Coping Tip 11 Nov 2022
Today’s coping tip is to make a list of new things you want to do before the end of the year. Hmm, definitely some things to do, but what’s...
2022-11-11
9 reads
I'm speaking at PASS Data Community Summit 2022
Looking forward to speaking in Seattle at next week's PASS Data Community Summit by Redgate. I'll be speaking both as a representative of my role on the Microsoft Database...
2022-11-11
9 reads
Improved data loads from Snowflake to Azure Synapse Analytics
My responsibilities revolve around providing the business with the data they need to make informed business decisions. One of those processes requires us to shift data from a Snowflake...
2022-11-11 (first published: 2022-10-30)
161 reads
Off to the Summit and SQL Saturday Oregon
I’m traveling this morning. My second to last trip of the year, and another long one. Today through the 20th I’ll be in Portland and Seattle. First is Portland,...
2022-11-11
14 reads
Setting up my new workstation with some Chocolatey goodness.
As you might be aware I started a new job last week. Which means a new workstation and installing lots ... Continue reading
2022-11-11
180 reads
SQL Server 2022 Query Performance Tuning
If you’re interested in getting a digital copy, my brand spanking new book is now available here. It’s in the intro, but let me tell you a little bit...
2022-11-11
245 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers