A slow SQL Server can bring business operations to a crawl, causing frustration for users and costly downtime for organizations. Poor database...
database-tools
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- 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
Don’t Be Part of the 20%: The Risks of Running SQL Server 2012 or Other Unsupported Versions
Why SQL Server Version Matters SQL Server is the heart of many organizations’ data infrastructure, powering critical operations, analytics, and...
Climb Channel Solutions and Idera, Inc. Announce a Strategic Partnership to Deliver World-Class Microsoft SQL Server Tools to the IT Market
Discover the strategic partnership between Climb Channel Solutions and Idera, Inc., bringing industry-leading Microsoft SQL Server tools to IT professionals worldwide. Featuring SQL Diagnostic Manager,…
Empowering Law Firms: How SQL Server and Idera Tools Safeguard Legal Data
SQL Servers can play a crucial role in supporting the needs of the legal market, particularly for attorneys and law firms. The legal industry deals...
Best Practices for Writing SQL Server Scripts
When it comes to database management, SQL Server scripts are essential for automating repetitive tasks, querying data, and performing administrative...
Perpetual vs Subscription: SQL Server Tools Pricing Explained
When it comes to purchasing SQL Server tools, businesses often face a key decision: choosing between perpetual and subscription pricing....
Navigating SQL Server 2014 End of Life: What it Means for Your Data and How Idera Can Help
In July 2024, Microsoft SQL Server 2014 reached its end of life (EOL). This milestone marks the end of extended support from Microsoft, which has...
Understanding the Principle of Least Privilege in SQL Server Security
The principle of least privilege is a foundational concept in database security that advocates for granting users the minimum level of access...
How to Avoid SQL Server Deadlocks: 5 Essential Steps for DBAs
Understanding SQL Server Deadlocks In SQL Server management, deadlocks are a common yet frustrating issue that can disrupt database performance. A...
Backup SQL Server: Essential Tools and Strategies
Don’t Take Chances - Backup Your SQL Data! With an overwhelming amount of blog posts, news articles, LinkedIn horror stories, and water cooler chats...
Improving Your SQL Server Backup Recovery
Create a solid recovery plan. A critical part of your backup process needs to include recovery procedures. You should have a rehearsed recovery...
Prevent SQL Injection Attacks and Data Breaches
Don’t Be a Victim. Stay Ahead of These Top SQL Security and Compliance Threats You don’t have to be a DBA in the trenches to know that there have...
A User-Centric Tuning Philosophy
Collaborative Holistic Tuning of the Application Stack When planning for this blog, I deliberated over the title much more than anyone should ever...
SQL Diagnostic Manager 12.3 General Availability
SQL Diagnostic Manager 12.3 is available now. Upgrade or download the free trial version from Idera.com.
How to adjust the Java heap size of DB Optimizer
DB Optimizer is a Java-based application designed to assist database administrators and developers in optimizing the performance of database systems. If you are running long…
How to adjust the Java heap size of DB Change Manager
DB Change Manager is a Java-based application designed for managing and tracking changes to databases. If you compare 2 datasources with lots of objects, you…
Database Backup and Restores Drills in SQL Server
Creating backups and restoring them is crucial for maintaining the integrity and availability of data in Microsoft SQL Server. Here's a set of...
Announcing General Availability of DB PowerStudio (DBPS) version 18.5
We are pleased to announce the general availability of DB PowerStudio version 18.5! IDERA’s DB PowerStudio provides a powerful cross-platform...
Navigating SQL Server CPU and Memory Usage Woes
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft SQL Server is a powerful database management system, but...
Making the Most of Historical Data: Preventing Future SQL Server Issues
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Forecasting future SQL Server performance issues can often feel...
Key Insights into Ensuring SQL Server Security with These Practices
There are several examples where data theft has halted businesses or resulted in bad press that will leave a tarnished image. For instance, in 2017,...
Identifying AD Accounts without Proper Encryption Type
You may have accounts (inc. trust accounts) in AD that have a null value for msds-SupportedEncryptionTypes. They may have been working "by accident"...
SpeculationControl: Use PowerShell to Check for Risks
Checking Hardware Vulnerability to Spectre and Meltdown Microsoft released a module a couple of years ago (updated 3 weeks ago) that you can use to...
Creating ISO Files
PowerShell can turn regular folders into ISO files. ISO files are binary files that can be mounted and then behave like a read-only CD-ROM drive....
Automating Defender Antivirus (Part 2)
On Windows, PowerShell comes with cmdlets to automate the built-in antivirus engine “Defender”. In this second part, let’s take a look at how you...
Manage data and result sets, and SQL queries with Aqua Data Studio
Aqua Data Studio improves access and consistency by accessing data sources from a single tool to minimize the learning curve and maximize the...
Converting Wavelength to RGB
PowerShell is a generic script language so you can do all kinds of stuff with it. Below is a function that takes a light wavelength and converts it...
Querying Advanced Printer Info via SNMP
Many network printer support SNMP to query information about the device, i.e. its serial number, the status and paper sizes of installed trays, or...
Analyze blocking for SQL Server
Blocking is a normal activity that occurs in SQL Server and it does that to control data integrity and make sure only one resource can change a set...
Using Efficient Lists in PowerShell
By default, PowerShell uses simple “object arrays” when you define lists, when commands return more than one result, or when you otherwise need to...