Keeping an organization’s SQL Servers secure is the supporting DBAs’ most critical responsibility. The performance and availability of...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
SQLEJM Job Chaining
I created a job chain in SQLEJM with a root job one server and a second job on a different server with the job chain scheduled hourly. The root job...
The Rise of Cross-Platform Database Administration
Time and money are two things that are always in short supply. Let’s face facts. It’s a rare individual who turns down some extra cash...
Exploring WMI with PowerShell
The Win32_LogicalDevice WMI class represents all logic devices available in a computer, and by querying this “superclass”, you get back all the...
How to create custom counters with SQL Diagnostic Manager for SQL Server
Every environment is different. SQL Diagnostic Manager has pre-configured metrics that it monitors and collects...
DevOps Impact on Database Administration
The current trend for software development teams is to adopt a continuous delivery approach based on DevOps and agile development techniques. DevOps...
Adding New PowerShell Commands with Carbon
Carbon is one of the most popular free PowerShell modules available from the PowerShell Gallery. Similar to a swiss army knife, it comes with a...
A Comprehensive Tool for Developing High-Performance SQL Code
Writing SQL code is something that database professionals are called upon to do regularly. The practice comes into play when developing new...
Managing Updates with PSWindowsUpdate
There are many useful PowerShell modules available from the PowerShell Gallery. One helps you managing updates. To download and install it, run:...
Best Practices to Protect and Backup Your SQL Servers
One of the most important jobs a DBA has is keeping their databases safe and protected. While performance is a critical factor in database...
SQL Inventory Manager 2.6 Now Available
SQL Inventory Manager 2.6 Now Available We are pleased to announce the general availability of SQL Inventory Manager 2.6. Existing users may upgrade...
How to Optimize MySQL For High-Traffic Websites
Most websites that have any real utility are at least partially constructed with applications backed by databases. When you make a purchase on the...
Dynamic Argument Completion (Part 5)
In our previous tip we looked at sophisticated completion code that completed application paths. Collecting the completion values could take some...
How to run prescriptive analysis with SQL Diagnostic Manager for SQL Server
SQL Diagnostic Manager distinguishes itself from typical monitoring tools because it is more than just a symptom-based monitoring tool, since it can...
IDERA newsletter March 2020
The Latest News from IDERA Extended Cloud Support, Get Lucky with Savings, Upcoming Events, and more! IDERA Database Tools Expand Support for...
Dynamic Argument Completion (Part 4)
In the previous tip we explained how you can use [ArgumentCompleter] to add powerful argument completers for parameters. There are limitations...
Dynamic Argument Completion (Part 3)
With the discoveries in our past tips, let’s compose a useful completion code that suggests all available programs you can launch: function...
Using Aqua Data Studio for Reverse Engineering
The practice of reverse engineering has many applications in the world of information technology. It can be used to gain insight into the...
How to monitor MySQL performance with SQL Diagnostic Manager for MySQL
The monitoring of MySQL and MariaDB environments is much more straightforward with quality monitoring applications. The proper monitoring...
Dynamic Argument Completion (Part 2)
In our previous tip we looked at [ArgumentCompleter] and how this attribute can add clever code to parameters that provides auto-completion values...
Dynamic Argument Completion (Part 1)
In previous tips we explained various ways of adding argument completers to your parameters. One approach used the [ArgumentCompleter] attribute and...
Large Financial Organization Using ER/Studio to Manage Data – Case Study
This is one of our larger clients. They are a huge financial organization. They use ER/Studio to document and design data assets. As they say...
The Value of a Complete Server Inventory
Performing an inventory may not immediately spring to mind when considering the various tasks performed by an organization’s database team....
Focusing on the IT End-User Experience
Most computer systems and applications are designed to provide information to human users. There are certain interactions between applications or...
Listing Installed Applications (Part 2)
In the previous tip we read the registry to find out paths to applications you can launch. This approach worked well but had two flaws: first, the...
Listing Installed Applications (Part 1)
Ever wondered what the path is to launch a given application? The Windows registry has a key that stores such information: $key =...
A Way to Help Locate Hidden Cryptojacked Systems
In the world of information technology, there is a wide variety of software products and tools available for anyone to use. For the most part, these...
Strong Policies Result in Better Database Security
Keeping their databases secure is one of the things that can keep a DBA up at night. There might be pressure to improve performance to satisfy...
Secret Dynamic Argument Completer
In the previous tip we introduced the lesser-known “ArgumentCompletion” attribute that can provide IntelliSense-like autocompletion to parameters....
The Benefits of Data Visualization in Science
Data visualization is a powerful technique that is used extensively to enable complex information to be more readily understood. It is one of the...