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
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