Voice of the DBA

Tag: Redgate

  • 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.

  • Bringing the Redgate Seminar to Brisbane

    We’ve been on a Redgate tour this year, running lots of events to interest, educate, and inspire customers. We know that there are challenges in building and operating database software, and our goals are to help you get better.

    I’m heading to Australia in a few weeks. Hopefully on a slightly larger plane (and inside).

    AUS02694

    The Redgate Seminar is in Brisbane on May 2. It’s an all day event where we’ll talk about how Redgate can help you solve your database management challenges, as well as bring DevOps to the database.

    We’ll open the day with a keynote on the state of the database landscape, looking at some of the things we’ve learned from research (our own and industry pieces) as well as from customers. The world of databases is on a journey and I’ll talk through some of that.

    The rest of the day has a number of sessions on products as well as panels where you can hear from not only me, but also industry experts that will join us. We’re also partnering with Octopus Deploy, and you’ll hear from their engineers as well a few of ours.

    If you can get to Brisbane, come join me. Register today and  I promise you a day of fun at the Pacific Hotel in Spring Hill. Redgate Software is a great host at events, and this is a chance to enjoy our hospitality.

  • Webinar Apr 9: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise

    On Tuesday I have a webinar with a Redgate sales engineer: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise. This will cover

    You can register here.

    In this webinar, we’ll look at the Flyway solution and technology, with some demos that show how this can create more reliable, repeatable deployments that catch errors or issues sooner by testing deployments multiple times.

    This is a nice, short look at Flyway, so if you haven’t seen the technology, or you have DBA deploy manually, come check this out.

    Register today and I’ll see you Tuesday.

  • Apr 9 Webinar: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise

    UPDATE: This moved to Apr 9

    Join me Tuesday, Apr 9 for a webinar, 10:00am CDT. You can register here and then come watch live with questions or get the recording.

    In this webinar, we’ll look at how the Flyway suite of tools can help your team better build and manage database deployments. I love Flyway, and it does a lot of things I was doing in 2001 when DevOps wasn’t even a term and we were releasing every week.

    You can do the same thing, with some of the advanced things Flyway brings to the table that you don’t have to build and maintain.

    • script generation
    • code analysis rules
    • change and drift reports
    • a comprehensive view for impact assessment

    There’s more, but join us on Thursday by registering today

    Tell your friends as well, pass this along, and bring your questions.