A Thought on Career Decisions
One of the many conversations I had at the PASS Summit was about whether to pursue Direction A or Direction...
2011-10-28
641 reads
SQLAndy
Seeing Yourself as Others Do
As life skills go one of the hardest is to see yourself as others do – they apply all kinds of...
2011-10-25
865 reads
PASS Update #66 (All Good Things)
Last week I emailed the Board of Directors my resignation effective December 31st of this year, ending my current term...
2011-10-24
641 reads
Virtual/Adhoc Teams
I’m a fan of virtual teams, times when you pull together people from across many teams to form a team...
2011-10-20
549 reads
3D Printing for Under $1000
I saw this about the iModela 3d printer, it’s priced under $1000, making it approachable if not quite cheap. 3d...
2011-10-19
619 reads
Culture Posters
I work with a client now that had a poster made of the top 10 values for the IT department....
2011-10-19
618 reads
Next PASS Summit is Nov 6-9, 2012
After enjoying the entirely reasonable weather in Seattle in October this year we’ll return to our more traditional time frame...
2011-10-19
537 reads
2011 PASS Summit-Report #4
I’m writing this at the Seattle airport on Friday night with a couple hours to relax before the midnight flight...
2011-10-15
573 reads
2011 PASS Summit–Report #3
Friday morning keynote. Quick intro from Rick Heiges. Buck Woody and Rob Farley singing, quite the sight for Friday morning....
2011-10-14
618 reads
2011 PASS Summit–Report #2
Starting the keynote on Wednesday, Bill Graziano talking about Kilt Day, quite a few of the bloggers wearing kilts (no,...
2011-10-13
600 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