A Not Quite Average Sunday
Ever had a day when a bunch of small things run together to create a day you wish you had...
2009-10-12
325 reads
Blog Posts
Afraid of Presenting? Try Toastmasters
I should be writing a technical post in the next day or so. I've been focusing more on the community...
2009-10-12
1,328 reads
Carolina Code Camp - The Good and the Bad
This past Saturday I was able to participate in the Carolina Code Camp, help just outside Charlotte, NC. I was...
2009-10-12
929 reads
Congratulations to John Magnabosco
Congratulations to John Magnabosco for being awarded as a Microsoft MVP. I met John last year at the Indy Tech...
2009-10-12
616 reads
Congratulations to John Magnabosco on SQL MVP Status
See his quiet post about it here. This comes right after finishing up his first book titled Protecting SQL Server...
2009-10-12
280 reads
Generate Lots of Test Data with CROSS JOIN
“Joe Test”
“Joe Test2?
“Joe Test3?
“Arrgh! There has got to be a better way to create some test data!”
Ever had that conversation...
2009-10-12
3,352 reads
PASS Update #15
We just had our October board meeting, this one ran the full hour and was a good discussion, catching up...
2009-10-12
229 reads
SQL Server Lunch Milestone (100+ Attendees)
Today’s SQL Lunch was a huge success, even though we experienced a few technical difficulties. Tim Mitchell spoke on Deploying...
2009-10-12
774 reads
We can't all use duct tape
I read The Duct Tape Programmer from Joel Spolsky recently, and I thought he made some good points. Then I...
2009-10-12
687 reads
Here Comes SQLSaturday 21 – Orlando
Here it comes! The big event on my schedule SQLSaturday #21 –Orlando. We’ve got over 300 registered so it should...
2009-10-11
494 reads
Blogs
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...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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