Voice of the DBA

Tag: Redgate

  • The Ireland and UK DevOps Roadshow

    We’re taking the roadshow across the water. Hope the plane makes it.

    AUS02544

    The Redgate DevOps Roadshow comes to Ireland and the Northern UK in June. We’ll be in these cities on these dates:

    • June 11 – Dublin (Grant)
    • June 13 – Glasgow (Grant)
    • June 14 – Manchester (Steve)

    We’ll also have one of Redgate’s amazing Solution Engineers, Huxley Kendall. He’ll be there to answer in-depth questions on the products and solutions that Redgate offers.

    This is a great chance to get exposure to the solutions Redgate offers for building and managing your database code, as well as ask questions about the challenges you face and how we might tackle them.

    Register today and join us for a great day in one of these cities.

  • Redgate Summit Comes to the Windy City

    I love Chicago. I went to visit three times in 2023: a Redgate event, a volleyball tournament, and a wedding. Each time was a lot of fun and I look forward to coming back at the end of this month.

    The Redgate Summit is coming to Chicago on May 29. Three weeks from today! Register today and save your spot. If you get on the wait list, reach out to your account executive as they have their own tickets to give away.

    We’ve had two amazing Summits in Atlanta and London and we’re bringing the show to the Windy City. We’ll be covering a wide variety of topics related to databases, across three tracks.

    • New and Future Tech – leveling up skills about database DevOps and teams
    • Deep Dive Solutions – technical talks on innovative strategies for delivering software
    • Leadership – focused on strategic initiatives

    We have something for everyone. Technical people, managers, senior leadership, and others. Tell your colleagues and come as a group, taking in different tracks and then discussing them alter.

    I hope to see you there and register for the Redgate Summit in Chicago today.

  • The Redgate Seminar – Brisbane

    On Thursday, May 2, we have the Redgate Seminar in Brisbane. I’ll be at there along with fellow Redgate engineers, account executives, Octopus Deploy engineers, fellow Microsoft MVPs, and lots of data professionals.

    Come join me and we’ll have a great day talking about End to End Database DevOps across a number of sessions and discussion panels.

    Don’t miss the day and register today.

  • Manually Updating Redgate Monitor/SQL Monitor Patch Info

    This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using the automated process. I have other posts on SQL Monitor as well.

    I heard from a customer recently that saw on their SQL Monitor (soon to be Redgate Monitor) Estate screen that the latest patch for SQL Server 2019 was CU24. I knew that was wrong because I’d updated my build list with CU25. On monitor.red-gate.com we show the same thing.

    2024-03-25 13_28_12-Installed versions — Mozilla Firefox

    I suspected that their web server wasn’t updating for some reason, which is possible. We have plenty of customers that wall off their SQL Monitor install from the public Internet, and they have to manually update the system.

    Getting the data

    We store this info in a JSON file that the web server downloads, but you can download it yourself at: https://assets.red-gate.com/products/dba/sql-monitor/assets/files/SqlServerVersions.json?_ga=2.168000097.1575041045.1711384591-1774306502.1648754310

    If you look at the file, you see that there are versions, levels, etc., and in the SQL 2019 area, there is a CU25.

    Once you have this, you drop this on your SQL Monitor web server. The location is: C:\ProgramData\Red Gate\SQL Monitor\SqlServerVersions.json. You can replace the contents of that file with this one.

    SQL Monitor will re-read the file within 6 hours, or if you restart the server, it will re-read the file.

    That’s it. If your system doesn’t have internet access, you can still get up to date info. FWIW, this is documented at the bottom of this page: https://documentation.red-gate.com/sm13/sql-server-versioning-and-patching-195789945.html

    SQL Monitor is a top-notch system for monitoring your SQL Server and PostgreSQL estates. Oracle and MySQL coming soon. If you haven’t tried it, download an eval and give it a go or play with the demo system at monitor.red-gate.com.