Organizations can enjoy many benefits by choosing to migrate some or all of their computing resources to the cloud. There are often financial...
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
How are you tuning SQL Server in the hybrid cloud?
As organizations migrate their databases to the cloud, database administrators need to manage databases on-premise and in the cloud with existing...
Repairing PowerShell Gallery Access
The PowerShell Gallery (www.powershellgallery.com) is a perfect place to look for new PowerShell commands. With Install-Module, you can easily...
Keeping an Eye on All of Your SQL Servers
The majority of organizations that use SQL Server as one of their database solutions have more than one instance in their environment. In some...
How did a medium enterprise healthcare company in the USA proactively troubleshoot SQL Server issues?
Methodist Hospitals of Dallas, Inc. is a medium enterprise healthcare company in Dallas, Texas, USA. They have 10 to 24 SQL Server databases in...
Geek Sync | Improving Query Performance in Azure SQL Database
Moving to Azure SQL can help with many things, including faster scalability and easier disaster recovery strategy implementation. Unfortunately, one...
Creating Icons
In the previous tip we showed how you can fine-tune „Windows Terminal“ and add new entries to the list of launchable applications. If...
Keeping Users Happy with High-Performance Databases
Without users, databases are rather abstract constructs that, it can be argued, have no real purpose. It is certainly an interesting technical...
How can you improve the performance, disaster recovery, and security of SQL Server?
SQL Doctor tunes SQL Server performance, security, and disaster recovery via expert recommendations in physical, virtual, and cloud environments -...
Fine-Tuning Windows Terminal
In the previous tips we explained how you can install „Windows Terminal“ on Windows 10 via the Microsoft Store. Windows Terminal...
Prepare for the Worst, Hope for the Best
If you have spent any time in the IT world, you probably know that things do not always go according to plan. In fact, at times it seems that...
Cloud Day 2–Understanding Cloud Storage
Welcome to the Cloud Day 2—in this series you will learn about some slightly more advanced topics in the public cloud. We’re going to go...
How did an IT consulting firm save time and money on performance fine tuning for SQL Server?
When companies are looking for a SQL Expert to help with performance challenges, they turn to Oregon-based consulting firm Lake IT for experienced...
Don’t Fear the Robot Database Administrators
Nightmares about automation can conjure up images of shiny robots toiling away tirelessly without ever making an error or requiring a break. At...
How did a healthcare company in South Africa fix a slow and erratic SQL Server?
An IT company that deals with the healthcare industry in South Africa develop a variety of software products, which cover a wide range of...
Turn Windows Terminal into a Portable App
On Windows 10, there is a new and awesome tool available for any PowerShell user: Windows Terminal. It lets you use multiple PowerShell and other...
Why You Should Consolidate Your SQL Server Environment
Microsoft’s SQL Server is one of the most widely-used relational database solutions on the planet. Due to its popularity, there are numerous...
What do IDERA’s customers have to say about SQL Doctor?
Are you curious about who the customers of SQL Doctor are in terms of the organization, industry, and country? What is the size and the deployment...
Launching Windows Terminal for Any User
On Windows 10, there is a new and awesome tool available for any PowerShell user: Windows Terminal. It lets you use multiple PowerShell and other...
How are you tuning the performance of SQL Server, Azure SQL Database, and Amazon RDS for SQL Server?
SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance...
Permanently Deleting AD Objects
Many Active Directory objects are protected from deletion. When you try to delete them, you get an error, preventing you from accidentally removing...
How to Handle Unexpected Issues During Cloud Migration
A common issue that affects many areas of the IT world is that things often do not go as smoothly as anticipated. Despite the best efforts that...
Deploy PowerShell as Clickable Icons (Part 2)
In the previous tip we illustrated how you can embed up to 4096 characters of PowerShell code inside a Windows Explorer shortcut file and produce...
Are You Willing to Pay the Price of Non-Compliance?
Data privacy is a hot topic in the world of information technology and promises to remain so for the foreseeable future. As the shift continues to a...
Installing Precise in an AWS or Azure environment
Precise provides support for AWS and Azure. We have provided support for AWS and Azure since Precise 9.9. (June 2018) The Precise framework...
Announcing the General Availability of SQL Secure 3.4
We are pleased to announce the general availability of SQL Secure 3.4. Customers can access the new version via the IDERA Customer Portal. New...
Deploy PowerShell as Clickable Icons (Part 1)
You can use .lnk files to deploy small PowerShell solutions to end users. Here’s how: Take below code, and replace the payload code inside...
The Problem of Data Breaches Shows No Signs of Slowing Down
An unfortunate and common problem that is encountered just about everywhere in the world is the theft of valuable items from their owners by...
Welcome to the SQL Server Query Store
The current situation we all face with the COVID-19 pandemic has made it difficult or impossible for many individuals to visit their favorite local...
Test-Driving New SSH Remoting
If you’d like to test-drive the new PowerShell remoting alternative that is using SSH instead of WinRM, make sure you install PowerShell 7...