The Backlog
A backlog is important for software development, and Steve has a few thoughts on how to add things to the backlog.
2022-04-08
265 reads
software development
The Challenges of Changing Software Tools
The way different generations use computers could affect how we built software tools.
2022-03-14
131 reads
Speedy Break Fix
Is DevOps and Agile better than waterfall? Steve has a few thoughts after a recent experience.
2022-02-07
239 reads
It Isn't Worth Automating
Every year I'm responsible for a portion of the Database Weekly newsletters. I used to do half, but right now Kathi, Grant, and I are on a rotation. Our boss puts out a schedule each year, which tells me the weeks for which I am responsible. Each January I then set up a recurring appointment […]
2022-01-17
187 reads
Coding for the Future
Writing code that solves problems and adapts to the future is a challenge, but it's something we should think about.
2022-01-12
278 reads
Worse Before Better
We need to approach software development with a balance of making things better, and ensuring they work.
2021-12-08
225 reads
Building a Production Database
Lessons learned from building a database caught Steve's eye, and he has a few comments.
2021-12-01
619 reads
The Complexity of Modern Systems
Building software is hard, and our systems are very complex these days.
2021-11-22
375 reads
The API Bottleneck
Using an API for data access can be good, but it can also be a performance problem if everyone uses it.
2021-11-17
883 reads
Making Software Decisions
The process of building software for others involves lots of decisions. Ensuring that you are making good decisions can impact how others view your final product.
2021-09-27
192 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers