TSQL Tuesday 96: Folks Who Have Made a Difference
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
6 reads
Blog Posts
T-SQL Tuesday: The Contributing Factor
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two...
2017-11-14
324 reads
TSQL2sDay – Folks Who Have Made a Difference
This months TSQL2sDay is an absolute brilliant one hosted by Ewald Cress
the opportunity to give a shout-out to people (well-known...
2017-11-14
270 reads
Watching for powershell changes and running Invoke-Pester
It seems like more and more recently I have been writing powershell and typescript rather than c# and t-sql and there are quite a few things to like about...
2017-11-14
5 reads
Watching for powershell changes and running Invoke-Pester
It seems like more and more recently I have been writing powershell and typescript rather than c# and t-sql and...
2017-11-14
280 reads
Watching for powershell changes and running Invoke-Pester
It seems like more and more recently I have been writing powershell and typescript rather than c# and t-sql and...
2017-11-14
40 reads
Watching for powershell changes and running Invoke-Pester
It seems like more and more recently I have been writing powershell and typescript rather than c# and t-sql and...
2017-11-14
41 reads
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons for the same is due to release...
2017-11-13
7 reads
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons for the same is due to release...
2017-11-13
124 reads
Blogging for four years!
I find it absolutely amazing that I’ve been writing this blog for four years. My first ever post My 5...
2017-11-13
226 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