A Call to Arms
Phil Factor’s most recent guest editorial over at SQL Server Central has, to a degree, pointed out that the emporer’s...
2010-01-25
801 reads
Blog Posts
devLINK 2010 Call for Speakers is Open
The devLINK 2010 Technical Conference’s call for speakers is now open, and you can find information about speaking at the...
2010-01-25
497 reads
Living with TED 5000
Since I installed my TED 5000 home energy monitor about a week ago, I have learned quite a bit about...
2010-01-25
937 reads
Microsoft – Follow best practices – Part 2
In addition to my previous post, another best practice is to not use NOLOCK and READ UNCOMMITTED transaction isolation level.
Here’s...
2010-01-25
546 reads
Should You Achieve All Your Goals?
So many people wrote posts at the end of 2009 analyzing their goals and what they achieved. I did the...
2010-01-25
1,044 reads
Speaking at SQLSaturday #30 in Richmond
I'll be presenting two sessions this Saturday (January 30, 2010) in Richmond - Automate SQL Server Administration with PowerShell and Gather...
2010-01-25
359 reads
SQL Saturday 30 – Richmond VA
This weekend, I’ll be headed for the east coast to speak at the SQL Saturday in Richmond, VA on Saturday. ...
2010-01-25
715 reads
Web Site Tuning
I just spent a couple days doing some minor tuning on SQLShare and here are some notes from that effort.
I...
2010-01-25
603 reads
Working with ADO.Net variables in SSIS scripts
I am always looking to improve the performance of my SSIS packages. I try to do as much work within...
2010-01-25
520 reads
Working with ADO.Net variables in SSIS scripts
I am always looking to improve the performance of my SSIS packages. I try to do as much work within...
2010-01-25
5,252 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