DCAC recently had a custom PowerPoint template built for us. We use PowerPoint for teaching technical concepts, delivering sales and marketing presentations, and more. One thing I love about...
2019-10-28 (first published: 2019-10-16)
769 reads
I’ve had a lot of video collaboration tools come across my desk over the last decade. I’ve depended on many of these to communicate with Redgate in the UK...
2019-10-28
57 reads
It is a non-null constraint, not a non-ish-null constraint You are writing an ETL process, part of this process you need to import a semi-structured file (think CSV, JSON,...
2019-10-28
169 reads
It is a non-null constraint, not a non-ish-null constraint You are writing an ETL process, part of this process you need to import a semi-structured file (think CSV, JSON,...
2019-10-28
7 reads
I’ve had the opportunity in the last month to do a couple of different consulting visits, one private and one through my employer, Redgate. The goals of each of...
2019-10-28
19 reads
Earlier this Brent ran a poll about the preferred session length and more than 50% liked the idea of 45 minute sessions. Interesting, the idea of trying to fit...
2019-10-27
16 reads
At this year’s PASS Summit, I’ll only be around for a short time, and really only Monday night. I have two pre-cons to do and then need to get...
2019-10-26
173 reads
Introduced in April 2019, Databricks Delta Lake is, in short, a transactional storage layer that runs on top of cloud storage such as Azure Data Lake Storage (ADLS) Gen2...
2019-10-25 (first published: 2019-10-15)
903 reads
Read only replica is a great concept where we can re-direct all the read only connections to that replica. Following are some of the great articles for it....
2019-10-25
121 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. While testing a script recently, I needed to...
2019-10-25 (first published: 2019-10-16)
351 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