Schedule Announced for SQLSaturday #151 in Orlando
We had 45 speakers submit sessions this year. Sticking to our tradition here in Orlando, we accepted as many speakers...
2012-08-13
346 reads
SQLAndy
Bloggers–Don’t Make It Hard to Comment
Lately I’ve hit a couple blogs that wanted me to enter some kind of credentials before I could post a...
2012-08-13
372 reads
Ever Want to See How a Hand Plane Works?
If you’re interested in woodworking, read on!
I’ve been thinking of making a hand plane out of wood and was doing...
2012-08-12
793 reads
Don’t Miss This Presentation
Next Wednesday (Aug 15, 2012) my friend Brian Kelley (blog, LinkedIn, Twitter) is presenting for the PASS Professional Development chapter...
2012-08-10
433 reads
Tampa Code Camp Announced
The next Tampa Code Camp will be held October 13 at University of South Florida, 4202 East Fowler Avenue,Tampa, FL...
2012-08-10
492 reads
Working With Compliance
Most larger and all publicly held companies will have some sort of compliance team – often a few varieties, ranging from...
2012-08-09
574 reads
More Suggestions for SQLSaturday Admin Tools
I just finished the draft schedule for SQLSaturday #151 in Orlando and wanted to write some notes about the process....
2012-08-08
463 reads
Last Call For Speakers for SQLSaturday Orlando
Our call for speakers for SQLSaturday #151 in Orlando closes on July 31, 2012. We’ve got room for a handful...
2012-07-26
593 reads
PASS Is Hiring Another Evangelist–Could It Be You?
Just about a year ago PASS hired Karla Landrum to fill the vacancy of the Community Evangelist and that marked...
2012-07-30 (first published: 2012-07-25)
999 reads
Why You Should Speak at SQLSaturday (Or Any Other Free Event)
I talk to people about career planning and professional development quite a bit. It’s common to find them wanting to...
2012-07-25
1,068 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