Tech Ed - Keynote
These will get pretty long as I'm kind of wordy, but these are impressions as things are occurring.
Registration is a...
2007-06-04
744 reads
Blog Posts
Working Afternoon
I ended up driving around Orlando this afternoon to get books. We'd
printed the next version of our Two Minute SQL...
2007-06-04
573 reads
Midlands PASS Chapter Meeting for June 6, 2007
Our next meeting will be on Thursday, June 7th, at
6:30 PM. Training Concepts will once again be our gracious...
2007-05-29
1,355 reads
Speaking at PASS 2007
I'll be doing a spotlight session called 'Transactional Replication for Beginners' this year. I've been speaking at the Summit since...
2007-05-29
1,362 reads
Book Reviews
I've got a new article running on SSC today with a few more book reviews: http://www.sqlservercentral.com/columnists/awarren/2998.asp.
2007-05-23
1,425 reads
The Developer Differences
Here we are starting to see information on Katmai and I'm just getting around to an article comparing SQL 2005...
2007-05-22
1,322 reads
Volunteering
I've spent my spare time the last few weekends helping a non-profit called Fast Forward here in the Columbia, SC...
2007-05-21
1,498 reads
Webcast on exceptions and errors in SQL Server
When you have an hour to spare, jump over and view this useful discussion about errors and exceptions in SQL...
2007-05-21
1,447 reads
Stored procs vs user defined functions
I was at DevTeach/SQLTeach in Montreal last week. The conference was very well run and the organizers did a great...
2007-05-19
1,309 reads
The BI World
It's been an interestng week here at the Microsoft BI Conference in Seattle and a first for me happened this...
2007-05-11
1,471 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers