MySQL is the database platform behind many popular websites and applications such as Netflix, YouTube, Facebook, and Twitter. As one of the most...
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
Identifying Windows Type
You Need to Read the Fine Print on Your Software Licenses
Computer technology touches virtually every aspect of our daily lives. We come in contact with computerized systems with such regularity that many...
Boot and Install Time for Operating System
The WMI class Win32_OperatingSystem provides rich information about a number of datetime information, including the date of last boot-up and the...
What Makes a Dashboard Useful to its Audience?
Dashboards offer effective visualization vehicles for providing information gleaned from an organization’s data resources in a concise format....
The Best Way to Reduce Your DBAs’ Learning Curve
When an individual chooses a career as a database administrator they are committing themselves to a lifetime of learning. Keeping abreast of new...
Changing Operating System Description
Each Windows operating system has a description, and you can view (and change) this description with the following command: PS> control sysdm.cpl...
How to Choose the Right Database for Your Application
Developing a new application means there are many decisions an organization needs to make. One of the most important choices that the development...
Showing Object Data as Table in a Grid View Window
Typically, when you output a single object to Out-GridView, you get one line, and every property surfaces as a column: Get-ComputerInfo |...
Removing Empty Properties
WMI and Get-CimInstance can provide you with a lot of useful information but the returned objects often contain a number of empty properties: PS>...
A Simple Way to Make Your SQL Server DBAs More Efficient
The role of an SQL Server database administrator brings with it a wide range of responsibilities. On any given day a DBA may have to address...
Using Assertions
Often, your code needs to assert certain prerequisites. For example, you may want to ensure that a given folder exists, and use code like this: #...
The Best Practices for Implementing Effective Monitoring
Monitoring is an important activity that is performed in many diverse situations. From healthcare workers to stockbrokers, monitoring the systems on...
Data Visualization – Quick and Easy
Visually analyze data with Aqua Data Studio and bring your data to life! Create engaging data visualizations and dashboards to explore and share....
Wake On LAN
There is no need for external “Wake On LAN” tools. If you want to wake up a network machine, simply tell PowerShell the MAC address of...
How to Keep Critical Systems Running During the Pandemic
The word critical has taken on increased importance in multiple disciplines since the world was subjected to the novel coronavirus. Items and...
Converting Hex Numbers
PowerShell can interactively convert hexadecimal numbers when you prefix “0x”: PS> 0xAB0f 43791 If the hex number is stored in a...
Auto-Learning Argument Completion
Argument completion is awesome for a user because valid arguments are always suggested. Many built-in PowerShell commands come with argument...
Plagued by IT Downtime?
Cut IT Downtime By Using Server Monitoring Tools. In today’s world, we need to keep our organizations up and running 24/7 with limited...
Monitoring is the Key to Improving Database Performance
Performance is a term that gets thrown around in many different contexts. It’s a much sought-after commodity in endeavors as diverse as sports,...
Adding Argument Completion (Part 2)
In the previous tip we talked about the new [ArgumentCompletions()] attribute that was added to PowerShell 7, and how you can use it to add...
The Use of MySQL in the Scientific Community
MySQL is an extremely popular relational database management system (RDBMS) that is used in many different sectors of business and industry. It is...
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...