Here are three commands often found in PowerShell scripts that you should be careful about because they can have severe side effects: exit“exit” is...
Be Careful with Some Commands
read more
database-tools
Dealing with Out-GridView Bug
Out-GridView can serve as a universal selection dialog when you add the -PassThru parameter. The one-liner below stops all services you select in...
Keep Your SQL Servers Secure with These Best Practices
Keeping an organization’s SQL Servers secure is the supporting DBAs’ most critical responsibility. The performance and availability of...
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...