This post follows the previous one, “Macros – Add custom properties to specific objects”, where we shared scripts to automatically bind Attachments to ER Objects….
automation
Macros – Add custom properties to specific objects
Sometimes, you may need to specify custom properties for various objects such as Entities, Tables, Attributes, etc. The macros I’ll be sharing in this post,…
Geek Sync | Automating Database Administration Is No Longer Optional
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Automating Database Administration is no Longer Optional
Yes, the title of today’s blog post is somewhat provocative, but I think after reading what I have to say that you’ll agree with it. There are...
Announcing the Release of SQL Defrag Manager 3.6
We’re excited to announce the release of SQL Defrag Manager 3.6 SQL Defrag Manager is an industry leading automated performance solution that...
Don’t Fear the Robot Database Administrators
Nightmares about automation can conjure up images of shiny robots toiling away tirelessly without ever making an error or requiring a break. At...
What are the real benefits of database automation?
Many of the administrative tasks required to keep databases operating efficiently need to be performed regularly. While in some respects, these...
Advantages of Automating Database Performance Tuning
Database professionals are usually strapped for time. It’s part of the job in most cases. Multi-platform database environments are the norm in...
Automation is Key to Effective Database DevOps
Modern application development using agile development and DevOps techniques is growing in acceptance across all types of IT environments. The...
Unleashing the Power of the API for Automation
Database administrators and developers face increased workloads as businesses continue to expand the size and scope of data they collect and manage....
Benefits of Automating Your Routine Database Tasks
There is no getting around the fact that most of us have jobs which involve at least some degree of repetitive and routine tasks. It really doesn’t...
The Advantages of Automating Your MySQL Backups
Performing valid backups of their databases is one of the most important tasks for MySQL DBAs. A typical DBA spends the day maintaining databases...
The Most Powerful Reaction in IT
Lately, I’ve been seeing a particular video depicting simple yet amazing chemical reactions making its way through my social media feeds....
Achieve Better Automation with Idera’s SQL Diagnostic Manager
A seasoned SQL Server DBA has many skills, expertise and knowledge. Unfortunately, this also means that his/her time is always on demand by many...