Giving PASS Chapters Access to Summit Content
I've got a request in to PASS asking them to release 2 of the many sessions that were presented at...
2007-11-19
1,334 reads
Blog Posts
Physical Fitness
Real life events continue to interfere with my regular posting. However, I would rather deal with them and neglect posting...
2007-11-19
1,569 reads
Dr Dobbs & Databases
You may not think of DDJ for database info and I'll admit that what they do cover is often a...
2007-11-15
1,426 reads
Pics of SQLSaturday
Visit the blog of Joe Healy, my favorite MS Developer Evangelist to see some pics from SQLSaturday. Joe is amazingly...
2007-11-15
1,350 reads
Generate RPC:Completed Event
I was doing a research on SQL trace regarding RPC:Completed event. So I need to generate a RPC:Completed event first...
2007-11-14
1,734 reads
Trigger Trivia Posted on SSC
A short article but interesting I think, with some good comments already. I think in general triggers are under used,...
2007-11-13
583 reads
A Couple Days With Joe Celko
We were lucky enough to have Joe come to Orlando to speak at SQLSaturday and we also talked him into...
2007-11-12
806 reads
Session Eval Results for my PASS 2007 Presentation
One of the things I discuss in my Successful Technical Speaking class (it's a
free class, usually once a quarter)...
2007-11-12
611 reads
SQLSaturday Orlando 2007 Wrap Up
I'm just finishing up sending out thank you emails to the volunteers, speakers, and sponsors that helped make our first...
2007-11-12
611 reads
Veterans' Day
I'll post Part III of Becoming a DBA tomorrow (meaning there will be two posts). Veterans' Day is typically celebrated...
2007-11-12
618 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