Article re-featured on SQLServerCentral
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,414 reads
Jack Corbett
- Interests: Sports, books, Bible
ActiveAugust –> Getting More Fit
ActiveAugust started as a discussion on Twitter and Mike Walsh (@mike_walsh) has set the bar with his blog post about...
2009-07-28
1,199 reads
SQLSaturday 21 – Orlando Announced!
Andy Warren and crew at OPASS have announced that SQLSaturday 21 – Orlando will be held at Seminole Community College, 100...
2009-07-28
1,299 reads
Learning some javascript
As part of my work I need to be a “Jack of all trades” meaning I not only need to...
2009-07-24
641 reads
Meet, Greet, & Remember?
How many of you have said, “I have a real hard time remembering names” or “Excuse me, I know we...
2009-07-21
413 reads
Mystery of Failing Database Mail
Have you ever seen this error when you have setup database mail:
The mail could not be sent to the recipients...
2009-07-20
429 reads
July OPASS Meeting Recap
Last night I attended, along with about 20 others, the latest and greatest OPASS meeting. I got there early to...
2009-07-15
531 reads
Off Topic – Why I’m unclebiguns on Twitter
There may be some people wondering why I go by the name @unclebiguns on Twitter. I am basing this on...
2009-07-15
397 reads
OPASS Meeting July 14th
Hey, Orlando area SQL Server folks, don’t forget the OPASS meeting 6pmTuesday, July 14th at End to End Training (map). ...
2009-07-13
445 reads
Mid-year update on my goals
I recently saw that Steve Jones had posted an update on his 2009 goals and realized that is was about...
2009-07-07
368 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