Thinking about Pre-Cons In Orlando in 2019
In the spirit of “do more” we’re hoping to host at least 4 pre-cons in Orlando in 2019. Right now...
2018-11-27
259 reads
SQLAndy
Managing the Money for SQLOrlando
Part of the decision of setting up a non profit is committing to a bit more than minimal effort when...
2018-12-07 (first published: 2018-11-26)
1,724 reads
Notes From the 2018 PASS Summit (v20)
This was the 20th PASS Summit, a decent milestone! Interesting to pause and think, what will the Summit look like...
2018-11-12
254 reads
Reasons to Serve on the PASS Board of Directors
A few weeks back I wrote Some Thoughts on How To Prepare to Serve on the PASS Board of Directors....
2018-11-20 (first published: 2018-11-11)
1,528 reads
The No-Election PASS Election
I was disheartened to read the post that shows we have three candidates for three positions this year. Started with...
2018-11-02
308 reads
PASS Summit 2019 or Microsoft Ignite 2019?
It turns out that the 2019 Summit and Ignite will be held the same week in 2019, see this post...
2018-11-02 (first published: 2018-10-23)
2,346 reads
Some Thoughts on How to Prepare to Serve on the PASS Board of Directors
From time to time I’m asked for advice and insight on running for and serving on the PASS Board. I...
2018-10-22
248 reads
Notes from SQLSaturday #801 (2018)
We wrapped up our 12th SQLSaturday here in Orlando two weeks ago. Overall things went well. Registration was just a...
2018-10-20
255 reads
Notes from the September 2018 SQLOrlando Meetup
Notes:
30 registered, 11 attended. No weather or traffic issues. Same as the last meeting we did not send a day...
2018-09-25
249 reads
Apply for the 2019 Idera ACE Program
Sharing this before I forget, Idera is taking applications for their 2019 ACE Program. If you’re wanting to do more...
2018-09-19
761 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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