Baby Steps to Learning Something New
I had a really bad habit of trying to jump into the middle of something I didn't know very well,...
2010-03-03
4,808 reads
Blog Posts
Bookstores and Databases
My wife is a Board member for Project LEARN in Medina County, Ohio (just southeast of Cleveland). Last night at...
2010-03-03
338 reads
How Not to Write a Resume Cover Letter
Although I am not currently a hiring manager, I occasionally receive unsolicited resumes from people looking for work. I just...
2010-03-03
1,492 reads
Notes from the 2010 South Florida Code Camp
Drove down with the family Friday afternoon, not much traffic and a smooth trip. Checked into the Residence Inn just...
2010-03-03
452 reads
Recovering Data and Transactions
Recently I wrote about the disaster recovery issue recently at SQLServerCentral. Someone sent me a note asking why I didn’t...
2010-03-03
389 reads
SQLSaturday #44!
Andrew Karcher and Marlon Ribunal are heading up SQLSaturday #44 scheduled for April 24, 2010 at Golden West College in...
2010-03-03
335 reads
Using the OUTPUT clause to retrieve new identity values from SQL Server 2008
Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity...
2010-03-03
2,735 reads
Kindle for the Blackberry
Saw the announcement by accident while doing some browsing on Amazon. Thought I’d try it out just to see. Download...
2010-03-02
227 reads
Mitigating Consulting Risks
In my last post on consulting, Isn’t Consulting Risky?, I contended that in many respects, when done with sufficient forethought...
2010-03-02
1,204 reads
My First SQL Lunch
SQL Lunch has been a great resource for a while now, delivering lunchtime presentations. I was recently asked to be...
2010-03-02
344 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