At Redgate Software, we've been trialing Copilot from GitHub with our developers. I managed to get access for this experiment and have tried a few things, though I'm not sure I've found it very useful. I'll continue to work with Copilot, but for now, I just don't find Copilot AI helping me with the types […]
2023-07-31
204 reads
I took part in a podcast this week, Arrested DevOps. I did one with them once before, almost ten years ago. The host and I were both a little surprised that it had been so long. This caused us to look back a bit. Interestingly enough, ten years ago meant I was only about two […]
2023-07-29
60 reads
Reviewing Pull Requests (PR) is something that developers should take seriously, but Steve doesn't think this always happens.
2023-07-28
351 reads
Today Steve wonders to which version you would upgrade your SQL Server instances. There should be a minimum version you would try to reach.
2023-07-26 (first published: 2019-05-03)
381 reads
Most of us want more autonomy at work, but it isn't given out without effort. Today Andy Warren has a few thoughts on how to get more freedom from your boss.
2023-07-24
133 reads
Brent Ozar has his quarterly report on SQL Server versions and SQL Server 2022 isn't being used as much. Does that make sense to you? What versions are you installing?
2023-07-22
444 reads
An interesting approach to schema changes is a creative solution to Steve. He asks if you have other creative solutions you've seen.
2023-07-21
140 reads
Steve saw a policy on code usage in software development and wondered how many companies have this.
2023-07-19
164 reads
2023-07-17 (first published: 2018-03-08)
385 reads
The other day, I was in a Twitter discussion interviewing people for technical positions. This reminded me of one of my favorite things to do in interviews… reading the list of qualifications/skills and asking questions about its contents. If you put it on the resume, I assume you know something about it and are willing […]
2023-07-15
138 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item Creating JSON III
Comments posted to this topic are about the item Testing is Becoming More Important
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