A constant in the computing world is that it is always evolving and offering new challenges and opportunities. Software solutions come and go with...
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
Finding Public IP Address
Here is a one-liner that retrieves your current public IP address: PS> Invoke-RestMethod -Uri http://ipinfo.io ip : 87.153.224.209 hostname :...
How to properly set up SQL Server clusters
Windows Failover Clustering can keep your SQL Server databases online and your end users happy when hardware or operating system problems strike....
Problems That Influence Efficient Enterprise IT Management
Managing Enterprise IT environments can be an overwhelming undertaking. The complexity that has been introduced by virtualization and the cloud make...
Real-Time Log Processing
PowerShell comes with a powerful yet simple way of monitoring file changes. Let’s assume you have a log file that changes every now and then....
Protect Your Databases From Password Attacks
Cybersecurity is a major concern for organizations and businesses in all sectors of society. The predominance of digitally stored information...
A One-Stop Solution to SQL Coding Problems
A One-Stop Solution to SQL Coding Problems One of the challenges a DBA must deal with on a daily basis is negotiating the multiple database...
Why Would You Want to Reverse Engineer a Database?
Hearing the term reverse engineering can conjure up many different images in the mind of the listener. It has rather murky connotations due to some...
Effectively Conquer Ransomware Attacks With Database Backups
Hackers have been around since there were computer systems available to attack. Some of these individuals engage in the practice purely for...
Detecting Storage Issues
In Windows 10 and Windows Server 2016, PowerShell can access storage reliability data so you can find out whether there is something wrong with one...
MySQL Security Basics
Full security requires security of the network, hosts, databases, and applications. Most of these are the same, regardless of which database vendor...
Manage SLAs Effectively and Save Your Company Money
IT providers need to have a clear understanding of how their customers expect a particular service or system component to be delivered. There are a...
What are the MySQL Metrics That Really Make a Difference?
MySQL is one of the most popular relational database platforms in the world. As such, it is used as the backend of many mission-critical...
Resetting Winsock
PowerShell can execute internal PowerShell commands and also regular console commands, so it’s not a bad thing to continue to use console...
Elevated Privileges Can Cripple Your Business
A week rarely goes by without reports of a business or organization being afflicted by a data breach. It has almost become commonplace to read about...
What are MySQL Database Engines?
If you’re new to MySQL, you’ve probably run into a term you haven’t seen before: Database engines. Database engines (also called...
Using Awesome Export-Excel Cmdlet (Part 5)
This is part 5 of our mini-series about the awesome and free “ImportExcel” PowerShell module by Doug Finke. Make sure you install the...
How to Provide Compliance Evidence to Auditors
There’s no getting around it. The only way to satisfy the demands of auditors and demonstrate your organization’s compliance with the...
Using MySQL SHOW Commands for Performance Monitoring
MySQL SHOW Commands Different database vendors provide different ways of querying the engine to determine status, sessions, configuration, and other...
Generate Increased Stakeholder Confidence with Visual Data
The massive amounts of data that are generated by an organization’s databases and computing systems offer a wealth of information to be used...
The Benefits of Complete Root Cause Analysis
In the IT world, it’s a given that problems will be encountered with the systems or procedures which power an organization. The infrastructures and...
Using Awesome Export-Excel Cmdlet (Part 4)
This is part 4 of our mini-series about the awesome and free “ImportExcel” PowerShell module by Doug Finke. Make sure you install the...
Avoid These Critical DBA Mistakes and Save Your Job!
IT professionals operate in a complex and constantly evolving work environment that demands a high degree of precision and attention to detail....
Using Awesome Export-Excel Cmdlet (Part 3)
This is part 3 of our mini-series about the awesome and free “ImportExcel” PowerShell module by Doug Finke. Make sure you install the...
A Unified Dashboard Results in Increased Monitoring Efficiency
Modern IT environments are built on notoriously complex infrastructures made up of multiple components and interconnected systems. Organizations are...
September #SQLChat – Big Data and the DBA
With Big Data only getting bigger, what new technologies and tools should both junior and seasoned DBAs learn to stay relevant? Join IDERA...
Minimize SQL Complexity and Get Out of Work on Time
The majority of IT professionals who have spent any amount of time around databases are familiar with structured query language, perhaps better...
Using Awesome Export-Excel Cmdlet (Part 2)
This is part 2 of our mini-series about the awesome and free “ImportExcel” PowerShell module by Doug Finke. Make sure you install the...
Announcing the General Availability of DB PowerStudio 17.0.4
We are excited to announce the release of DB PowerStudio version 17.0.4 with improvements in the following areas. New Platform Support We have...
How to Make Your Database Administrators More Efficient
The role of a corporate database administrator has evolved tremendously since the introduction of relational databases in the late 1970s. A DBA from...