Who Changed My Database Schema?
Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace - Greg Larsen shows how to view it.
Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS
In this article, we will show how to create reports in ASDW using SSRS
I'm "working from home"
Phil Factor argues that The serious problems with working from home come not from poor productivity, but when office-based team members seem to prefer to ignore the fact that the remote workers exist.
Using AT TIME ZONE to fix an old report
Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.
The Mysterious Case of the Missing Default Value
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.
Encrypting SQL Server: Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.
Comparing Space Usage for Different Compression Types
This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.
Getting Started with Azure SQL Data Warehouse - Part 2
Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.
Continuous Delivery and the Development DBA
How to do database development with trunk based development and Continuous Delivery
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Forums
Alamat kontak resmi BCA KCP Tidar
WhatsApp:0817866887 Jl. Tidar No.109, Petemon, Kec. Sawahan, Surabaya, Jawa Timur 60252
Alamat kontak resmi BCA KCU SOLO BARU
Tlp/Wa_Cs: 0817866887 Kawasan Terpadu The Park, Jl. Ir. Sukarno, Solo Baru, Madegondo, Kec. Grogol,...
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