A DBA's Look at the Data Catalog
A data catalog is a way of classifying and adding metadata about the information in your database for compliance purposes. Take a look at how one DBA is using Redgate's Data Catalog.
2019-07-11
4,698 reads
Redgate Software
Creating an Automated Database Update\Upgrade Script with RedGate SQL Compare Command-Line and Powershell
A script to drive SQL Compare for building upgrade scripts.
2019-07-11 (first published: 2019-06-26)
2,135 reads
Whitepaper: Database deployments: Choosing a state-based or migrations-based approach
This whitepaper explores the differences between the approaches, state based or migrations based, and how Redgate tools can help.
2018-04-05 (first published: 2016-03-24)
6,278 reads
ReadyRoll is a Fully Fledged Redgate Tool
In June last year we got in touch to let you know that Redgate acquired ReadyRoll. Over the last few months, ReadyRoll went from a one-man project to having a team of developers, testers, and support engineers behind it. Dan Nolan, the founder of ReadyRoll, is now a product manager at Redgate. And next week it’s time for ReadyRoll to become a fully-fledged Redgate tool available from www.red-gate.com.
2016-03-03
4,385 reads
Press Release: Redgate brings expert SQL Server training to London and Seattle
Cambridge, UK, 2 July 2015 – Redgate, the SQL Server and .NET software company, returns to London and Seattle in October with its enormously popular training event, SQL in the City.
2015-07-03
503 reads
Automating Red Gate SQL Compare with MSSQL Server Agent
How to compare two databases and email the results to every one who needs to know
2014-10-29
1,800 reads
New SQL Monitor Custom Metric: Failed SQL Server logins
This metric returns the number of ‘login failed’ error messages found in the SQL Server error log file in the last hour.
2013-08-02
3,642 reads
Red Gate Software Brings Free SQL Server Training Back to US Due to Popular Demand
Red Gate Software is bringing SQL in the City, the popular free training event, back to the US in three new cities. This October, the events will take place in Pasadena, Atlanta and Charlotte.
2013-05-28 (first published: 2013-05-24)
1,616 reads
2013-05-13
5,019 reads
Job overran Custom Metric
This SQL Monitor custom metric tells you if a specific SQL Server Agent job that runs at the same time every day has overrun. The metric is useful when a job can have negative effects on other processes if it overruns.
2013-05-10
2,892 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers