Announcing the General Availability of IDERA SQL Safe Backup 9.3
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 to Control the Complexity of Enterprise SQL Server Jobs
Automation is one of the key techniques by which SQL Server DBAs attempt to tame their environment. Without the ability to automate at least some of their tasks, there would need to be many more members of database teams in all but the smallest SQL Server environment....
How to analyze the health of SQL Server database indexes
To keep databases running smoothly, it is important to evaluate the properties and performance statistics of indexes of databases. For this purpose, display these statistics of indexes: The percentage of rows modified since statistics were last updated. The percentage...
Announcing General Availability of SQL Admin ToolSet 1.9.5
We are pleased to announce the general availability of SQL Admin Toolset 1.9.5. Existing users may upgrade to this version through the IDERA Customer Portal. New users may download the trial version from the IDERA website. This release includes a number of fixes for...
How to Improve Your MySQL Database Performance
Tips for Improving Your MySQL Database Performance
MySQL is used by many businesses as the database backend for online stores and e-commerce sites. When deployed in this way, the performance of the database can become a critical factor in the success or failure of the enterprise. Customers don’t want to wait around...
How to ensure that SQL Server databases are backed up on a regular basis
Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases. Determine which databases are not backed up within the last specified number of days. Display the last backup time stamp for...
Improving Query Performance in Your Azure SQL Databases
Recent years have seen many organizations migrate part or all of their SQL Server environments to public cloud providers. Moving databases to the cloud addresses financial, capacity, and resource issues that may have been difficult to resolve with an on-premises...
Cloud Day 2—Understanding Your Options in Platform as a Service Databases
If you have spent any time reading marketing material from cloud vendors, you will know that there is a big push to move your workloads to platform as a service offerings in the public cloud. There are a number of reasons for this—the biggest, from the cloud...
Geek Sync | How to Select the Appropriate Approach to Data Governance
There are three distinct approaches organizations can follow to implement Data Governance. There is the command-and-control approach, the traditional approach and the non-invasive approach to putting a formal program in place. The benefits and the issues that result...
How to migrate SQL Server databases and data files
Do you need to: Move databases from one instance to another (for example, to move a performance-intensive database to a faster hard drive to speed up performance). Copy databases from one instance to another or on the same instance. Migrate databases while preserving...
Do You Know the Real Costs of Regulatory Noncompliance?
Compliance or noncompliance, that is the question. Is it an economically sound strategy to spend the necessary resources to remain compliant with regulations that affect your business or market sector? Or is it better to roll the dice and hope that your company will...
The Challenge of Variable Seasonal Database Usage
If the past year has taught us anything, it is that we can never know what’s coming next. Just to survive, we may need to reevaluate our actions and be flexible enough to adapt to a rapidly changing situation. Database administrators can suddenly be tasked with...
How to ensure that SQL Server databases do not have fragmented indexes
Maintain the performance of databases by efficiently retrieving ordered data by resolving the fragmentation of the indexes. View the fragmentation level of indexes. Filter the results by server, database, and table. Sort indexes based on the fragmentation level, size,...
Oracle 19.8 Patch for AIX is now supported by Precise 10.2
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the “SmbShare” noun which represents local folders that you share on a network. Today we’re looking at the “SbmMapping”...
Protect Your SQL Servers with Always Encrypted
The information stored in corporate databases needs to be protected in multiple ways. Database backups are necessary to recover from a physical or logical disaster requiring systems to be rebuilt. Firewalls and other network security measures need to be taken to keep...
How to monitor the health of SQL Server database instances
Determine the health of instances by collecting real-time statistics. Such statistics include backup devices, databases, error logs, locks, logins, performance counters, processes, and agent errors. With the Server Statistics tool of SQL Admin Toolset, display a...
Geek Sync | Practical PowerShell For The Busy DBA
Many DBAs don't have time to learn PowerShell. Thankfully, there is an excellent PowerShell library already created specifically for handling many of the tasks that SQL Server DBAs regularly perform, and you will be surprised at just how easy it is to use! How...
Cloud Day 2—What Do You Need to Know About Cloud Security?
Cloud security is complex and has several layers to it—first and most important is access to the control plane. The control plane is your cloud vendors internet portal, APIs, and various command lines that allow authenticated users to deploy, manage, and delete...
You Need to Plan a Strategy for SQL Server Backups
Backups are an indispensable component of all computing environments. Creating data backups regularly is considered best practice for everyone from home users who just browse the web and play games to DBAs responsible for mission-critical financial databases. As a...
How can you tune the performance of SQL Server by analyzing the past to predict the future?
The history of mankind says that we have learned a lot from our past mistakes and improved our future. Similarly, SQL Server performance tuning is not as complex a subject as many think it is and we can learn a lot from the earlier behavior of SQL Server. If we...