Monday Monitor Tip: Compliance Checking for Old Versions
A customer recently wanted to know if any of their instances were too old and out of support. This was for a compliance purpose, and they had the need...
2024-09-30
5 reads
The Voice of the DBA
Comparing an Old Running Total to Window Functions
Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...
2024-09-30
136 reads
Comparing an Old Running Total to Window Functions
Often I see running totals that are written in SQL using a variety of techniques. Many pieces of code were written in pre-2012 techniques, prior to window functions being...
2024-09-30
8 reads
Simple Talks Episode 7
The season 1, seventh episode of Simple Talks is out. Check it out, with Ryan as the main host. Simple Talks is the Redgate podcast from myself, Grant, Ryan,...
2024-09-27
19 reads
A New Word: the McFly effect
the McFly Effect – n. the phenomenon of observing your parents interact with people they grew up with, which reboots their personalities into youth mode, offering you a glimpse...
2024-09-27
24 reads
Connection String Confusion in SSMS
Recently I was trying to use a connection string to connect in SSMS. There are some tools that have a connection string available as an output, including some Redgate...
2024-10-11 (first published: 2024-09-25)
4,975 reads
Small Data SF 2024
I have often made an effort to attend conferences in the past to grow my career. Even today, when I speak at a conference, I’ll try to go to...
2024-09-23
17 reads
A New Word: Mottleheaded
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family, or friends and colleagues, or colleagues and family – mixing a medley of ingredients that...
2024-09-20
11 reads
Parsing EXE Output in PowerShell
I saw a post internally that asked this question: Anyone have a handy powershell script testing if the installed flyway version matches a specific string? That seemed simple, but...
2024-10-04 (first published: 2024-09-18)
441 reads
Monday Monitor Tips–Finding CUs for My Instance
How can I quickly get a CU patch for a system that’s out of date? I’ll discuss that situation. You might think you get to patch every instance every...
2024-09-30 (first published: 2024-09-16)
303 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers