PASSMN January Meeting Announced
The details are up and we have the meeting planned for January for the Minnesota SQL Server User Group (PASSMN). ...
2011-01-15
610 reads
Blog Posts
SQL Saturday #62
I presented a one hour session at SQL Saturday #62 in Tampa on SQL Server PowerShell Extensions (SQLPSX): “In this...
2011-01-15
418 reads
SSMSDeploy Demo #2 - new features
I've made some changes to the addin, adding some new features:
Comments: You can now add a comment to your request....
2011-01-15
608 reads
SSMSDeploy will be available, with source, for donation
After much um-ing and ah-ing I have decided to release my addin, with source code, under the GNU GPL.
I've also...
2011-01-15
568 reads
31 Days of SSIS – Instant Excel Spreadsheet (14/31)
31 Days of SSIS
It’s day fourteen of the 31 Days of SSIS blog series. It’s also Friday, so I’m taking...
2011-01-14
612 reads
Denver SQL Server User’s Group Meeting on January 20, 2011
My good friend, Kevin Cox, of Microsoft’s SQLCAT (SQL Customer Advisory Team) will be giving a presentation on what is...
2011-01-14
558 reads
Failed Blog Posts
Over the last week I’ve started and trashed two blog posts. Let me tell you, that’s painful. You get some...
2011-01-14
728 reads
Last Call for Speakers 24 Hours of PASS
Calling for Presenters!Today is the day! If you were planning to submit a session for the next 24 Hours of...
2011-01-14
792 reads
Multi-tenant Architecture
When you design a database, or at least when I do, I think it’s important to build a database schema...
2011-01-14
4,470 reads
Removing Time From A Datetime Value
How much time would a DateTime have if a DateTime had no time?
Ok, forgive the bad pun. But the point...
2011-01-14
891 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