Publications
SQL Server on Kubernetes - Designing and Building a Modern Data Platform Build a modern data platform by deploying SQL Server in Kubernetes. Modern application deployment needs to be...
2021-09-06
4 reads
Anthony Nocentino
Training
Centino Systems provides online training though Pluralsight. Access our resources anytime and from anywhere. Pluralsight offers the highest quality online training available with very affordable options. Check it out...
2021-09-06
3 reads
SQL Server on Kubernetes Book Published!
I’m super proud to announce that Ben E. Weissman and I have published SQL Server on Kubernetes – Designing and Building a Modern Data Platform available now at Apress...
2021-08-20 (first published: 2021-08-04)
311 reads
Pure Storage Links
SQL Server Pure Storage SQL Server Platform Guides Pure Storage SQL Server Best Practices Pure Storage SQL Server Scripts on GitHub Pure Storage ActiveCluster with SQL Server Azure...
2021-08-17
33 reads
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to CPU, Memory, and network and disk IO using resource constraints, sometimes called Limits. You define...
2021-08-06 (first published: 2021-07-25)
1,017 reads
SQL Server on Kubernetes Book Published!
I’m super proud to announce that Ben E. Weissman and I have published SQL Server on Kubernetes – Designing and Building a Modern Data Platform available now at Apress...
2021-08-04
12 reads
T-SQL Tuesday #140 Wrap up: What have you been up to with containers?
I want to start by saying thank you to all who submitted, and an amazing collection of people submitted some fantastic content. Also, thanks to Steve for asking me...
2021-07-28 (first published: 2021-07-17)
412 reads
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to CPU, Memory, and network and disk IO using resource constraints, sometimes called Limits. You define...
2021-07-25
21 reads
T-SQL Tuesday #140 Wrap up: What have you been up to with containers?
I want to start by saying thank you to all who submitted, and an amazing collection of people submitted some fantastic content. Also, thanks to Steve for asking me...
2021-07-17
5 reads
T-SQL Tuesday #140: What have you been up to with containers?
In recent years containers have come into the data platform world, exposing new technologies to data professionals. Microsoft put SQL Server in Linux, and shortly after that, SQL Server...
2021-07-07
16 reads
Blogs
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...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
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