I have been involved in countless database migrations. Most of the time I have access to the existing source servers and future destination servers. In cases where you have...
2024-02-26 (first published: 2024-02-15)
484 reads
It’s #TSQL2sday time! This month’s invitation has been sent out by Brent Ozar and he asks us to describe the most recent issue – or the last ticket –...
2024-02-23 (first published: 2024-02-13)
212 reads
proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward to – opening a decisive letter, meeting up with a friend who’s finally back in...
2024-02-23
32 reads
Last week, the Cybersecurity & Infrastructure Security Agency (CISA) put out an emergency directive which ordered federal agencies to pull Ivanti Connect Secure and Ivanti Policy Secure installations from...
2024-02-23 (first published: 2024-02-05)
195 reads
We have numerous Azure Analysis Services servers running in the cloud and needed a way to have near-real time monitoring of the queries being run. This KQL query will...
2024-02-21 (first published: 2024-02-06)
239 reads
I was working with a customer that was doing some error handling in procs and helped them do some error tracking. As we were working through things, I realized...
2024-02-21 (first published: 2024-02-07)
622 reads
As a follow up to my blog Common Data Mesh exceptions, I wanted to discuss various types of data mesh topologies I am seeing being built. I put them...
2024-02-19 (first published: 2024-01-30)
468 reads
Azure SQL Database and SQL Server 2016 introduced a new security feature for SQL Server databases called Always Encrypted. Always Encrypted is a feature designed to protect sensitive data,...
2024-02-19 (first published: 2024-02-04)
570 reads
All Spark Connect Posts
Code
What to do? At some point we will want to do something with delta lake and so I wanted to explore the options. Before we do...
2024-02-17
13 reads
maugry – adj. afraid that you’ve been mentally deranged all your life and everybody around you knows, but none of them mention it to you directly because they feel...
2024-02-16
40 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
i have huge table with lot of data and is also wide. i took...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers