NTFS Allocation Unit Size
I ordered some new drives for our Dell server from "This Old Store" recently and they came on Tuesday of...
2006-09-08
1,688 reads
Blog Posts
SQL Server 2005 Scripts on TechNet
I've not been posting over the last week because I'm in the midst of a
two week vacation, the first I've...
2006-09-01
1,458 reads
Dallas Code Camp 2006
Generally I don't look forward to giving up an entire Saturday at work. However, today's Dallas Code Camp was an...
2006-08-29
1,584 reads
Removing SQL Server Express from VS Team System for Database Professionals CTP 5
As I indicated in my previous post, Visual Studio Team System for Database Professionals CTP 5 Out,
if you don't already...
2006-08-24
1,385 reads
Downtime
Under the category of working too fast, today's downtime was brought to you by me.
I've been working an issue with...
2006-08-23
1,442 reads
Visual Studio Team System for Database Professionals CTP 5 Out
If you aren't aware, the Visual Studio Team System for Database
Professionals CTP 5 is available for download. It's a significantly
larger...
2006-08-23
1,429 reads
The Importance of Database Coding Standards
I was working with a developer the other day and the question came up
of how to return status from a...
2006-08-17
1,825 reads
Long Time No See
OK, it's been a long time since I made an entry here, mostly because I've been busy and keep forgetting...
2006-08-15
1,413 reads
2006-08-09
2006-08-09
1,408 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
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...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
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?
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