Is it time for SQL Server to have Isolated Transactions?
SQL Server allows nesting of Transactions –in a sense. In truth, there is only one Transaction, with each ‘nested transaction’...
2009-03-10
788 reads
Blog Posts
Microsoft March Security Bulletin Release
This month there were 3 security bulletins released and 1 re-released:
Microsoft Security Bulletin Summary for March 2009
First, let's tackle the...
2009-03-10
1,197 reads
PASS Connector Editorial for March 11, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-03-10
581 reads
The Kindle Alternative - Humor
Kind of funny. I saw this on Twitter the other day from @DanNunan and then someone sent it to me...
2009-03-10
764 reads
[Off-Topic] Eleven Year-Old Making a Difference
Those who know me personally know that I grow my hair out to donate for kids. I have donated a...
2009-03-09
1,014 reads
Book Review: Murach's SQL Server 2008 For Developers
I received a review copy of Murach's SQL Server 2008 For Developers a couple months back and just finished up...
2009-03-09
1,175 reads
Netbooks - Hands On Review
The other day I was wandering around Best Buy and noticed that they had a few netbooks for sale. I...
2009-03-09
1,346 reads
Book Review: Big Red - Voyage of a Trident Submarine
I've grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book...
2009-03-08
417 reads
Building Reports, 2.0 Style
I’m getting my first taste of the new SQL Report Builder 2.0, and so far I’m enjoying the upgrade. Report...
2009-03-08
2,388 reads
MVP Summit 2009 -A Most Excellent Adventure
For many of us, one of the high points of being an MVP is attending the annual MVP Summit hosted...
2009-03-07
413 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...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
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