Phil Factor shows how to automatically apply T-SQL modification scripts during image and clone creation. Using this technique you can, for example, apply data masking to all clones, or customize an individual clone to work on a special variant or branch version, or set up instance level objects like Agent jobs or linked servers.
Someone tried to build a database engine from scratch. While not something Steve wants to do, it's an interesting exercise.
Want to get database DevOps implemented where you work but unsure where to start or how? We’ve written a handy blog to help you begin your database DevOps journey....
All it really means is, “Click Execute again, and you will be fine.”
Building software for the cloud often requires some changes. This week Steve wonders how many of you are making the effort.
Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.
SQL Monitor not only collects all the disk and database growth tracking data you need, automatically, but also analyses trends in this data to predict accurately when either a disk volume will run out of free space, or a database file will need to grow.
In this tip we look at how to build a custom approach to managing SQL Server Agent history data.
I travel a fair amount for work to speak at various events around the world. Traveling can be quite a disruption to my life, and I do work to limit the amount of time that I'm gone. As my kids have gotten older, I'm have less commitments at home and an extra night during a […]
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
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