I am a Champion for Canada, et Le Québec est Inclus dans Mon Pays
After reading several pages of comments on this posting, I'm taking a stab at helping Canadian Unity on my beloved...
2009-07-14
3,712 reads
Blog Posts
Is It Time for Wider Websites?
I ran across this post about time to move beyond 960 where it talks about most websites today are designed...
2009-07-14
371 reads
Orlando SQL Server User Group Meeting is Tonight
Chad Miller will be doing a presentation on Powershell and we’ll have our usually round table discussion afterward – often the...
2009-07-14
466 reads
SQL Quiz #4 - Leadership
Chris Shaw posts SQL quiz #4, I make an observation on Twitter about who gets tagged, Brent Ozar tags me...
2009-07-14
710 reads
SQLSaturday Admin Tool Updates
Cross posted from the SQLSaturday blog
Though few see it, we also maintain a full set of admin tools for the...
2009-07-14
538 reads
The Fusion IO SSD Review
Potentially it can overwhelm the bus, at least that's what this ZDNet review of the Fusion IO SSD drives says....
2009-07-14
1,748 reads
Being The Best vs. Being Affordable
I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though...
2009-07-13
605 reads
Better Know A SSIS Transform - Conditional Split
This is part 3 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the series...
2009-07-13
3,986 reads
OPASS Meeting July 14th
Hey, Orlando area SQL Server folks, don’t forget the OPASS meeting 6pmTuesday, July 14th at End to End Training (map). ...
2009-07-13
445 reads
Presenting at SQLSaturday #16
I’ll be attending SQLSaturday #16 in South Florida on August 8th and doing two presentations, one on statistics and one...
2009-07-13
331 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...
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...
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