NTSSUG Meeting on Thursday: Brian Knight
The North Texas SQL Server User Group (NTSSUG) monthly meeting will be held this Thursday, August 20th, at the Microsoft...
2009-08-17
634 reads
Tim Mitchell
SSIS Documentation suggestions on Microsoft Connect
For SSIS developers, the need for proper documentation is crucial. However, the built-in object for documentation, the annotation, is difficult...
2009-08-15
1,024 reads
Getting Into The Biz, Part 2
In a previous blog post, I began writing about how one might start a career as a database professional, and...
2009-08-13
616 reads
SQL Saturday Baton Rouge – Session Evaluations
I received my evaluation summary from the SQL Saturday event in Baton Rouge earlier this month. This was the first...
2009-08-12
754 reads
Social Networking: Where Do I Start?
In a blog post a few weeks ago, I wrote about social networking in the SQL Server community. I was...
2009-08-10
999 reads
SQL Saturday Baton Rouge Downloads
I’ve published my materials from both of my sessions from SQL Saturday Baton Rouge on August 1. You can find...
2009-08-08
776 reads
SQL Bloggers, Make Yourself Known
Are you an active SQL Server blogger? Do you blog regularly about the greatest database technology available? If so, you...
2009-08-04
629 reads
SQL Saturday Baton Rouge – Recap
After a long weekend of travel and speaking, I’m finally able to put my feet up and get a little...
2009-08-03
990 reads
Why Make Up Test Data? Snag Some Government Data
… and by government data, I mean the mountain of data recently made available by the G-Men on Data.gov. This site...
2009-07-28
1,343 reads
Social Networking in the SQL Server Community
Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others...
2009-07-20
1,856 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