Default schema
Sadly, I haven't had much experience yet with SQL Server 2005 except for Reporting Services and SSIS. The majority of...
2006-11-27
1,397 reads
Blog Posts
SysInternals now on Microsoft TechNet
It wasn't too long ago that Mark Russinovich announced he was becoming a Microsoft employee (new link as his old...
2006-11-27
1,684 reads
NGSSoftware compares Oracle and SQL Server security
I first saw this at SQL Server MVP Jasper Smith's blog post Which database is more secure? Oracle vs. Microsoft:
NGSSoftware...
2006-11-25
1,704 reads
SSC bought out by Red Gate... Now what?
One of the highlights of my weekday mornings is reading the editorial by
Steve Jones of SQLServerCentral.com. However, this past...
2006-11-23
1,541 reads
Teaching Children to Program
One of the blogs I follow is Andrew Coates' blog over at MSDN. He has posted about starting to help...
2006-11-21
1,455 reads
Back from PASS
While at PASS, I created a thread in the forums: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=322277 . It was an incredible week. I look forward to...
2006-11-20
1,309 reads
Mixed Feelings about the SQL Server Central Sale to Red Gate
I've read numerous posts and several blogs discussing the SQL Server Central sale to Red Gate and at the end...
2006-11-20
1,631 reads
PASS Summit 2006
It's the last day of the show and my apologies for not blogging.
I haven't carried my laptop around this year...
2006-11-17
1,398 reads
Slacking
I usually set aside Tues afternoons and Friday afternoons for my Database Daily work. Scanning a couple hundred links takes...
2006-11-11
1,587 reads
SQL Server 2005 SP2 CTP Available for Download
The Community Technology Preview (CTP) version SQL Server 2005 SP2 has been released by Microsoft. You can find the download...
2006-11-08
1,974 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