What Data Is Being Sent Externally By Power BI Visuals?
As you build your Power BI reports, you may want to use maps and custom visuals. Have you thought about...
2019-02-28
53 reads
Blog Posts
A short guide to sp_executesql
Last week I talked about single use plans. One way to increase execution plan re-use is to parameterize queries by...
2019-02-27
2,001 reads
Dem queries
Dem queries, dem queries, dem slow queries,
Dem queries, dem queries, dem fast queries,
Dem queries, dem queries, dem big queries,
Now write...
2019-02-27
1,150 reads
Editorial – Dealing with Ugly Babies
One thing I learned while working as a database administrator over 17 years is the importance of teamwork across departments....
2019-02-27
245 reads
Partitioning 1: Non-partition aligned queries
Here’s my take on partitioning. I’ll be focusing on getting queries to perform on partitioned tables, and not on partition...
2019-02-27 (first published: 2019-02-11)
2,492 reads
Proposed SQL Server defaults: disable priority boost
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-27
445 reads
Query Store and a READ_ONLY Database
What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The...
2019-02-27 (first published: 2019-02-11)
2,091 reads
Using Github as a repository for SQL Server Helm Charts
In a previous post I ran through how to create a custom SQL Server Helm chart.
Now that the chart has...
2019-02-27
419 reads
Why i choose to use memory optimized table in MS SQL Server in some circumstances
MSSQL SERVERI was supporting an application which will be making a lot of concurrent calls to the database. The application which will be widely used and it will be...
2019-02-27
32 reads
Why i choose to use memory optimized table in MS SQL Server in some circumstances
MSSQL SERVERI was supporting an application which will be making a lot of concurrent calls to the database. The application which will be widely used and it will be...
2019-02-27
14 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