Jason Carter has spent most of his career as a .NET developer, with time spent as a development manager, accidental DBA, and most recently a full-time DBA. Having worked with large databases as a developer, he found great interest in tuning, tweaking, and making databases run faster. With the support of his wife, he gave up his managerial duties, jumped the development ship and dove head first into his new career as a Database Administrator.

All authors

All authors

Blogs

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

By

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

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

One of the things a customer asked recently about Redgate Data Modeler was how...

Read the latest Blogs

Forums

Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments

By Massimo Preitano

Comments posted to this topic are about the item Designing Database Changes Before Deployment:...

Removing TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE

Poor Names

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Poor Names

Visit the forum

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  1933
If I run this code, what is returned? 
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers