SQLSaturday in Orlando
I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event...
2007-07-23
1,500 reads
Blog Posts
What is BI?
I actually started writing an article on this, but it's been sidetracked with travel and other stuff. However I do...
2007-07-21
1,477 reads
A Graphical View of the Physical Allocation of a Database
First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's blog. The...
2007-07-20
1,656 reads
More Navigation
I've looked at the daily newsletter for a year now and I've wondered about the table of contents. It seems...
2007-07-19
1,401 reads
Tampa Code Camp - Again
This turned out to be a nice event, better venue than last year. Well organized is always appreciated even at...
2007-07-18
1,370 reads
New version of SQL Server 2005 Best Practices Analyzer available
If you haven't seen the announcement, a new version of the SQL Server 2005 Best Practices Analyzer is available for...
2007-07-17
1,717 reads
New MySQL Entry Level Certification
Last week I received an email indicating that MySQL had made available an entry level certification, the Certified MySQL Associate....
2007-07-16
1,558 reads
QOD Day
Quite a few complaints on the QOD section from last week, mostly justified. A couple I had to defend, which...
2007-07-16
1,586 reads
The meaning of Database Administrator
In two blogs I follow, Andy Leonard's blog on SQLBlogs.com and Sheeri Kritzer's The MySQL She-BA, the question of what...
2007-07-16
1,568 reads
SQL Server Reporting Services (SSRS) Templates and Styles
Ever wanted to change the default template and style for the Reporting Services Wizard? Just think how much time this...
2007-07-15
8,433 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