More LINQ Discussion
Steve Jones recently posted an editorial about LINQ and the resulting discussion encapsulates most of the points of view on...
2008-04-24
1,771 reads
SQLAndy
Tribute to Jim Gray
Ran across this in the Mar/Apr ACM Queue, http://www.eecs.berkeley.edu/IPRO/JimGrayTribute/ will be held at UC Berkeley on May 31st, 2008. Jim Gray...
2008-04-24
1,358 reads
Desktop or Laptop
Most of that do any time of training or consulting typically use laptops, and they are even reasonably common in...
2008-04-23
1,614 reads
Interesting Web Hosting Option
Ran across this from Mosso, a spin off from Rackspace. Pricing looks very attractive, and there are some interesting twists....
2008-04-22
1,708 reads
SQLSaturday #4 in Orlando - With a Twist!
As you may know MS Teched is two weeks this year and is being held in Orlando. Turns out that...
2008-04-22
1,328 reads
Where are Profiler User Defined Templates Stored?
Someone asked me this recently and I really had no idea. Quick look in BOL didn't yield any results, so...
2008-04-21
1,819 reads
Information on Dell/Equilogic ISCSI
Our Dell rep sent over this link about Equilogic ISCSI SAN's, pricing is not yet posted but according to him,...
2008-04-21
866 reads
Professional Development Links
Someone asked me for these recently as they predate the blog. All were posted on SSC over the past couple...
2008-04-17
623 reads
Thoughts on Mentoring - Part 5
As a mentor I'm looking for someone with the drive to learn and grow, and willing to acknowledge that they...
2008-04-17
534 reads
Thoughts on Mentoring - Part 4
One of the dangers of mentoring someone on your team is that you can easily be perceived as biased, and...
2008-04-16
464 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