Creating backups and restoring them is crucial for maintaining the integrity and availability of data in Microsoft SQL Server. Here's a set of...
Blog
Setting up Failover Groups for AzureSQLDB for IDERA TeamServer
Setting up Failover Groups for Azure SQL Database is crucial for ensuring high availability and disaster recovery. Here’s a step-by-step guide to...
Macros – Switch domains from one data dictionary to another one
In this post, I’ll be sharing a macro based on this sample, updated to switch the bindings for all the domains included in the source dictionary and available in the target data dictionary (with the same name). If there’s no domain with the same name in the target data dictionary, the domain binding will remain unchanged.
For instance, if you intend to replace the domain bindings from the local data dictionary with those included in an Enterprise Data Dictionary.
Using the Glossary Tool Tips
With Team Server, you can easily manage your Business Glossaries and Terms. You can directly create them in Team Server or you can synchronize them with Collibra.
Macros – How to edit the Definitions and Notes with Excel
In this post, I’ll share a video which shows how to export your Definitions and Notes from ER/Studio Data Architect, edit them with Excel, and finally import the updated Definitions and Notes back to ER/Studio Data Architect.
The Locks, Blocks, and Deadlocks of SQL Server: Unraveling the Knots
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Concurrency control is a fundamental part of any database...
TempDB Troubles: Identifying and Resolving TempDB Contentions
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction The tempdb system database is a global resource in Microsoft SQL...
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...
Why Data Model? Part 5: We Data Model to be Smart
Author This blog post was authored by Todd Schraml. Always Normalize Logical Data Models The logical data model reflects the common language of the...
ER/Studio 20.0 GA
We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 20.0
ER/Studio 20.0 delivers a variety of performance improvements, usability features, security improvements, and bug fixes. As a bonus, we’ve improved scalability for enterprise-level usage. Get the latest version today!
SQL Server Alert Management: From Chaos to Clarity
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction In the fast-paced world of database administration, staying ahead...
Why Data Model? Part 4: We Data Model to Give Proper Focus to the Enterprise
Author This blog post was authored by Todd Schraml. Unify the Enterprise With Data Modeling Acting locally can be very different than acting...
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...
Why Data Model? Part 3: We Data Model to be Efficient Developers
Author This blog post was authored by Todd Schraml. Why Are Logical Data Models So Important? The logical data model is the foundational artifact...
Save Money and Space With SQL Inventory Manager from Idera
As organizations grow, their data processing and storage needs often grow too. It can be easy to lose track of your inventory when you're in charge...
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...
Why Data Model? Part 2: We Data Model to Communicate Better
Author This blog post was authored by Todd Schraml. Why Are Entity-relationship Diagrams So Important? One of the IT-only curse words across the...
Announcing the General Availability of IDERA SQL SAFE Backup 9.2.1
Introducing IDERA SQL SAFE Backup 9.2.1: The Latest Release of Our Leading SQL Server Backup Solution IDERA SQL Safe Backup is a comprehensive...
Why Data Model? Part 1: We Data Model to be Good Business Partners
This blog post was authored by Todd Schraml. How Did Data Modeling Get Started? Back when dinosaurs still ruled the world, or at least wax figurines...
Deciphering the SQL Server Performance Mysteries
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft's SQL Server is a robust and widely adopted database...
Do you know the Risks to your Database?
Databases are vitally crucial to modern businesses across all market sectors. They are the repository of an organization’s information resources,...
Harnessing Big Data: A Strategic Advantage for Modern Organizations
There are different claims regarding the coinage of the term big data, but the concept of big data has existed since the mid-20th Century....
ER/Studio 19-3-5 GA
We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 19.3.5 ER/Studio Data Architect 19.3.5 delivers improved...
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,...