Searching Complex JSON Data
Watch this week's video on YouTube
Computed column indexes make querying JSON data fast and efficient, especially when the schema of the JSON data is the same throughout a table.
It's...
2019-02-26
18 reads
Blog Posts
The Reader’s Choice Awards are Taking Nominations
If you’re using products, you might want to nominate a vendor or product for a database tool that helps you....
2019-02-26
888 reads
Undercover TV – Sean McCown Joins Us For a Session on Beginning Powershell SMO
In this episode, Adrian looks at some of the new features of the Undercover Inspector1.3 and special guest, Sean McCown...
2019-02-26
242 reads
What Does the Undocumented UNCOMPRESS Function Do?
(last updated: 2019-02-26 @ 18:35 EST / 2019-02-26 @ 23:35 UTC )
IntelliSense in SQL Server Management Studio (SSMS) can be quite helpful. It...
2019-02-26
1,013 reads
Workload analysis with WorkloadTools
Last week I introduced WorkloadTools and promised additional posts to describe what it can do in more detail. So, here...
2019-02-26
570 reads
Friend of Red Gate
I’ve been a champion of Red Gate’s tools for years. Quite simply, they help me get work done quicker. They...
2019-02-25
161 reads
How Do You Export A Database in Azure Data Studio
I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I received recently asked how to export a database from...
2019-02-25
14 reads
Imp Linux Commands
Important Linux Commands 1. uname -a: To know what version of unix we are using 2. hostname: System name 3....
2019-02-25
361 reads
Interview Trick Questions
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want...
2019-02-25 (first published: 2019-02-04)
3,173 reads
Last Week Reading (2019-02-24)
Hello folks! This time quick review about Kubernetes, containers, automatic deployment of Data Factory and few things about Power BI....
2019-02-25
161 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers