Featured Blog
ER/Studio Data Architect 20.1 General Availability
Solutions to common methods of SQL Server intrusion
To understand how malicious actors can infiltrate SQL Server is the key to understanding how to prevent intrusions. The consequences for inadequate...
SQL Server security best practices
There are several examples where data theft has brought organizations to a halt or resulted in a bad press that will leave a tarnished image. For...
SQL Server security threats are closer than you think
Today, business is about data. Database systems and the elements they store are the most valuable assets in any enterprise. Not only are business...
We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.2
ER/Studio 19.2 delivers a whole new approach to modelling hierarchical structures such as document-based NoSQL platforms and file formats, with...
Improve your planning for SQL Server backups
Not understanding recovery needs The whole point of creating backups is to retrieve data in case data is lost or there is a failure. But to set up...
Deliver data-driven capabilities with data modeling
Werner Enterprises is a transportation and logistics leader with more than 8,000 trucks, 24,000 trailers and nearly 13,000 employees. Today, 65...
Four unique features of ER/Studio Data Architect
Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models,...
How to ensure that databases are backed up regularly
Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases....
Announcing the General Availability of SQL Secure 4.0
We are pleased to announce the general availability of SQL Secure 4.0 SQL Secure is the industry-leading, state of the art auditing and security...
Discover how cardinality affects performance
Cardinality is a term from set theory that deals with the size of a set. Data cardinality can affect query plans and performance. Minimize the...
Make SQL Server performance easy
Every database administrator hates to wake up at midnight just to learn there is an emergency with their database. Sometimes, even though their...
Enable customer business intelligence via data catalogs, business glossaries, and data governance
For over three decades, organizations have relied on data warehouses to support business information consumers’ needs for descriptive analytics to...
Cut SQL Server licensing costs
SQL Server resellers often send true-up forms to their customers more frequently than Microsoft requires. Some customers receive them every month....
Understand the role of data architects in data governance
Effective data governance programs are partnerships between the business and technical parts of the organization. Often, organizations focus more on...
Improve database performance by 400%
A large enterprise telecommunications company that provides wireless services and internet services in the United States of America uses a...
Decide between agent-based versus agentless monitoring
Monitoring applications, networks, and servers (physical, virtual, and cloud) across multiple platforms has become essential, making smart server...
Measure database performance under pressure
Today’s complex applications execute hundreds of SQL procedures and maybe thousands of SQL statements during a typical workload. Database...
Compare four leading database IDE tools
Today, many roles within an organization often work with the ever-growing amounts of data in databases. No longer are databases the purview of just...
Make, not break, SQL Server performance
One of the beautiful things about SQL Server is how accessible it is. It is about as difficult to install as, say, Microsoft Office. This is great...
Announcing the General Availability of SQL Compliance Manager 5.9
We are excited to announce the release of SQL Compliance Manager 5.9 SQL Compliance Manager is the industry leading SQL Server...
Announcing the General Availability of SQL Safe Backup 8.7.2
We’re excited to announce the release of SQL Safe Backup 8.7.2 SQL Safe Backup provides the industry's shortest time from starting a SQL Server...
Take a human approach to data governance
Most organizations recognize how important data governance is, although they often fail in their efforts to become driven by data. An investment in...
Migrate databases to Azure SQL Database
There are three distinct approaches organizations can follow to implement Data Governance. There is the command-and-control approach, the...
Announcing The General Availability of DB PowerStudio version 18.1
DB PowerStudio Highlights IDERA DB PowerStudio provides a powerful cross platform toolset for database development, tuning and management in the...
How Precise for Oracle Database can help you
Precise for Oracle Database keeps your Oracle database environment available and performing at peak efficiency. It captures, measures, and analyzes...
Demystify data integrity
When we talk about knowing our data, we do not seem to refer to the term data integrity anymore as part of that conversation. After all, that phrase...
Tips for data warehouses and other large databases
Whether on-premises or in the cloud, people often ask database administrators to create and manage optimal database designs for data warehouses....
Monitor pragmatically for SLAs and application performance
Watch the webinar “Pragmatic monitoring: Guiding IT with SLA management and application monitoring” by Robert Vandervoort to learn more...
Add health monitoring to performance monitoring
Database administrators must monitor their databases for factors such as availability, health, and performance. However, monitoring also has costs...
Select the right approach to data governance
There are three distinct approaches organizations can follow to implement Data Governance. There is the command-and-control approach, the...