Last Week Reading (2019-01-20)
Hello folks! Good morning on Monday morning and let’s go through some interesting news from the #data world. Press Using...
2019-01-20
159 reads
Azure Player Blog
Last Week Reading (2019-01-13)
Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The...
2019-01-13
186 reads
ASF 018 video invitation
What popular tool has he created in 2006?
What popular tool has he created in 2006? How many people do live...
2019-01-11
183 reads
Store sensitive information with Azure Key Vault
Azure Key Vault is a service which allows you to keep and manage passwords, certificates and other sensitive information securely....
2019-01-09
282 reads
Last Week Reading (2019-01-06)
Good morning chaps! Bunch of news from data’s world freshly served. Press Introduction to Testing Your PowerShell Code with Pester...
2019-01-06
163 reads
The most-read posts in 2018
Good morning #sqlfamily folks! The very first post in the new year 2019. Tell me: when this time passed??? The...
2019-01-01
190 reads
Some pictures from 2017’s events
The 2018 year is coming to the end. It’s a good time to review the passing year and… check whether...
2018-12-26
192 reads
Last Week Reading (2018-12-23)
The Christmas is coming. But before we start the festive time and sit down to the Christmas Eve dinner – a...
2018-12-23
183 reads
Last week reading (2018-12-16)
Hello data geeks. Last week we had many news about Cosmos DB, and this time the top topics are Power...
2018-12-16
180 reads
ASF 017: Alex Whittles interview
Introduction Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the...
2018-12-14
201 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