Scaling SSRS Support for SQL Azure with Containers
In this article, see one of the ways in which a container can be created and used for in SSRS as the source for reports.
2019-07-30
3,579 reads
Paul Stanton
Using VMware VMDKs for SQL Server Database Cloning
Learn how you can clone a database with a VMDK virtual disk to store your data.
2019-06-20
4,538 reads
Ordering T-SQL Scripts with Git and PowerShell
Learn how you can ensure that scripts are executed in a specific order with Git and PowerShell for use in a Docker container.
2019-05-28
5,002 reads
SQL Server DevOps with Production Databases and Git
Learn how to start using DevOps techniques to upgrade your database containers with the latest version of your code from a git repository.
2019-03-11
2,938 reads
SSRS Scale Out with Standard Edition Containers and Instances
Learn how to use database cloning to scale out your reporting services workload.
2019-01-29
2,200 reads
Cloning SQL Server Instances with Containers
Learn how containers and WinDocks can be used to quickly provision copies of databases.
2018-12-31
2,124 reads
Introducing SQL Server SSRS in Windows Containers
Learn how to deploy Reporting Services into a container with Windocks.
2018-10-04
8,639 reads
SQL Server 2008 Migration to SQL Server 2017 Linux Containers using Database Cloning
Learn how you can get a SQL Server 2017 container working with Docker and Windocks.
2018-08-28
1,219 reads
Docker SQL Server 2017 Linux Containers with database cloning
Learn how containers can help with database development.
2018-06-07
767 reads
Containers for enhanced Data Governance and Compliance
Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.
2017-07-25
345 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
BCA KCU DARMO No.telp:08385883375
Whatsapp:08385883375 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
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...
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