Changing Startup News Feed in Visual Studio
Are you tired of the same old Microsoft news feed when you open Visual Studio (BIDS)? Why not go ahead...
2009-07-24
741 reads
Blog Posts
HTTP 404 Not Found with Reporting Services and Windows 7
Here are some steps to fixing an issue I ran into with Window 7 and Reporting Services 2008. The problem...
2009-07-24
16,695 reads
Kindle Update - The iPhone App
I have an iTouch, and I recently downloaded the Kindle app to give it a try after I broke my...
2009-07-24
1,235 reads
Learning some javascript
As part of my work I need to be a “Jack of all trades” meaning I not only need to...
2009-07-24
641 reads
More SQLSaturday Announcements
Stuart Ainsworth is launching SQLSaturday #24 & #25, both in Gainesville, GA on October 9th and 10th respectively, and yes, one...
2009-07-24
639 reads
SQL Server Powershell Extensions PowerGUI PowerPack
If you've been working with Powershell, you most certainly have heard of PowerGUI, for those of you who haven't PowerGUI is...
2009-07-24
1,164 reads
The effects of DISTINCT in a SQL query
Earlier today, I had a great Twitter conversation with Tim Mitchell (@Tim_Mitchell), Jorge Segarra (@SQLChicken), and Jack Corbett (@unclebiguns) about...
2009-07-24
2,023 reads
Book Review: The Candy Bombers: The Untold Story of the Berlin Airlift and America's Finest Hour
Found The Candy Bombers: The Untold Story of the Berlin Airlift and America's Finest Hour by Andrei Cherny ($20 @ Amazon) ...
2009-07-23
544 reads
Gadget Man
I'm searching for a new laptop bag. After getting a backpack from Microsoft and using it on a few trips,...
2009-07-23
867 reads
Perfect Game
They rarely happen, just a few in my lifetime, and I saw a portion of one years ago in a...
2009-07-23
628 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
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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