PASS Update #50-January 2010 Board Meeting
This post is my thoughts on the Board meeting, and my views on related topics. I encourage you to read...
2011-01-31
1,951 reads
SQLAndy
MySQL Saves You From Missing Where Clause, Sorta
I’ve been taking a look at MySQL after a long absence to help a client decide if it should be...
2011-01-28
919 reads
Two Profiler Tips
I’ve had occasion to watch a lot of people try Profiler, and to hear a lot more about their previous...
2011-01-27
574 reads
A Banner Day for SQLRally
Help us promote our upcoming PASS events by including any or all of these on your blog or in your...
2011-01-25
726 reads
PASS Update #49–SQLRally
I get a lot of questions about how SQLRally is going, which tells me that there is a lot of...
2011-01-20
637 reads
New PASS Chapter in Orlando–MagicPASS
Kendal Van Dyke is launching a new PASS Chapter called MagicPASS in Orlando this week, with the first meeting on...
2011-01-19
681 reads
Notes from SQLSaturday #62
The weekend started with a later afternoon drive to Tampa, returning a couple calls and then chatting with Steve Jones...
2011-01-17
619 reads
Quietly Professional
The conventional wisdom tends to hold that you should trumpet your accomplishments to your boss, though in a way that...
2011-01-11
745 reads
SSC Editorial: Clouds in our Future
I wrote Clouds in our Future to see if I could spark a good conversation about the mental shift required...
2011-01-10
608 reads
Changes to the PASS Board
The official announcement was posted yesterday that Jeremiah Peschka and Brian Moran have decided to resign from the Board and...
2011-01-09
703 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