Is Your Internet Activity Hurting Your DBA Career?
I have been active on the Internet for 15 years, and during that time I have left a long trail...
2008-12-17
1,069 reads
Blog Posts
Jumpstart TV SQL Server security videos on-line
Back in October I had the opportunity to work with Andy Warren and do a series of SQL Server security...
2008-12-17
1,401 reads
Microsoft’s First iPhone Application
Can you believe it? Microsoft has just released an iPhone application for the first time and I doubt it will...
2008-12-17
2,051 reads
The Best Thing About The Kindle
You might think it's the e-ink screen. It's not.
You might think it's the ability to carry around hundreds of books...
2008-12-17
861 reads
Investing In Your Career
I saw this blog from Jeffrey Yao on investing in your career, and thought it would be a great editorial....
2008-12-16
818 reads
Kindle Update - Encouraging the Kids
I remember when each of my boys started to read a lot. There was a time when both of them...
2008-12-16
767 reads
SQL Quiz Part 2 - Career Challenges
Another diabolical idea of Chris Shaw. I'm actually late to the game because I got tagged a week ago by...
2008-12-16
985 reads
A Good Use of Surface
I first saw a Surface Computer at the Sheraton in Seattle and thought it was pretty cool, but not necessarily...
2008-12-15
740 reads
A Week of Books - Part 1
I've been catching up on reading over the last month and I feel like taking a break from things technical/community/etc...
2008-12-15
657 reads
A Week of Books - Part 2
I'm just finishing up Boards At Work which talks about how a good board of directors can make a big...
2008-12-15
570 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
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:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
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