T-SQL Tuesday #101: My Essential SQL Server Tools
This month’s T-SQL Tuesday topic comes from Jens Vestergaard (b|t) who is asking us about our essential SQL Server Tools.
I’ve...
2018-04-10
308 reads
The DBA Who Came In From The Cold
Friday Reading 2018-04-06
Feels like an age since I posted some links. So busy these days!
I’m really excited today as tomorrow I head...
2018-04-06
265 reads
Changing the port for SQL Server in Azure Container Services
I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure...
2018-04-05 (first published: 2018-04-04)
1,748 reads
Imposter syndrome
Last week I posted the following “joke” on twitter: –
I’ve called it a “joke” but I wasn’t really joking. This...
2018-04-02
292 reads
How I became a Data Platform MVP
As I spent last week attending my first MVP Summit in Seattle I thought I’d write this post about how...
2018-03-14
396 reads
A gotcha when switching partitions
When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of...
2018-02-28
3,142 reads
Indexing and Partitioning
Partitioning tables is a great tool to increase the manageability of your data. Being able to move large amounts of...
2018-02-21
3,840 reads
Summary of my Partitioning Series
Partitioning Basics – Part 1 – Creating Partitions
Partitioning Basics – Part 2 – Splitting/Merging Partitions
Partitioning Basics – Part 3 – Switching Data
Partitioning and filegroup restores
Update to...
2018-02-19
448 reads
Dealing with stress
Anyone who knows me will know that I’m something of a stress head. I tend to worry about things and...
2018-02-19
382 reads
Friday Reading – Speaking Mentors
A new project underway is Speaking Mentors. I think this is an amazing idea and the response that it’s had...
2018-02-09
398 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