I previously spent some time troubleshooting this issue at one client, and then having encountered it twice more this year, I figured I'd include it in a blog post....
2019-02-01
6,211 reads
What's a "soft delete", and why should DBAs be aware of such behavior in tables?
So, a DELETE statement is a “hard” delete. The data is gone.
However, it is a...
2018-12-19
7 reads
Was honored to speak to fellow User Group leaders at the PASS Summit User Group leader meeting on Tuesday. Here's detail and links to some of the things I...
2018-11-07
6 reads
Was honored to speak to fellow SQLSaturday Organizers at the PASS Summit SQLSat organizer meeting on Tuesday. Here's an outline, detail and links to some of the things I...
2018-11-06
6 reads
Thanks to the full room of SQL enthusiasts who joined me today for the September Houston SQL Server UG Group Meeting! What a great crowd that enjoyed the hospitality...
2018-09-11
8 reads
New this year to #SQLSatBR that was really nice for us - we hosted a kid's STEM track leveraging an existing children's education organization operated by the STEMupBR program...
2018-08-20
6 reads
Hello everyone who was at #SQLSatBR this year!We had a huge early morning wave of attendees this morning that inundated our sponsors just like a cooling rain inundated us in...
2018-08-12
6 reads
We're a little under a month away from #SQLSatBR!We need VOLUNTEERS.Registration is required!We still have tables of all sizes available for sponsors!Our 10th annual SQLSaturday features an 14-track lineup...
2018-07-17
7 reads
What a great evening of interesting presentations, professional networking, and Jambalaya!We had 5 speakers last night on topics covering: Availability Groups (me), software documentation, leveraging the SQL Server community,...
2018-07-12
4 reads
Thanks for joining me for a full room and a boatload of quick-delivered SQL 2017 information in the second timeslot today at SQLSaturday Houston 2018! Lots of great questions,...
2018-06-23
7 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