Relational Databases vs Graph Databases
In this tip we will address questions that will help relational database developers understand the various considerations for using a graph database.
SQL Agent in Level 5 of the Stairway of SQL Server on Linux
In this level of the Stairway to SQL Server on Linux, we learn how to set up and use SQL Agent.
Data privacy. Don’t look forward. Look back.
With all the talk about new data privacy legislation, we don’t stop to think about existing laws. Legislation like the GDPR kick-started the way the world views data privacy, and this blog post explores how existing laws are being used in new ways around the globe to enforce similar protection.
What are Columnstore Indexes?
Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to work with columnstore indexes, a different way to store tables that can drastically improve the performance of specific workloads.
Making Good Use of SQL Server Auditing
SQL Server Auditing is a powerful out-of-the box toolset that captures auditing information and writes to a file or the Event Log. This article examines the little things that might snag you up.
How SQL Server monitoring benefits your whole organization.
The 2019 State of SQL Server Monitoring report showed how instrumental monitoring is to managing server estates. In this guide, we go further, demonstrating how monitoring can benefit your entire organization. From development to IT management, and from finance to the C-suite. Download your free copy of the guide today
Best Practices and Band Plans
Grant Fritchey explains how database best practices should be followed more like those in Ham radio.
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA KCU SUDIRMAN Telpon/wa:0813.7887.595
BCA KCU SUDIRMAN Telpon/wa:0813.7887.595.Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota...
BCA KCP Ambengan TLP/WA 083800209966
Pert. Ambengan Plaza, Jl. Ngemplak 30 Blok A.15, Jl. Ambengan No.15, Ketabang, Genteng, Surabaya,...
BCA KCU KEBAYORAN BARU Telpon/wa:0813.7887.595
BCA KCU KEBAYORAN BARU Telpon/wa:0813.7887.595.Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby....
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