Veterans Day – Thank You for Your Service
If you currently serve or have served in our military, thank you for your service. Please never doubt that your...
2015-11-11
422 reads
Blog Posts
Webinar: Unit Testing with SQL Server and tSQLt
I ran into Sebastian Meine at the PASS Summit a few weeks ago and we were talking testing. Sebastian is...
2015-11-11
672 reads
Why you should not update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
3,231 reads
Why you should not update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e81b52edda2c602772598/] The query...
2015-11-11
5 reads
Why you should not update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e9656615f713397718274/] The query...
2015-11-11
7 reads
More Thoughts on the PASS BAC
Here’s an excerpt from an email from PASS I received on November 4 and also available at this link (bolding added by...
2015-11-10
480 reads
My Build and Deploy Process (as Requested by Bill Fellows)
Recently I attended Reg-Gate’s SQL in the City event in Seattle, WA. I was in Seattle for the annual PASS...
2015-11-10 (first published: 2015-11-05)
2,663 reads
New FileTable Questions Posted on SQLServerCentral
I’m late posting this, I wrote six questions after doing a refresh of what I knew (or should have known) about...
2015-11-10
442 reads
Poor Data Modeling – T-SQL Tuesday #72
This month Mickey Stuewe hosts the T-SQL Tuesday and she has a great topic. Data Modeling is something few people...
2015-11-10
1,023 reads
Redundancy Options in Azure Blob Storage
So you have data in Azure Blob Storage and are concerned about reliability. Have no fear! There are four replication options...
2015-11-10 (first published: 2015-11-05)
1,136 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...
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