In the world of SQL Server administration, many issues can negatively impact database performance. They range from inappropriately provisioned...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
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...
Killing Non-Responding Processes
Process objects returned by Get-Process can tell whether the process is currently responding to window messages and thus to user requests. This line...
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>...
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...