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...
database-tools
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...
Leveraging WMI (Part 5)
WMI classes are organized in so-called namespaces that start at “root” and work like a directory structure. The default namespace is rootcimv2, and...
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...
Leveraging WMI (Part 4)
The secret to successfully leveraging WMI is knowing the class names that represent what you are after. In the previous tip we explained how to use...
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 auditing solution...
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...
Leveraging WMI (Part 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...
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...
Leveraging WMI (Part 1)
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...