Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
Using VMware VMDKs for SQL Server Database Cloning
Learn how you can clone a database with a VMDK virtual disk to store your data.
Creating Your First SQL Server Docker Container in macOS
The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL Server, however, has been difficult. That changed when Microsoft made SQL Server images on Docker available. In this article, Carlos Robles explains how to get started with Docker when running macOS.
An Alert Philosophy
Many of you reading this will be responsible in some way for managing a system. This might be a test/development system or a production one, but often you want to know how well the system is working. Or maybe you want to know if the system is working at all. Even developers care if their […]
SandDance in Azure Data Studio
In this tip we look at how to use SandDance a powerful data visualization tool that is an extension to Azure Data Studio.
SQL Server Agent for SQL Express on Linux
This article will show you how to use crontab to schedule tasks that you want to run on a SQL Server on Linux instance when no Agent is configured.
Resolving could not open a connection to SQL Server errors
Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.
SSMS or SSDT
The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.
SQL For Cosmos DB – Handling Complex JSON Structures
The JSON documents that are part of Cosmos DB document collections can be complex with arrays and nesting. In this article, Adam Aspin shows you how to query them with SQL.
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