Red-Gate Jumps the Moon
After this morning’s keynote, I managed to make it down to the expo hall JUST in time to catch Red-Gate’s...
2011-10-13
691 reads
SQL Awesomesauce
PASS Summit 2011 Day 1 – Keynote Live Blog
Welcome to PASS Summit 2011 Day 1!! Be sure to get your very own copy of the hot-off-the-presses MVP Deep Dives...
2011-10-12
1,417 reads
PASS Summit 2011 Day -2 (Monday), part 2
Today was a good day. I posted about the first part of today earlier, and we left off there with...
2011-10-11
513 reads
PASS Summit 2011 Day -1 (Tuesday)
Today was also a good day. Sean and I both popped awake at 4:30am local time (6:30am personal time), for...
2011-10-06
513 reads
PASS Summit 2011 Day -2 (Monday)
Summer camp has begun. Sure, people are still en route, but a whole bunch of us are already here and...
2011-10-06
569 reads
I Made You a Cheatsheet of Cool Things! #sqlpass
I made you something wonderful. It’s a cheatsheet for the PASS Summit, which has info about us (of course), about...
2011-10-06
620 reads
Attend the PASS Summit from Home, 2011 edition
Hidy-ho there, neighbors! This is an update of last year’s Attend the PASS Summit from Home blog. I’ll be updating this...
2011-10-03
1,537 reads
Live Blogging SQL Saturday #97 Austin (hashtag #sqlsat97)
Hello and welcome to my live blog/recap of SQL Saturday #97 in Austin! Wes Brown and the crew from CACTUSS...
2011-10-01
494 reads
Start daily programs – More n00bz fun with #Powershell!
When I get in to work in the morning, I like a good cup of coffee waiting for me, a...
2011-09-27
1,207 reads
Presenting “Tangled Code” at Charleston UG Tuesday 9/20
On Tuesday, September 20 at 5p CST (6pm Charleston time), I will present “Unraveling Tangled Code” via LiveMeeting at the...
2011-09-19
601 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