PASS FY2019 Budget Notes Updated
PASS has updated the notes supporting the FY 2019 budget to answer the questions I raised in my earlier post....
2018-09-10
277 reads
SQLAndy
Looking at the PASS FY 2019 Budget
I just spent a few more minutes looking at the FY 2019 budget. It is hard to assess whether it’s...
2018-09-14 (first published: 2018-09-04)
1,527 reads
Volunteer for the PASS NomCom
The call for applications for the Nominating Committee closes on Sep 10th. If you care about the future of PASS...
2018-09-04
265 reads
More on Two Posts About PASS
Yesterday I linked to two really interesting posts about PASS and I hope you read them. I’ll start with a...
2018-08-28
239 reads
Two Posts About PASS
I’m a little late getting to this, but I think both of these are worth reading:
https://www.linkedin.com/pulse/open-letter-pass-group-leaders-sql-saturday-steve-rezhener-mba/https://medium.com/@SteffLocke/sqlsaturdays-shouldnt-give-up-pass-money-a478a97ee0c7Suggest you post any thoughts...
2018-08-27
275 reads
The Failed One Laptop Per Child Project
I wrote about OLPC back in 2010 (and before that, somewhere back on a post I didnt port over here...
2018-07-30
334 reads
Zero Width Characters
Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of...
2018-07-23
520 reads
Paper Model of Hubble Telescope
Not even close to being about SQL, I ran across the plans for a paper model of the Hubble Telescope while...
2018-08-03 (first published: 2018-07-20)
2,326 reads
Getting Schooled by Brent
Earlier this year Brent Ozar invited me to attend some of his online classes for free. Free is good! Training...
2018-07-27 (first published: 2018-07-19)
2,390 reads
SQL Solver
A few months back I ran across this article for checking semantic equivalencies of queries. That’s interesting, from the perspective...
2018-07-19
408 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