Blog

Capacity planning, especially when done for Microsoft SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but to right-size databases for a new SQL Server implementation or migration, there is a lot more than space to c...

Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL queries prevent other SQL queries from using these resources. This can eventually lead to blocking. C...

Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models, propagate changes from one model to the other in both directions, create database scripts, and reverse-enginee...

SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance information, analyze it, and determine the resolution in minutes rather than hours. Leverage ...

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 backu...

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 upda...

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. Migra...

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 solution for SQL Servers that helps identify vulnerabilities with SQL Server configurations and access, e...

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 Filter the results by server, database, and table. Sort in...

Determine the health of instances by collecting real-time statistics (including backup devices, databases, error logs, locks, logins, performance counters, processes, and agent errors). With the Server Statistics tool of SQL Admin Tool...

Introduction This blog post describes ten lesser-known features of SQL Diagnostic Manager with links to short how-to videos and additional resources. Learn how to add custom counters and custom SQL scripts, capture deadlocks, integrate with SCOM, mon...

Run new and existing PowerShell scripts with SQL Diagnostic Manager and utilize the vast power of PowerShell via the customizable monitoring environment. Run scripts to automatically react to problems detected by the monitoring environment,...

Uptime Infrastructure Monitor Uptime Infrastructure Monitor (UIM) is an enterprise tool that provides a unified view for Information Technology systems monitoring. Although comprehensive and scalable, UIM is also easy to use and deploys in minut...

To find the key points of how SQL Workload Analysis can help you, look for the ducks  throughout this blog post! What Is SQL Workload Analysis? It is an add-on to SQL Diagnostic Manager and a component of the IDERA Dashb...

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 effects of cardinality adjustments. Create efficient SQL queries in low cardinality environments. Read the ...

Every database administrator hates to wake up at midnight just to learn there is an emergency with their database. Sometimes, even though their hardware specifications are above par and they know everything was working fine earlier that day, database...

For over three decades, organizations have relied on data warehouses to support business information consumers’ needs for descriptive analytics to help inform about the current state and to help influence ongoing business decisions. People augm...

SQL Server resellers often send true-up forms to their customers more frequently than Microsoft requires. Some customers receive them every month. They may feel compelled to fill them out each time. However, Microsoft only requires one true-up each y...

A large enterprise telecommunications company that provides wireless services and internet services in the United States of America uses a third-party application to gather configuration and performance data on their servers. However, a batch job tha...

Effective data governance programs are partnerships between the business and technical parts of the organization. Often, organizations focus more on one side of the house than on the other, when in reality, governance-like activities are already taki...

Monitoring applications, networks, and servers (physical, virtual, and cloud) across multiple platforms has become essential, making smart server monitoring software critical for building a successful Information Technology department. However, with ...

Today’s complex applications execute hundreds of SQL procedures and maybe thousands of SQL statements during a typical workload. Database administrators and developers can use load testing to verify that the system can handle the workload with ...

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 the information technology professionals, such as application developers and database administrators. ...

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 if you want a sandbox, or a database to support just a handful of users. The problem is that in order f...