Modern businesses are constantly searching for ways to remain more competitive by delivering valuable products and services to their customers....
database-tools
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...
Your MySQL Servers Are Being Targeted By Ransomware
There are many unscrupulous entities determined to compromise your systems with malware infections. In the early days of the IT industry, the goal...
Installing ActiveDirectory Module
Good news for any PowerShell users dealing with Active Directory: in recent Windows 10 builds (Enterprise, Professional), Microsoft included the...
Why You Need to Manage Your Database Changes
Change is a constant in the lives of database professionals. It can manifest itself in many forms. At one end of the spectrum, new systems may be...
Is Your Company Prepared for Cyberattacks?
It’s very easy for IT professionals to become insulated from world events as they strive to keep their company’s computer systems...
Testing for Pending Reboots
When Windows installed updates or made related changes to the operating system, changes may become effective only after a reboot. While a reboot is...
Launching PowerShell Scripts Invisibly
There is no a built-in way to launch a PowerShell script hidden: even if you run powershell.exe and specify -WindowStyle Hidden, the PowerShell...
FluidShell – A Primer – SQL Server Edition
Welcome to this first of three blog posts that would cover the basics of getting practical usage of Aqua Data Studio's FluidShell. Introduction:...
Helping Management See the Story Hidden in the Data
In most companies of any size, important strategic decisions are made by upper-echelon management figures. These individuals are entrusted with...