Journalism Ethics
I try to be pretty careful about what I write about, and now being an MVP and actually getting information...
2008-01-27
1,432 reads
Blog Posts
Inexpensive Video Training from Internals Expert, Kalen Delaney
I saw this in my blog reader today:
You can pre-order the Kalen Delaney SQL Server Internals Course - Lesson 1 DVD...
2008-01-25
1,073 reads
New Technique to Steal From Baggage
I first saw this on funsec security discussion list:
Dwarves zipped in
suitcases steal from Swedes
The gist of the story...
2008-01-25
786 reads
Post on Troubleshooting Memory Issues
Here's a post from the Windows Server Performance Team:
An Overview of Troubleshooting Memory Issues
The post discusses the following issues:
Physical...
2008-01-25
1,186 reads
SQL Server 2008 RTM looks to be 3rd Quarter
On the Microsoft Data Platform Insider blog, there is a post indicating new roadmap dates:
Microsoft SQL Server 2008 Roadmap...
2008-01-25
1,642 reads
System Sessions/Spids Rather than Spid < 50
Saw System Sessions posted on the PSS blog and it shows an example of information being written to the error...
2008-01-23
607 reads
Finding missing rows
One way to find the rows from one table that don't match another table is to use a sub-query. Here is...
2008-01-22
536 reads
A Holiday Posting
It's Martin Luther King, Jr. day here in the US where we remember the famous civil rights leader. So my...
2008-01-21
676 reads
Free Subscriptions to Visual Studio Magazine
First time I've noticed this being offered, saw it posted on the Orlando .Net Users Group (ONETUG) site. Sign up...
2008-01-21
1,443 reads
We Are Microsoft Charity Challenge Weekend
This weekend, I had the unique opportunity to donate some time to a worthwhile charity organization. Through the efforts of...
2008-01-21
841 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
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...
Forums
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
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