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.
SQL Server v.Next is Coming in 2019
The announcement of the next version of SQL Server excites Steve.
Adaptive Query Processing in SQL Server
Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.
Uploading On-Premise data to Azure Blob Storage using SSIS
Azure SSIS Feature pack can be used to upload the data over to Azure Storage account. In this article, Supriya Pande will describe how you can upload the data to Azure Blob Storage using SSIS task.
Questions About HIPAA That You Were Too Shy to Ask
As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to day responsibilities. Rebecca Edwards answers common questions about HIPAA that you were too shy to ask.
Adding User Comments to Reports in SQL Server Reporting Services
In this tip we look at a new feature in SQL Server Reporting Services that allows users to leave comments about reports.
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 PANGERAN JAYAKARTA TLP/WA (08216977701)
Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta Pusat,...
BCA KCP Senayan City TLP/WA 08216977701
Mall Senayan City Unit 6-09A, Jl. Asia Afrika Lot 19, Daerah Khusus Ibukota Jakarta...
BCA KCP Pasar Tanah Abang TLP/WA 08216977701
Jl. KH Fachrudin 36 Blok D/23, Daerah Khusus Ibukota Jakarta 10250
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