Flyway Mistakes
I have been doing some testing with Redgate’s Flyway Desktop as a new way of managing code for databases. However, just like Git, I appreciate clients, but I want...
2022-04-06 (first published: 2022-03-21)
341 reads
Blog Posts
If I can’t use PWDENCRYPT, how am I supposed to use HASHBYTES?
For this week, here is a short post about reinventing the wheel. An interesting conversation happened on Twitter where Dave Dustin asked: “Does anybody have an example of using...
2022-04-06
32 reads
Power Automate – Date Expression Basics
In this new video series, Devin focuses on working with Power Automate Date Expressions. This first video is a primer to cover the basics of
2022-04-06 (first published: 2022-03-23)
406 reads
Removing a LocalDB Instance
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This might be obvious and easy, but I...
2022-04-06
161 reads
Daily Coping 5 Apr 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-04-05
23 reads
WITDC Mental Health and Wellness Day- April 8th
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
25 reads
WITDC Mental Health and Wellness Day- April 8th
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This ... Continue reading
2022-04-05
3 reads
A Day Off(ish)
I usually don’t post too many things about breaks, but I think that might be a bit of a mistake. I’ve struggled to get away from work at times,...
2022-04-04
29 reads
Azure DevOps dokáže opravdu překvapit
I po letech mě Azure DevOps dokáže překvapit třikrát za den Asi to taky znáte – věc, kterou jste už dělali snad stokrát, najednou prostě nejde. Nedávno jsme nastavovali...
2022-04-04
14 reads
Daily Coping 4 Apr 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-04-04
17 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