Phil Factor uses SQL Clone, PowerShell and Visio to build a live 'clone network' diagram showing when there was last activity on each clone, and the number of object changes made to each one, alongside useful metadata such as the clone and image sizes, who created them and when.
2019-04-26
SQL Server Reporting Services has changed quite a bit since it was introduced in 2004. Despite new analytic services like Power BI, SSRS is still a popular tool for paginated reports. In this article, Kathi Kellenberger explains the architecture of SSRS and walks you through installing an SSRS development environment on your workstation or laptop.
2019-04-25
Phil Factor creates a simple custom metric to track the number of sessions that have recently done a read or write on a database. Having established a baseline for the metric, you'll be able to spot, and investigate the cause of, any wild deviations from normal behavior.
2019-04-25
The provisioning process is a critical part of database development. Redgate's Rebecca Edwards looks at a tool that can remove the pain points of backup and restore and replace them with a more efficient solution can hugely benefit your organization and the quality of life of you and your team.
2019-04-24
In this tip we look at a SQL Server function that generates a report of all users and their assigned database roles.
2019-04-24
Learn how to create default database compression for your SQL Server databases.
2019-04-23
Redgate is joining forces with DevOps Research and Assessment (DORA), now part of Google Cloud, as a sponsor of the 2019 Accelerate State of DevOps Report, and we're excited to see what the research uncovers.
This year, the survey's focus areas include deployment toolchains, cloud, disaster recovery, the technical environment, how we work, and more. Take the survey to help us understand how to make the (software) world better.
2019-04-23
Working in a dedicated database model is the ideal. So, what does it take to move from shared development to a dedicated model? Infrastructure costs, merging multiple changes and maintaining an increased estate might be on your list of things to consider before committing to the switch. In this article we show how Redgate tools can ease the transition and new working approach.
2019-04-22
Building on the introduction to the SQL used by Cosmos DB in the first article in the series, here you will learn how to handle some of the more...
2019-04-22
Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the security aspects of ERP systems and some of the techniques used to protect data.
2019-04-19
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Comments posted to this topic are about the item Creating a JSON Document IV
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
When the schema of an object is changed, SQL Server wipes out the previous...
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