ASF 017 video invitation
What wasn’t really designed for people of guest’s stature? From who his every good decision does come from? New podcast...
2018-12-07
180 reads
Azure Player Blog
Speaking at SQL Saturday #782 Slovenia
In coming weekend I will be speaking at SQL Saturday in Ljubljana, Slovenia. I’m extra happy because I do it...
2018-12-06
220 reads
Azure Data Factory v2 and its available components in Data Flows
Many of you (including me) wonder about it. Namely: Is it possible to move my ETL process from SSIS to...
2018-12-05
228 reads
Last week reading (2018-12-02)
Hello folks, This is a quick roundup of Internet posts from last week. Have a good reading! Create and configure...
2018-12-02
195 reads
ASF 016: Chris Webb interview
Introduction Chris Webb is independent consultant specialising in Analysis Services, MDX, Power Pivot, DAX, Power Query and Power BI in...
2018-11-23
228 reads
Last week reading (2018-11-18)
No, you don’t need a blockchain Thomas LaRock (T) says: “Don’t buy a blockchain solution unless you know for certain...
2018-11-18
213 reads
ASF 016 video invitation
“Power BI is just growing and growing and getting better and better at an amazing rate.” Who said that? Watch...
2018-11-16
200 reads
T-SQL Tuesday #108 – Non SQL Server Technologies
It’s T-SQL Tuesday #108. This month’s topic is hosted by Malathi Mahadevan (B|T) and she asks us to… “pick one...
2018-11-13
225 reads
Last week reading (2018-11-11)
Hello folks, how are you today? It was a very comprehensive week and many of my friends returned home after...
2018-11-11
83 reads
SQL Relay became Data Relay 2018
It was very long and hard-working week (8.10-12.10). I was with my data-geek #SQLfamily and friends at the (SQL) Data...
2018-11-07
71 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
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