Database Maintenance / Best Practices Archives

19 Jul ProTop Newsletter July 2021

Posted at 08:00h in Business Continuity, Database Maintenance / Best Practices, Hints and tips, OpenEdge by Paul Koufalis

[vc_row css_animation="" row_type="row" use_row_as_full_screen_section="no" type="full_width" angled_section="no" text_align="left" background_image_as_pattern="without_pattern"][vc_column][vc_column_text] Welcome to our monthly ProTop newsletter, where you'll find out what's new, tips and tricks and other cool ways to use both the free and commercial versions of ProTop. In this month's issue we want to dive into the...

22 Jun ProTop Newsletter June 2021

Posted at 07:30h in Business Continuity, Database Maintenance / Best Practices, Hints and tips, OpenEdge by Paul Koufalis

10 May New DBA Series: No More AIxcuses – Part Two

Posted at 08:00h in Business Continuity, Database Maintenance / Best Practices by Mark Bonneville

If you follow the guidelines suggested here, you can expect more hours of uninterrupted sleep at the very least, and at best? You will experience minimal disruption to your system should your OpenEdge databases be damaged for reasons beyond your control. In Part 1, we covered the...

26 Apr New DBA Series: Frequently Useful Numbers

Posted at 02:46h in Database Maintenance / Best Practices, Hints and tips, New DBA, OpenEdge, Performance Tuning by Paul Koufalis

"One Size Fits ALL" may be acceptable when talking about thong sandals or knit caps (it's not entirely true even then). However, it is an obvious mistake when talking about bicycles, swimwear, and all manner of measures used in administering OpenEdge databases. That said, below...

29 Mar Corruption and Crash Protection, Courtesy of After-Imaging

Posted at 00:24h in Business Continuity, Crash, Database Maintenance / Best Practices, High Availability, OpenEdge by Paul Koufalis

No one wants to think about a database crash, and even less about losing data, and yet every month or two I get a call from an IT Director in exactly that situation. Their OpenEdge system has been down for hours and stays down for...

22 Mar Video Series: Boring Everyday Stuff That You Need to Know

Posted at 13:32h in Database Maintenance / Best Practices, Hints and tips, New DBA, OpenEdge, Performances, Video Blog by Paul Koufalis

When you first get started supporting an OpenEdge system, there are some things that you really ought to know about your environment. That way, when there's a problem somewhere down the road, even though "nothing changed", you'll have the information you need to show that...

04 Mar Video Series: Baseline Database Configuration

Posted at 20:56h in Database Maintenance / Best Practices, Hints and tips, OpenEdge, Performances, Video Blog by Paul Koufalis

01 Mar New DBA Series: No More AIxcuses – Part One

Posted at 08:00h in Business Continuity, Database Maintenance / Best Practices, High Availability, New DBA by Paul Koufalis

Unless it's a read-only database, no OpenEdge production database should run without after-imaging. Period. After-Imaging (AI) is an OpenEdge continuous change logging system that stores database changes in specially formatted log files. It allows the DBA to restore a database from a backup then apply all...

02 Feb New DBA Series : OpenEdge Database Backups

Posted at 08:00h in Business Continuity, Database Maintenance / Best Practices, High Availability, New DBA, OpenEdge by Paul Koufalis

What's the best tool to backup the database? Do I have to shut it down? What does Progress recommend? What do experienced DBAs use? Should I hang it up, hire a resume writer? Relax, the right answer came with the OpenEdge installation. Take a look: What...

11 Jan Why is External Shared Storage a Bad Idea for Your Database?

Posted at 18:32h in Database Maintenance / Best Practices, Hardware Considerations, Hints and tips, Linux, Performance Tuning by Tom Bascom

If you are concerned about performance, the fundamental problem with SAN storage is that it is external and shared....

Database Maintenance / Best Practices