After a gap of sixteen months, Lionel Clarke, the creator of the only 3-D maze game to be written in TSQL, returns with a new SQL puzzle. It is very simple. You have to move as much of the data as you can from the source tables to the destination tables.
SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement.
The growth of SQL Server's subsystems leaves Steve Jones wondering how should we be thinking about the product.
With the tenth installment of his series on XML, Jacob Sebastian turns his attention to the art of namespaces and how you can avoid ambiguity in interpreting various elements.
Find pointers to optimize tempdb performance in SQL Server by striping and splitting across multiple files in SQL Server 2005.
SQL Server 2005 offers T-SQL language features that can improve your productivity.
Spreadsheet to calculate a reasonably accurate picture of energy use of PCs and peripherals in your company.
The SQL Server team is looking for feedback on deleting databases and Steve Jones gives a few ideas.
The new custom report feature of SQL Server 2005 SP2 allows you to incorporate Reporting Services report definitions (.rdl) files into SQL Server Management Studio (SSMS).
Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.
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...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
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