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
Blog Posts
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,255 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
Are You on Twitter?
Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time....
2010-01-24
1,904 reads
Recap - SQL Saturday #32 Tampa
This past weekend I was a presenter in two sessions at the SQL Saturday in Tampa.First, I just want to...
2010-01-24
501 reads
SQLSaturday 32 – Tampa Recap
I had the privilege to attend and speak at SQLSaturday 32 – Tampa this past weekend. As I said in my...
2010-01-24
557 reads
XML Index - ALTER INDEX with REBUILD Issue
I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of...
2010-01-24
659 reads
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-23
1,081 reads
SQL Saturday #32
I presented a one hour session at SQL Saturday #32 in Tampa on Powershell ETL: "In this sesssion we will look...
2010-01-23
423 reads
We Are Microsoft (GiveCamp Dallas)
Last weekend (January 15-17) found me at the third annual GiveCamp Dallas event, known locally as We Are Microsoft. This...
2010-01-23
732 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