Microsoft Network Monitor 3.0 Released
If you aren't familiar with Network Monitor, it's a packet sniffer that's a Windows component on the server builds (Control...
2006-11-29
1,591 reads
Blog Posts
SSMS and scripting
I've heard a lot of complaints about SQL Server Management Studio concerning slowness and some of the things, like scripting...
2006-11-28
1,368 reads
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,403 reads
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,705 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,456 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,311 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,399 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers