SQL Source Control Webinar
One of the new products that Red Gate Software has released recently is SQL Source Control. I saw a demo...
2010-07-23
1,481 reads
Blog Posts
SQL University: Introduction to Indexes, Part the Third
Nice to see most of you have managed to fight your way through the shoggoths outside to attend another lecture...
2010-07-23
878 reads
SQLRally Logo Contest
Kendal posted the announcement yesterday that we opened the design content on 99designs. I’ve used the site before and it’s...
2010-07-23
573 reads
Syndication on SQLServerCentral
I have a few people ask about this recently, so I thought I’d blog about it, and maybe get an...
2010-07-23
999 reads
The week that was Friday 23 July 2010
Its been a busy week this week. From troubleshooting several production issues to writing some incremental load SSIS scripts, the...
2010-07-23
517 reads
.NET speaker Idol, Guess who won?
Last night (July 21, 2010) I had the honor of being a speaker at the Baton Rouge .Net User Group. ...
2010-07-22
810 reads
Good Eats at SQLLunch today
Hey folks, Check out SQLLunch.com today at 12:30 EST for my presentation on Introduction to dimensional modeling. It's going to...
2010-07-22
385 reads
Local Library Policies
Over the past couple years our local library system has been under financial pressure, resulting in some changes, and maybe...
2010-07-22
988 reads
Project Houston For SQL Azure
Microsoft has released CTP1 of Project Houston for SQL Azure. Project Houston is a Silverlight web based database management tool...
2010-07-22
658 reads
Seven Reasons You Should Attend SQLBits 7
SQLBits is Europe’s Largest SQL Server Event
That’s right, just take a moment to let that point hit home. If you...
2010-07-22
866 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