We are pleased to announce the general availability of SQL Diagnostic Manager 12.2. Existing users may upgrade to this version through the Idera...
SQL Diagnostic Manager 12.2 General Availability
read more
database-tools
PowerShell Deprecations (Part 2: Remote PowerShell (RPS) in Exchange Online)
PowerShell cmdlets in Exchange Online use “Remote PowerShell” as a remoting technology which is a legacy technology with security risks in today’s...
Benefits of third-party tools for MySQL
Adding third-party tools can be an effective method of enhancing software, since they may provide additional features lacking in the original...
PowerShell Deprecations (Part 1: PowerShell 2.0)
Windows PowerShell 2.0 is still part of any Windows PowerShell for backwards compatibility, and when enabled, it is a serious security risk –...
Simplify your data analytics
Generating useful data analytics involves multiple time-consuming and tedious steps, including: Accessing usable data that can help business users...
Richer Printer Information
Get-Printer returns basic information about all local printers. When you add the switch parameter -Full, it returns even more detailed information...
How to Maintain Security Compliance to Prevent a Costly Data Breach
As businesses and government organizations shift a growing amount of their operations online, security has become an increasingly important issue....
Tune MySQL performance
MySQL is a popular relational database management system. It is the preferred platform for business critical eCommerce systems that companies rely...
Solving Problems with PowerShell (Part 4)
PowerShell offers you a plentitude of approaches to solve a task. They always boil down to the same strategies. In this mini-series, we will...
Solving Problems with PowerShell (Part 3)
PowerShell offers you a plentitude of approaches to solve a task. They always boil down to the same strategies. In this mini-series, we will...
Do you need a tool to manage your databases?
The growing amount of data that organizations must store and manage is increasing the challenges faced by all database professionals, including...
Solving Problems with PowerShell (Part 2)
PowerShell offers you a plentitude of approaches to solve a task. They always boil down to the same strategies. In this mini-series, we will...
Become a database administrator for MySQL
You are perhaps reading this because you think that becoming a database administrator may be the right career path for you. Database administrators...
Solving Problems with PowerShell (Part 1)
PowerShell offers you a plentitude of approaches to solve a task. They always boil down to the same strategies. In this mini-series, we will...
Super-Fast Network-Printer Inventory
In our previous tips we introduced all kinds of useful PowerShell functions to ping, scan ports, or contact SNMP devices. Today, it’s time to take a...
Super-Fast Network Scans (Part 3)
In our previous tips we created two fast functions to ping and port-scan remote systems: Test-Ping and Test-RemotePort: function Test-RemotePort {...
Super-Fast Network Scans (Part 2)
In our previous tip we looked at Test-NetConnection and found that it was way too slow, so we replaced it by a much faster Test-RemotePort function....
Improve data modeling with Aqua Data Studio
Data architects spend a major time of their job on data modeling. As such, they need to ensure that change to their data stores is controlled and...
Super-Fast Network Scans (Part 1)
Port scans can be useful to identify devices or machines in your network, i.e. file servers (port 445), PowerShell remoting targets (port 5985), or...
Creating IPv4 Network Range
Here is a PowerShell code snippet that creates a list of IPv4 addresses for a given segment. You just specify the start and end address: $From =...
Translating Data
Hash tables and dictionaries are perfect lookup tables: whenever your original data contains cryptic numbers or a command returns just numeric...
Best IDE for data analysts
Data analysts need good visibility to the right data to make good business decisions. They also require easy access to the appropriate data, and a...
Announcing General Availability of SQL Workload Analysis (SWA) 1.7.2
We’re excited to announce the release of SQL Workload Analysis (SWA) 1.7.2 Problematic SQL queries can severely reduce the performance of SQL Server...
Automating Defender Antivirus (Part 2)
On Windows, PowerShell comes with cmdlets to automate the built-in antivirus engine “Defender”. In this second part, let’s take a look at how you...