Book Review: Crunch Time
About a month ago I went to Barnes & Noble to pick up a copy of Seth Godin’s book, Tribes: We...
2010-09-01
579 reads
Blog Posts
Common SQL Server Mistakes - SELECT *
I’ve been trying to work on some new presentations so that I have a variety, including some spares, when I...
2010-09-01
4,399 reads
Creating a PerformancePoint 2010 Data Source
In a previous post I wrote about getting started with PerformancePoint 2010.In that post you learned about what PerformancePoint is...
2010-09-01
898 reads
For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
Note: Republishing because the article covering the issue and a workaround has been published here on SSC.
In a recent thread...
2010-09-01
4,309 reads
Naming Keys & Constraints
G'day,
This is pretty much my first blog post - at least on sqlservercentral.com - so to get started I thought that I'd...
2010-09-01
447 reads
Notes on Jacksonville Code Camp 2010
Overall it was a great event, attendance in the 350-400 range. Boxed lunches instead of pizza (good!), not much in...
2010-09-01
325 reads
Retrieving Report Names for SSRS Subscription Jobs
The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look...
2010-09-01
784 reads
September Question: What feature is missing from SQL Server that you would most like to see included in the next release?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-09-01
391 reads
SQLSaturday SLC 2010
Well, I have taken another plunge. I finally got around to submitting a session for SQL Saturday Salt Lake City...
2010-09-01
510 reads
The DBAs Joke of the Day: Which RDBMS Was that You Say?
So someone walks in from another department and asks about hosting some new high volume, huge database that pushes data...
2010-09-01
615 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