I’m lucky, I’ve been working from home for a long time. What’s more, in a past life, I’ve been a DBA and designer. In this way, I truly get it. I see this circumstance very plainly. I know whether I were as yet a DBA or a designer, I’d be searching for approaches to team up, to keep steady over things, and to demonstrate that I’m as significant working from home as I am in the workplace. DBAs despite everything need to take care of issues with the databases they’re answerable for, other than doing typical upkeep and building new databases. Engineers need to compose great database code and ensure it runs precisely and performs all around ok to meet the application’s reaction time SLA.
These individuals are decided on measurements like speed and nature of their work. CloudIBN gives a wide range of approaches to remain viable at all of those things regardless of where “work” is found. Regardless of whether you have abruptly been tossed into a work-from-home situation due to COVID-19, or in the event that you’ve generally telecommuted, whether you intend to come back to the workplace after COVID-19 has settled or you need to keep on working from home, continue perusing. These arrangements will help.
Twelve ideas for boosting productivity and teamwork, and easing some worries, while working from home
While working from home, especially if it is not how you’re accustomed to spending your work days, you still need to juggle a lot of work tasks—not to mention life demands that you need to juggle at this time. You likely still have deadlines, teams to stay connected with and accomplish things with, and pieces of the IT puzzle that you’re uniquely responsible for fitting into place.
Following are 12 ways that CloudIBN solutions help database professionals be productive and effective team members while at home. If these products are new to you, follow the links for more information—best of all, we offer free trials.
Keep tabs on database performance. The Foglight web interface works from anywhere, to stay on top of database performance. No command line or unfamiliar scripts to learn, maintain, and execute while working alone. Let Foglight do the heavy lifting and show you what you need to see.
Diagnose database performance bottlenecks quickly. Have a work laptop at home? just as you do in the office for real-time diagnostics of performance issues.
Distractions and noise happen, but true problems need to surface. Foglight offers flexibility in easily setting up, and altering, email distribution of alarms. Make sure you (or whoever is appropriate) gets the message when something is going wrong.
You likely don’t do your coding in a vacuum. Share your database code with your teammates, DBAs, DevOps engineers, and others by taking advantage of tight and consistent source control integration offered by Toad® for Oracle and ApexSQL.
You likely don’t do your coding in a vacuum, Part 2. Share data, data visualizations, objects, scripts, and code with your colleagues quickly with CloudIBN for Oracle Team Coding and Intelligence Central.
Data analytics is still important, maybe in brand new ways. Prepare data for data analysts using the same Data Point interface on your laptop that you use in the office and place the data where remote colleagues can get to it.
Communicate concerns visually, clearly with application teams. Prove to application teams, no matter where they are working, using a Foglight Performance Investigator for Oracle or SQL Server report or screen capture, that they do indeed have “offensive database queries” that need to be tuned or rewritten.
War rooms erupt, still. Contribute important evidence/proof to an operations and/or business area “war room” discussion in the wake of an urgent database performance problem our outage using the Foglight extensive diagnostics and historical investigation capabilities—what are possible database causes and what evidence exists that it was NOT a database issue that caused the problem.
Managing new database types isn’t easy. Toad family products can help keep everyone productive in managing databases even if one isn’t an expert on some platform. SQL Server, DB2 or SAP, Toad Edge for MySQL or Postgres (and in beta, Redshift).
Ease worries about Oracle database migrations to the cloud. Automate for simplicity, consistency, and protection of production. With Toad DBA edition, you have the capability to automate tasks like schema compares and synchronizations, reports, or dozens of other tasks. Schedule those tasks and know that they’ll be performed when they should be, every time.
And now, Benchmark Factory can be used to automate load testing as part of a continuous integration build pipeline. Load testing can ensure that new or altered parts of an application are not affecting other areas of the application – the last thing your team needs with so many other things going on. How code will perform if many users execute it at once can be validated prior to production.
Don’t ease up on protecting data and proving compliance. Compliance with external regulations like GDPR, SOX, PCI, HIPAA, etc., is not eased even during a pandemic. ApexSQL Audit can help your SQL Server customers prove to the auditors that they have measures in place to achieve compliance (saving, potentially, large amounts of money in fines). Again, peace of mind is a valuable thing these days.