PASS SQLRally – Session/Speaker Selection
Hopefully by now you’ve heard about the PASS SQLRally event that will be held in Orlando, May 11-13. Andy Warren,...
2010-09-09
526 reads
Jack Corbett
- Interests: Sports, books, Bible
Upcoming Engagements
I haven’t been speaking a lot lately as I’ve been busy working, planning SQLSaturday #49 – Orlando, and planning PASS SQLRally,...
2010-09-07
480 reads
Book Review: Crunch Time
About a month ago I went to Barnes & Noble to pick up a copy of Seth Godin’s book, Tribes: We...
2010-09-01
579 reads
Last Place? Doesn’t Matter.
As the debate rages on about the PASS election I want to share my thoughts about being a candidate that...
2010-08-23
440 reads
Didn’t Make the Cut
So the slate has been announced, so now I feel like I can talk about not making the cut. Based...
2010-08-18
523 reads
Reaction to Steve Jones Missing the Cut
If you read this blog I’m sure you read Steve Jones’ blog as well, so you know that the PASS...
2010-08-18
413 reads
Growing PASS Step Two: Value
In Growing PASS Step One: Communication I talked about how I think that PASS could grow by communicating the vision...
2010-08-17
394 reads
PASS Nominating Committee Interview
As my regular readers know I applied to be part of the PASS Board of Directors. The process starts with...
2010-08-12
474 reads
August OPASS Meeting Tonight
August 10, 6:00pm - 8:30pm
Come on out and join us as our own Tim McAliley presents. For directions visit the OPASS...
2010-08-10
327 reads
SQLSaturday #49 – Orlando Update
Planning is going forward for SQLSaturday #49 – Orlando and the event is coming together well. My main task is sponsors...
2010-08-05
355 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