Picking the Right Type of Tool For the Job
Do we need the right tool or just a tool? A guest editorial from Andy Warren gives a few thoughts on getting things done effectively.
PowerShell Tool Time: Building Help
Learn how you can customize the help for your library of scripts in this edition of PowerShell Tool Time.
Forwarded Fetches and Bookmark Lookups
If someone says clustered indexes slow you down, they haven't read this.
What's New in the First Public CTP of SQL Server 2019
In this article we look at the first public CTP release of SQL Server 2019 and some of the great new features that will be part of SQL Server 2019.
An Open Thank You to the Microsoft SQL Server Team
Thanks for improving the string or binary data truncated error message.
SQL Server From .Net: Using SQL Server Schema to Build a Data Set
A basic introduction for developers (or anyone) to using the metadata for a SQL Server database to build a DataSet in ADO.Net that represent objects in any SQL Server database.
Security, Compliance, Data Ethics, and Breaking the “Not My Job” Mindset
Security, compliance, and data ethics are related concepts that everyone who works with software should know about, from the help desk to the C-level office… but almost everyone thinks that worrying about these things is someone else’s problem.
The Uninteresting But Necessary Work
Data classification may not be fun or even interesting, but it is necessary.
SQL Server MERGE statement usage and examples
In this tip we look at how to use MERGE compared to running separate INSERT and UPDATE statements.
Renaming a Schema in SQL Server
If you have a schema you want to retire, here's a method for moving all objects inside that schema to a new one.
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
How Important Is a Google Knowledge Panel for Online Reputation?
I’ve been learning more about the google knowledge panel and it seems like one...
Which Wireless Credit Card Terminal Works Best for Small Businesses?
I’m currently researching the best wireless credit card terminal for a growing business and...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
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