Be Security Smart on Haiti Earthquake
Not surprisingly, there are already vultures looking to take advantage of the tragic earthquake in Haiti for their own financial...
2010-01-13
898 reads
Blog Posts
Comments on the Bamboo Touch
I bought a Bamboo Touch over the holiday break, it’s a multi-touch pad with stylus. Easy install, basically plug in...
2010-01-13
896 reads
Connections Sessions Evals
I’ve kind of been embarassed to post these despite the fact that I received them a couple of weeks ago....
2010-01-13
571 reads
Excel Within Management Studio
Aaron Bertrand has put in a Connect request for a feature whereby data returned as a grid from a query...
2010-01-13
751 reads
Hello SMO (F#) World!
Reading The F# Survival Guide has motivated me to write my version of an F# "Hello World!" utility. What I mean...
2010-01-13
23,319 reads
How to Use SQL Backup Inside a Maintenance Plan
When you create a SQL Server Maintenance Plan using the Maintenance Plan Wizard or the Maintenance Plan Designer, the SQL...
2010-01-13
1,600 reads
LEFT(), or Left Out?
So the question came up earlier today about the RIGHT() and LEFT() functions in the SSIS expression language. Like the...
2010-01-13
667 reads
New Article on Clustering Myths in the PASS SQL Server Standard
The PASS SQL Server Standard has published a new article called “Busting 6 SQL Server Failover Clustering Myths”, by Kathi...
2010-01-13
380 reads
PASS 2009 Evaluation Results
The results are in, and I'm pleased, but not satisfied. I delivered a brand new session called Gather SQL Server...
2010-01-13
412 reads
PASS DBA Virtual Chapter Presentation
I got the opportunity to present to the PASS DBA Virtual Chapter today, discussing the properties and practical uses of...
2010-01-13
919 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
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