In recent versions of Oracle, their installer creates a new standard Windows user which is not part of the admin group. Previously, the user...
Precise for Oracle on Windows
read more
database-tools
Error upgrading SQLdm Dashboard
I am trying to upgrade the Idera Dashboard from version 4.4.0.18 to 4.6.0.9 but, when I run the installer it tells me the installation was...
IntelliSense for Parameters (Part 3)
Wouldn’t it be nice if parameters would suggest valid arguments for the user? Sometimes they do. When you type below command and press a SPACE after...
Improve DBA Productivity with a Unified Management Tool
Computing professionals often are called upon to work in very challenging conditions. The world of information technology is constantly evolving as...
IntelliSense for Parameters (Part 2)
Wouldn’t it be nice if parameters would suggest valid arguments for the user? Sometimes they do. When you type below command and press a SPACE after...
Informative Alerts Help You Avoid SQL Server Problems
Microsoft’s SQL Server is an extremely popular relational database management system (RDBMS) that is used by hundreds of thousands of...
How to monitor the performance of Galera Clusters
There are several ways to deploy and maintain a Galera Cluster for the MySQL environment. SQL Diagnostic Manager for MySQL can help with each...
IntelliSense for Parameters (Part 1)
Wouldn’t it be nice if parameters would suggest valid arguments for the user? Sometimes they do. When you type below command and press a SPACE after...
How to Increase Database Performance with Better SQL Queries
Modern businesses are constantly searching for ways to remain more competitive by delivering valuable products and services to their customers....
Separating IPv4 and IPv6
Let’s assume you want to return IP addresses from all network cards but separate them by address type. Here is an approach that uses solely...
How to tune query performance with execution plans
To execute queries, the database engine of SQL Server analyzes the statement to find the most efficient way to access the required data. The query...
The Benefits of a Unified Monitoring Platform
Modern IT environments are complex constructions that are composed of diverse systems and subsystems. They all work together to provide an...
Installing and Test-Driving Windows Terminal
Windows Terminal is a new multi-tabbed tool for console-based shells. It is officially available via the Microsoft Store and currently requires...
Who uses SQL Admin Toolset and what is their experience?
Are you curious about who the customers of SQL Admin Toolset are in terms of the organization, industry, and country? Are you curious about what the...
Improved SQL Server Health with SQL Doctor
Many things can go wrong with your SQL Servers that degrade their performance and reduce user productivity. Tracking down the issues that are...
Announcing the General Availability of SQL Compliance Manager 5.7
We’re excited to announce the release of SQL Compliance Manager 5.7. SQL Compliance Manager is a comprehensive database auditing solution...
Installing Free Chocolatey Package Management
Chocolatey is a package management system that helps you download and install software packages. Unlike the PowerShell Gallery, Chocolatey is not...
Focused Monitoring To Prevent Unexpected Database Problems
Database administrators are typically not amused by sudden changes to the performance of their databases. This is especially true when response time...
Grab Original PowerShell Language Specification
The PowerShell team has once published the rich and detailed PowerShell 3 language reference, and since the core language never changed, this...
Show Your #IDERALove on Twitter to win IDERA Swag!
Are you an IDERA superfan? Do you eagerly await news of the latest product updates and read every whitepaper and blog post? Is your collection of...
Structured vs. Unstructured Data
The rise of the Internet of Things (IoT), e-commerce, the consumer Internet, social media, and big data have made an enormous amount of data...
Downloading PowerShell Language Reference (or any file)
Invoke-WebRequest can easily download files for you. The code below downloads the PowerShell Language Reference published by PowerShell Magazine,...
What is Index Fragmentation and What Can You Do About It?
In the world of SQL Server administration, many issues can negatively impact database performance. They range from inappropriately provisioned...
Sharing Modules in Windows PowerShell and PowerShell Core
Many PowerShell users start to take a look at PowerShell 7, and run it side-by-side to the built-in Windows PowerShell. Both PowerShell versions...