Process objects returned by Get-Process can tell whether the process is currently responding to window messages and thus to user requests. This line...
database-tools
The Compromise Between Database Performance and Security
The performance of a database has often been considered its most critical aspect. Satisfying the demands of users is one of the primary concerns of...
Testing Network Connections (Part 2)
If you’d like to test whether a specific computer or URL is online, for decades ping requests (ICMP) have been used. In recent times, many servers...
Testing Network Connections (Part 1)
PowerShell comes with Test-NetConnection which works like a sophisticated ping tool. In its default, you can ping computers: PS>...
Aqua Data Studio 20.5 General Availability
Idera is excited to announce Version 20.5 of Aqua Data with major Enhancements in the following areas. Platform support now includes Amazon RDS...
Exploring Plug&Play Devices (Part 4)
In the previous tips we investigated the UPnP.UPnPDeviceFinder and how to identify devices in your network. Let’s look at some use cases. Obviously,...
The Best Way to Manage Queries on Multiple Platforms
Modern database teams need to navigate increasingly complex computing environments that often include working with more than one platform...
Exploring Plug&Play Devices (Part 3)
In the previous tip we illustrated how to use the UPnP.UPnPDeviceFinder to find devices on your network. You already learned how to enumerate all...
Tips That Will Tighten Up Your SQL Server Security
Security is an important topic that may not always get the attention it deserves from your organization’s database developers. While the...
Exploring Plug&Play Devices (Part 2)
In the previous tip, we used the UPnP.UPnPDeviceFinder to discover smart devices hooked up to your network. Today, let’s take a closer look at...
Exploring Plug&Play Devices (Part 1)
You are probably living already in a connected smart home with many devices hooked up to your network. PowerShell can help you find your devices...
How to use temporal data to improve SQL code
SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what...
Listing Installed Updates (Part 2)
In the previous tip we looked at how to retrieve the list of currently installed updates from the Windows Update Client. This list can be polished,...
Listing Installed Updates (Part 1)
Get-Hotfix only lists operating-system-related hotfixes: Get-HotFix In reality, it is just a thin wrapper around a WMI query which produces...
Announcing the GA Release of SQL Safe Backup 8.6
We are pleased to announce the general availability of SQL Safe Backup 8.6. IDERA SQL Safe Backup provides a mission-critical backup and recovery...
Why You Need To Perform Database Benchmarking Correctly
Benchmarking is the process of discovering how the best performance can be obtained against previously defined benchmarks. It is a tool used in many...
Aborting the PowerShell Pipeline (Part 2: Manual Abort)
In the previous tip you learned how to abort the PowerShell pipeline once the required number of results is in, potentially saving a lot of time:...
Fundamentals of DevOps as it Relates to Your Database Team
DevOps can be seen as a step in the continued evolution of the software development process. The term can be defined as the union of people,...
What are the rules for table design heuristics for relational models?
The dictionary definition of a 'heuristic' is ‘Computers, Mathematics: pertaining to a trial-and-error method of problem-solving used...
MySQL Monitoring Best Practices Make You a Better DBA
MySQL database administrators have a tough job. They are expected to maintain the availability and performance of the systems for which they are...
Aborting the PowerShell Pipeline (Part 1: Select-Object)
Sometimes it can save a lot of time to manually abort a PowerShell pipeline. For example, if you don’t know exactly where a file is located...
DBArtisan Tips and Tricks Webinar November 2019
The November edition of DBArtisan tips and techniques Webinar covered three tips for using DBArtisan. Using Projects to organize your work...
An Improved GUI Results in Better SQL Server Tuning
Database transactions are at the heart of many mission-critical applications throughout the business world. Monitoring these transactions to tune...
Why Compressing Database Backups Makes Good Sense
Admittedly, it would be nice if all members of the IT team had the same goals when performing their jobs. While the overriding concern of all...