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,734 reads
Blog Posts
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
226 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
343 reads
Personal "Failure" Is Just a Result
I'm reading a book by two teens called Do Hard Things. It's a book which represents a rejection of the...
2010-03-02
978 reads
SQL Server - MVP Deep Dives
I got my copy of MVP deep dives earlier this month and have been making good progress in reading some...
2010-03-02
862 reads
Using Database Transactions across multiple SSIS Tasks
If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed. ...
2010-03-02
2,590 reads
Using Excel 2007 in SSIS 2005
Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade. This...
2010-03-02
1,037 reads
Volunteering Commitments
When you volunteer, you greatly enrich your life. I saw a post recently from Jason Brimhall talking about the volunteering...
2010-03-02
983 reads
Winner of the February SQL Aloha Contest
In February, I started a monthly contest at www.bradmcgehee.com to help spur some sharing of best practices among DBAs. The...
2010-03-02
372 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers