What's wrong with Linq to SQL
There's a lot of buzz in the development community about LINQ in general, and for those that do data access...
2008-02-04
458 reads
SQLAndy
Notes on the South Florida Code Camp
I attended the South Florida Code Camp this past Saturday and it turned out to be quite an event. More...
2008-02-04
315 reads
Hello Secure World - MS Site Worth Looking At
Saw this in the MSDN flash yesterday, MS has a new Silverlight site up (newest toy and all!) that focuses...
2008-01-29
1,396 reads
The Long Tail
Another book I read recently, The Long Tail by Chris Anderson of Wired Magazine goes into detail talking about some of the changes...
2008-01-29
1,482 reads
IT Transparency Posted on SSC
As I mentioned yesterday the article I wrote on IT Transparency is finally live today and now the wait to...
2008-01-29
1,304 reads
Agenda Posted for South Florida Code Camp
I'll be there doing a presentation on Transactional Replication, and my friend Chris Rock will be doing on on LINQ to...
2008-01-28
1,384 reads
IT Transparency, the intro!
Tomorrow SSC is scheduled to publish an article I wrote on IT Transparency which gives a first person account of...
2008-01-28
1,423 reads
Visiting the Charlotte SQL User Group on Feb 27th
I'll be visiting the Charlotte SQL Group on Feb 27th and I'll be doing one of my favorite presentations, Transactional...
2008-01-28
1,376 reads
Interesting Article about Measuring Performance in Software Test Mag
The Jan 2008 issue of Software Test & Performance Magazine (available as free PDF download, you can also download back issues...
2008-01-27
1,650 reads
System Sessions/Spids Rather than Spid < 50
Saw System Sessions posted on the PSS blog and it shows an example of information being written to the error...
2008-01-23
607 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