Overcoming Your Limits
As I age in years, I realize more and more how blessed I was to attend The Citadel, the Military...
2010-06-08
1,263 reads
Blog Posts
PASS Summit 2010 Abstract Submissions
I submitted three abstracts for the 2010 PASS Summit this year - two "normal" (75 minute) and one spotlight (90 minute)...
2010-06-08
475 reads
SQL Saturday #22 Pensacola Recap
Saturday I drove up to Pensacola for SQL Saturday #22. Me and several others from Baton Rouge, including my two...
2010-06-08
701 reads
SSIS-DTS Package Search 2.0.18 released
SSIS-DTS Package Search 2.0.18 has been released. This is a bug fix release that addresses a problem with the search...
2010-06-08
814 reads
TechEd 2010 – BI Keynote – Part 1
The second day’s keynote is by Ted Kummert and focuses on BI.
This keynote is in one of the smaller...
2010-06-08
559 reads
TechEd 2010 – BI Keynote Part 2
In the customer demo, a few reports that were built with PowerPivot and Report Builder 3.0, which are helpful to...
2010-06-08
564 reads
TechEd 2010 – Interview With Herain Oberoi
Herain Oberoi is a Group Product Manager for SQL Server and spent 30 minutes with me talking about StreamInsight and...
2010-06-08
553 reads
TechEd 2010 – Monday Afternoon/Evening
After the keynote went back to the press room to write up notes (which I posted already), check email, eat...
2010-06-08
491 reads
TechEd 2010 – Tuesday Morning
Leisurely morning, leaving for the convention center about 8 am. Bus service has been great, they have a staff person...
2010-06-08
477 reads
The BI Conference at TechEd
It’s a bad idea. Co-locating the BI conference at TechEd has created a lot of confusion and annoyance. If people...
2010-06-08
538 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