Initialization of a transactional replication subscriber is a highly valuable tool. For very large databases (VLDBs), snapshot generation and...
SQL Server
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
Understanding database backup strategies
As seasoned database administrators, you should be well on top of your backup strategies. These strategies are not written in stone. It is a journey...
How to Start SQL Server Performance Tuning
Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to...
Five reasons your SQL Server is slow
Everybody would love to find the mythical “go faster” switch in SQL Server. Unfortunately, this switch does not exist. There are, however, many...
GDPR and the SQL Security Suite
On May 25th, 2018, GDPR (General Data Protection Regulation) went into effect. This regulation affects anyone who collects PII (Personally...
Announcing ER/Studio 17.1 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.1 ER/Studio 17.1 contains improvements and enhancements in a number...
August #SQLChat – SQL Server Coding Standards
Designing and managing databases can be a daunting tasks. However, defining database coding standards can help keep everything in order. Join IDERA...
Updated Free Tool: PowerShell Scripts for SQL Server 6.0: Added Scripts for Microsoft Azure SQL Database
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 15 new scripts for Microsoft Azure SQL...
Database Performance History
Servers are moving from on-prem to the cloud. Applications are upgraded, so are operating systems, databases, and hardware. New users,...
Changing Lanes: Part II. Shifting between Relational and Big Data Platforms
In the last blog, I covered Shifting Roles with Relational and Big Data Platforms and how that is affecting the people and their roles within...
How To Improve a Business-critical Third-party Application by Optimizing Its Generic Database Settings
Problem Background A business-critical third-party application for Microsoft SQL Server configured the database with generic settings, including...
IDERA Database Tools roadmap for DBAs, database developers and data architects
At IDERA, users drive our product direction. That’s why we have been listening to your needs and have built a roadmap centered around you. In...
Database Execution Plans Can Lie
Quote: Do not put your faith in what statistics say until you have carefully considered what they do not say. ~William W. Watt. I started this...
The Evolution of Database Tuning Approaches
Imagine that you’re the lead DBA managing a high profile, mission critical production database whose application processes $20 million per...
Managing Mountains of Data with the Cloud
When is data less valuable? How do you manage data as it becomes less valuable? In the good old days the answer to these questions was easy; it was...
Database Needs in The Cloud – May #SQLChat
Movement to the cloud is in full swing! Regardless of the cloud provider, you will need a migration strategy and the knowledge to make choices...
Setting up ER/Studio in the Google Cloud Platform – Part I – Setup
Hi All, In this blog post we will be going through on how to setting up IDERA's ER/Studio Repository Database Setup in The Google Cloud. In Part...
Free Virtual Conference! IDERA Live 2018
It’s that time of year again! We invite you to join us for IDERA Live, our second-annual Virtual Conference, designed to educate and inform...
Dealing with Database Security
Nearly every month there is another announcement about a company disclosing a data breach in which sensitive customer data was exposed. Last week,...
What’s the most important thing SQL Server DBAs want to learn in 2018?
Our product management team at IDERA recently polled a sample of our customer base and asked them to tell us what is the most important technology...
Five Important Features of SQL Diagnostic Manager
SQL Diagnostic Manager is a robust performance monitoring, alerting and diagnostics solution for SQL Server. It proactively notifies of health,...
Updated Free Tool: PowerShell Scripts for SQL Server 5.0: Added Center for Internet Security (CIS) Benchmarks
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 30 new scripts for Center for Internet Security...
IDERA Helps You Face the Challenges of Implementing GDPR
As many companies are coming to realize, the General Data Protection Regulation (GDPR) issued by the EU, which takes effect in May 2018, has a lot...
Creating and Using Failover Groups in Azure DBaaS – Part 1
Introduction Hello everybody! One of my favorite features in Azure SQL DBaaS is Failover Groups. I have been working with these since they...
Using QPI to identify high data usage in Elastic Pool
So I recently began working on a project for a client that wanted to move from a Premium Elastic Pool to a Standard Elastic Pool due to the...
February #SQLChat – Becoming a Microsoft MVP
Are you hoping to become a Microsoft MVP? Or, have you already gone through the application process yourself? Then participate in our next Twitter...
New Discovery and Tuning Suite Now Available
We are pleased to announce the availability of a new suite of performance products packaged to fill the core needs of most SQL Server DBAs....
How to monitor tempdb databases
Introduction The tempdb system database is a workspace used to hold temporary user objects, results created through queries and sorts, and other...
How to plan future capacity
Capacity planning, especially when done for Microsoft SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but to...
How to monitor and diagnose SQL query performance
Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL...