MySQL is an extremely popular relational database management system (RDBMS) that is used in many different sectors of business and industry. It is...
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
Top 7 Reasons for SQL Database Performance Issues and How to Overcome Them
Fine-tuning SQL code is not a one-off effort. It's a recurring task for database administrators (DBAs) as changing conditions can adversely...
Automation is Key to Effective Database DevOps
Modern application development using agile development and DevOps techniques is growing in acceptance across all types of IT environments. The...
Adding Argument Completion (Part 1)
Adding argument completion to your PowerShell function parameters can improve the usability of your functions tremendously. A common approach is...
Successfully Manage SQL Server Performance
Learn how to manage SQL Server performance from IDERA’s experts. Now more than ever, it is important to ensure that your SQL Server instances...
Increase the Value of Your Data with Dashboards
Tremendous volumes of information are generated and collected daily in corporate databases. These data resources are one of the organization’s...
Decoding Windows Product Key (Part 2)
In the previous tip we explained how you can ask WMI for a partial Windows product key. If you have lost your original product key, here is a way to...
Decoding Windows Product Key (Part 1)
There are a lot of script examples out there and even key recovery tools that promise to return the full product key, but in many cases, the...
What the Regulatory Auditors Want to See
The very mention of the words “regulatory audit” can send shivers down the spine of an organization’s IT management team. There...
Protecting Healthcare Computing Resources in the Pandemic
The COVID-19 pandemic has forced members of society to make many changes in their daily lives. Social distancing, working remotely and wearing masks...
Reading Operating System Details
PowerShell can easily retrieve important operating system details such as the build number and version by reading the appropriate registry values: #...
DevOps and Database Design and Change Management
Today's blog post continues my series of posts relating to DevOps and database administration... The DBA is the information technician...
Why You Want to Monitor Your Network
Many moving parts make up a modern IT environment. The average computing environment is a complicated construction comprised of servers,...
Prompting for Credentials in Console
When you run Get-Credential or are otherwise prompted for a username and password, Windows PowerShell (powershell.exe) always opens a separate...
Why You Need to Track Database Changes
Change is a constant that all IT professionals accept as part of the job. There are many different concrete manifestations of the abstract concept...
Searching PowerShell Gallery for New Modules
The official PowerShell Gallery is a public repository with thousands of free PowerShell modules. Instead of reinventing the wheel, it makes total...
Planning for a Successful Database Migration
There are many different database platforms that organizations can choose for collecting, storing, and analyzing their data resources. They range...
Keep Your SQL Servers Up and Running During the Pandemic
During this pandemic, many healthcare organizations are struggling with a shortage of medical supplies and staffing. They are also experiencing a...
Managing SharePoint Online
If you use SharePoint Online and would like to manage it via PowerShell, download and install the Microsoft.Online.SharePoint.PowerShell module from...
How to Keep Track of Your SQL Servers
The designers of modern SQL Server environments have many implementation models available to them. Based on the organization’s needs,...
Identifying Compromised Passwords (Part 2)
When you want to submit sensitive information to a PowerShell function, you typically use the SecureString type. This type makes sure a user gets...
Why You Should be Encrypting Database Backups
Data security is a hot topic in the IT industry for reasons that range from simply safeguarding information resources to maintaining compliance with...
Monitoring Oracle Containers and Pluggable Databases with Precise
Precise for Oracle allows you to monitor Oracle Container Databases and Pluggable Databases (also known as Oracle Mult Tenant Architecture). It...
Identifying Compromised Passwords (Part 1)
Passwords are no longer considered safe when they are complex. Instead, you need to ensure that passwords have not been compromised and are not part...
COVID-19 Disruption Navigation
IT Systems Under Pressure? We’re here to help during this uncertain time. View our free resources to help you navigate disruption caused by...
Create Software Inventories
The Windows registry stores the names and details of all software that you installed. PowerShell can read this information and provide you with a...
Handling the Challenges of MySQL Performance in the Pandemic
The COVID-19 pandemic has highlighted the reliance that the world puts on resources available through websites. Though some of the information...
Heightened Productivity for Your DBAs with Aqua Data Studio
The importance of data resources to modern businesses has resulted in database administrators assuming a more critical role in the corporate IT...
Keep PowerShell Modules Up-To-Date
It’s important to check every now and then that your PowerShell modules are up-to-date. If you are using old and outdated modules, you can run...
Using SQL Server Database Projects
Back in 2012, I had the pleasure and privilege of working with one of the sharpest developers I’ve ever met. He was a .NET lead of the...