A Global Team Meeting
The last few years at Redgate we’ve had the entire (or most) of the marketing department come to Cambridge in the UK for a week. A few weeks ago...
2024-06-21
24 reads
Blog Posts
A New Word: sayfish
sayfish – n. a sincere emotion that seems to wither into mush as soon as you try to put it into words – like reeling in a shimmering beast...
2024-06-21
40 reads
How important is having great soft skills as a Software Engineer for personal growth and career…
How important is having great soft skills as a Software Engineer for personal growth and career successAs an Engineer, I would like to understand what I need to do to...
2024-06-21 (first published: 2024-05-26)
280 reads
What to Know about Power BI Theme Colors
Power BI reports have a theme that specifies the default colors, fonts, and visual styles. In Power BI Desktop, you can choose to use a built-in theme, start with...
2024-06-21
29 reads
Speaking at SQL Saturday South Florida 2024
I’m heading to SQL Saturday South Florida 2024 next week. This is my second time attending the event and if you’re in the Miami area (or want to take...
2024-06-20
15 reads
The Next Phase & A Fresh Start
As of June 1, I am no longer an employee at 3Cloud. I am now officially on long term disability. This marks the first time since I graduated from...
2024-06-20
26 reads
Export Extended Event Results to CSV or Table
This is something that I’ve seen pop up a couple of times on various forums recently, how can we export the results of an XEvent session. So I thought...
2024-06-19 (first published: 2024-06-06)
363 reads
Planview Portfolios REST API with ADF – Retrieving Actual Data
In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios REST API using Azure Data Factory. Any tool that can...
2024-06-19 (first published: 2024-05-26)
217 reads
Refreshed in Tuscany
I returned last Sat, 15 Jun, from 9 weeks of crazy travel. It wasn’t all for work, but it was a long stretch. I spent a good portion of...
2024-06-19
15 reads
The Community is YOU, Not Any Organization
As I type this, we’re leaving behind spring, and all the amazing events that take place then, and entering the quiet time of summer. After that, we’ll go into...
2024-06-18
21 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers