Thoughts on the March 17, 2015 PASS Town Hall
I listened to most of the town hall today. The main topic was the just voted on changes to the...
2016-03-18
597 reads
SQLAndy
Notes from SQLSaturday Tampa 2016
Quick notes:
Speaker dinner at Spaghetti Warehouse. Good location, but just a little confined and a little noisy. Perfect location is...
2016-03-09
607 reads
Notes From the February 2016 OPASS Meeting
I gave my presentation on automating restores. Part philosophy (why you need it) and part tech (one way to do...
2016-03-09
638 reads
SSC Editorial: Lessons From Little Green Army Men
This one is about spending time with my daughter – she bought some army men as a toy after a visit...
2016-03-09
520 reads
SSC Editorial: Spousal Surcharges
I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is...
2016-03-09
478 reads
Comments on Proposed Changes to the NomCom Process
On Friday Thomas LaRock posted Changes to the NomCom Process on the PASS blog for comment prior to the Board...
2016-03-01
619 reads
Building With Iron Pipe
For a while I’ve been wanting to do a project that used black iron pipe for the main structure. Kind...
2016-02-16
716 reads
Moving to Open Live Writer
I’ve used Windows Live Writer for almost as long as I’ve been blogging (mid 2007 or so). It’s worked well...
2016-02-11
775 reads
Speaking at OPASS on February 25, 2016
Last month I visited MagicPASS, this month I’ll be at oPASS and presenting again on my pattern for automating database...
2016-02-02
554 reads
Pausing PASSWatch & What’s Next
I just posted Pausing PASSWatch on the PASSWatch blog, wrapping up a project that ran about 16 months. It’s hard...
2016-02-02
603 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