SQL Server MVP Deep Dives Book available for pre-order
The "SQL Server MVP Deep Dives" book that I wrote two chapters for is up for pre-order. This will be...
2009-10-02
617 reads
Blog Posts
SQLSaturday Coming THIS October 24, 2009
Hi, ALL. Sorry I've been light on content this week. I've been battling a cold, and working on some excellent...
2009-10-02
467 reads
Upcoming SQL Developer Training Course in Ft. Worth
If you are in the Dallas/Ft. Worth area and are interested in SQL Server developer training, there is an opportunity...
2009-10-02
640 reads
Book Review: The Art of Making Money
In this case making money is about counterfeiting. The Art of Making Money: The Story of a Master Counterfeiter ($18)...
2009-10-01
391 reads
Perth .NET Users Group First Stop of Down Under Tour
As the first stop of my five city speaking tour of Australia, I spoke at the Perth .NET Users Group...
2009-10-01
591 reads
Reverse Image Search
I try not to post too many links without some thoughtful commentary, but I ran across this and thought it...
2009-10-01
273 reads
Speaking at SQLSaturday #21 – Orlando
Well, I guess this isn’t a surprise since I put together the schedule, but I’m still excited to be speaking...
2009-10-01
313 reads
Tips for Networking at PASS
This year will be my third trip to the PASS conference. If you have met me or had any conversation...
2009-10-01
827 reads
Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,950 reads
Heading Down to the Basement
I'm taking the next two days off, heading down into the basement for a four day weekend. Nothing particular going...
2009-09-30
1,476 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
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