Tuesday notes! Today I’m in Execution Plans in Depth by Hugo Kornelis. Notes: Today the presenter is using the Cadmium/EventScribe platform instead of GotoWebinar Started off with a lot...
2020-11-11
18 reads
Writing most of this Monday afternoon while on lunch break. I’m attending the Advanced T-SQL Querying and Query Tuning pre-con by Itzik Ben-Gan. You access pre-cons via the Virtual...
2020-11-10
19 reads
I’m in learning mode this week, scheduled for two full day pre-cons plus the Summit. I’ve been to a couple of virtual events already this year, but they were...
2020-11-09
83 reads
It’s just over 30 days to the 2020 PASS Summit and that is plenty of time to get the boss to say yes, but you have to ask! I...
2020-10-14 (first published: 2020-10-05)
179 reads
I know that we don’t yet know how the 2020 Summit will turn out, but I’ll make some guesses: A lot of people like it for the lower cost,...
2020-08-18 (first published: 2020-08-05)
741 reads
I’m sure it’s no surprise, but we’ve decided to cancel SQLSaturday Orlando 2020. We decided a couple weeks ago but it’s been tough to summon the energy to write...
2020-07-17
89 reads
Some thoughts on the PASS Virtual Summit this year: Clearly the in-person option wasn’t doable. Just too hard to know infection rate, local rules, employer travel guidelines, attendee and...
2020-07-31 (first published: 2020-07-17)
219 reads
I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write them down to at least be able to look back at them once the storm...
2020-04-04
148 reads
We’ve cancelled our upcoming Meetups in April and May due the loss of our venue (due to corona virus worries) though we would have probably cancelled them anyway. Our...
2020-03-16
6 reads
The notes! Attendance was the speaker dinner was great! Always nice to have a lot of people there. During the day logistics all went well, though it’s still a...
2020-03-08
26 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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