PASS Attack!
It’s Friday. Tomorrow I present two sessions at SQL Saturday #238 – Minnesota. Then I take off for PASS Summit 2013...
2013-10-11
707 reads
Blog Posts
Reblog: October 4 to October 10
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-11
607 reads
Slides for SQL Server Internals Presentation with PASS DC Chapter
For those of you that attended yesterday and are interested in the slides, you can download them here. Thanks! Topic:...
2013-10-11
741 reads
Speaking at SQL Saturday #227 Charleston this weekend
I am proud to be selected to speak at this weekend’s first ever SQL Saturday in Charleston, SC. I am...
2013-10-11
569 reads
SSIS Records on the Same Row – kind of like pivot
If you have two or more records on the same row, and need to write each record on its own...
2013-10-11 (first published: 2013-10-07)
2,099 reads
What Does The PASS Community Mean To You?
In less than 72 hours I'll be in Charlotte with over 3,000 of my closest SQL Server friends for the...
2013-10-11
706 reads
Coast to Coast with SQL Saturday
Last month I blogged about the SQL Crazy train making a whistle stop in Providence Rhode Island. A couple of weeks prior to that, you may have read this...
2013-10-10
3 reads
Coast to Coast with SQL Saturday
Last month I blogged about the SQL Crazy train making a whistle stop in Providence Rhode Island. A couple of...
2013-10-10
657 reads
One Down
Yesterday was our first 2013 SQL in the City event in Pasadena, CA. I was excited and nervous, with 3...
2013-10-10
788 reads
PASS Summit 2013
The PASS Summit 2013 is almost here! Check out all the great sessions and speakers. I feel very fortunate to be able to speak...
2013-10-10
630 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