Catch up on SQL in the City 2018–GDPR Edition
The videos for our SQL in the City 2018 broadcast from last month are up on the Redgate channel in...
2018-03-08
393 reads
Blog Posts
Finding Composite Primary Key Columns
You never know when the idea for a script will make an appearance.
I had to work with composite primary keys...
2018-03-08 (first published: 2018-02-23)
3,552 reads
Public preview of Azure SQL Database Managed Instance
Microsoft has announced the public preview of Azure SQL Database Managed Instance. I blogged about this before. This will lead...
2018-03-08
1,222 reads
Public preview of Azure SQL Database Managed Instance
Microsoft has announced the public preview of Azure SQL Database Managed Instance. I blogged about this before. This will lead...
2018-03-08
141 reads
Set New Errorlog File location – SQL Server on Linux
For SQL Server 2017 RTM, the fourth cumulative update was released on 20th February, and it is available for download...
2018-03-08 (first published: 2018-03-01)
1,599 reads
Using the Analysis Services Execute DDL Task
My grandfather used to say, “There’s more than one way to skin a cat.” I always thought it was a...
2018-03-08 (first published: 2018-03-02)
4,765 reads
Win at IT Contracting: The recruitment Agent Business Model
WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent Relationships
Welcome to WIN at IT contracting: A...
2018-03-08
523 reads
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances
For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks....
2018-03-07 (first published: 2018-02-22)
2,602 reads
Dates and Times in SQL Server: DATE
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-07
402 reads
How to Move Master Database to Another Location – SQL Server On Linux
With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file...
2018-03-07 (first published: 2018-02-23)
2,087 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
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