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.

Posted in Blog | Tagged , , | Comments Off on Manually Updating Redgate Monitor/SQL Monitor Patch Info

The Code Freeze

One of the ideas behind DevOps is that we minimize the time between code commit and deployment to production. We want to avoid work-in-progress and bottlenecks to getting our software into the hands of customers. This has led a lot of companies to release more often, albeit with smaller sets of features. The total number of things delivered under DevOps might not be greater, but it often is more targeted to those things our customers want/need/use.

However, the idea of releasing often means that we try not to stack up too much work before deploying it. What does that mean for holidays and the code freezes or no-deploy periods that many companies have? How do you implement a code freeze under DevOps?

I read an interesting series on code freezes (partially paid content: part 1, part 2, part 3), and it looks at some of the implementations, data from surveys, and pros/cons of implementing a code freeze.

Two things here. First, I like code freezes as it gives staff a break. Two, doing this in a way that doesn’t just shift work (and stress) is hard. Do you have code freezes or deployment restrictions at your company? Do you like them?

The post has lots of metrics from various companies, some known, some anonymous. It seems that for those companies using code freezes, they help employees take a break, but not everyone takes a break, which means some work is done and merges after the code freeze are problematic. For those who don’t mandate a code freeze, less work is done when people are gone, but some work continues and is released.

I think the natural flow of work is that when fewer people are available, less work gets done. Poor management (or a hero complex) might overload the staff still working, but that doesn’t work long term. It might work now, given there is an oversupply of tech people and fewer jobs, but when things change, people will leave those positions, and lower quality, or at least less knowledgeable people, will cause problems for those firms.

I’m not a fan of code freezes, but I am a fan of understanding that staff needs a break. Lots of people want to take time off during holidays, especially those with children who want to celebrate or travel. Others might be fine working and want to catch up on work, refactor things, or maybe address tech debt. I’ve been in both situations, and I hope organizations can adapt to both situations, though without sacrificing quality. We still need good code review and testing, and if there isn’t the staff to do those things, then delay merging code.

The one thing that stood out to me was the learning that changing the pace is good for humans. If you’re in the habit of releasing every week (or day or whatever), moving to a different cadence for some time is good for you. Just as high-pressure work can’t be sustained for a long time, very slow periods aren’t good. However, both have their places as a change of pace. A high-pressure situation might be necessary to meet a business goal (or solve a problem). A low-pressure time might be a good time to think, experiment, and perhaps innovate.

Or just fix and refactor some poorly designed technical debt.

Do you want a time when you aren’t trying to get code to production, either as a dev or operations person? Or do you like to have your job predictable and work in the same pattern year-round? Let me know today.

Steve Jones

Listen to the podcast at Libsyn, Spotify, or iTunes.

Posted in Editorial | Tagged | Comments Off on The Code Freeze

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.

Posted in Blog | Tagged , , , , | 4 Comments

T-SQL Tuesday #173–The AI Job Helper

tsqltuesdayThis month I had a new host, Pinal Dave. I was surprised to see he hadn’t hosted, but I didn’t see him in the list. His invite is interesting, as AI has been on his mind. I pinged him after listening to him on a webinar, and his invite reflects the topic: Has AI Helped with Your SQL Server Job?

It seems that our topics stray a bit further from core SQL topics as the world becomes more complex, and honestly, as more and more of us do things beyond just managing a server.

In any case, that’s the topic, and if you want to host, ping me.

AI Assistance

Has AI helped me? I don’t do a lot of SQL Server work, but I continue to learn about the platform and I do find myself writing code or helping customers find ways to build database software. I also started a short series on AI stuff as I experiment with tools and techniques.

In general, I don’t find Copilot or ChatGPT (or other tools) that helpful with SQL Server. I think I haven’t spent enough time, but honestly, I struggle to create prompts and work with things. However, I know there is something. If you watch Pinal’s webinar, AI isn’t perfect, but it’s like a coworker making some suggestions of things you might not have thought of.

Where I have found it useful is doing a question of an AI, often in Bing/Edge chat, and using that as a first search engine for what I want to look for rather than getting a list of results and clicking through them. In that sense, it’s saved some time.

However, I know I still need to evaluate what comes back and make an informed decision if the suggestion or code will actually work.

And of course, I need to test it.

Posted in Blog | Tagged , , | 1 Comment