Data Lineage: The Next Generation
Bill Lewis describes the benefits of an application development environment in which all data dependencies begin and remain clearly, precisely and explicitly defined.
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
How to use OUTPUT clause result in SSIS 2005 / 2008 (RC0)
The OUTPUT clause was a new feature in SQL Server 2005 that can prove very handy in many situations. New author Gennadiy Chornenkyy brings us a look at how you can add this code to your SSIS packages and retrieve ID values back from the database.
Solid State Replacements - Database Weekly (August, 18, 2008)
New SSD (Solid State Device) hard drives are infiltrating enterprise servers more and more, but are they a good fit for database instances? Steve Jones comments a bit on some news from this past week.
Telework Works
As a telecommuter Steve Jones has found it has increased his productivity, but he's not alone. Sun has examined their own telework program from the energy perspective.
Check your SQL Server using Windows PowerShell – Part 4
Earlier installments of this series illustrated how to ping the host, how to check all of the windows services related to SQL Server and how to check the hardware and operating system information. Part 4 of this series demonstrates how to get hard disk and network adapter information from the host machine.
Configure Filestream in SQL Server 2008
SQL Server 2008 offers a wide variety of features and FILESTREAM is one of the most anticipated. This article describes how to configure the FILESTREAM feature.
Epidemic Priority
As IT becomes more and more important to not only businesses but governments, what does that mean in the event of a disaster?
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
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
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