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

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

Every database administrator hates to wake up at midnight just to learn there is an emergency with their database. Sometimes, even though their...

For over three decades, organizations have relied on data warehouses to support business information consumers’ needs for descriptive analytics to...

SQL Server resellers often send true-up forms to their customers more frequently than Microsoft requires. Some customers receive them every month....

Effective data governance programs are partnerships between the business and technical parts of the organization. Often, organizations focus more on...

A large enterprise telecommunications company that provides wireless services and internet services in the United States of America uses a...

Monitoring applications, networks, and servers (physical, virtual, and cloud) across multiple platforms has become essential, making smart server...

Today’s complex applications execute hundreds of SQL procedures and maybe thousands of SQL statements during a typical workload. Database...

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

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

Most organizations recognize how important data governance is, although they often fail in their efforts to become driven by data. An investment in...

There are three distinct approaches organizations can follow to implement Data Governance. There is the command-and-control approach, the...

DB PowerStudio Highlights IDERA DB PowerStudio provides a powerful cross platform toolset for database development, tuning and management in the...

Precise for Oracle Database keeps your Oracle database environment available and performing at peak efficiency. It captures, measures, and analyzes...

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

Whether on-premises or in the cloud, people often ask database administrators to create and manage optimal database designs for data warehouses....

Watch the webinar “Pragmatic monitoring: Guiding IT with SLA management and application monitoring” by Robert Vandervoort to learn more...

Database administrators must monitor their databases for factors such as availability, health, and performance. However, monitoring also has costs...

There are three distinct approaches organizations can follow to implement Data Governance. There is the command-and-control approach, the...

Database security is perhaps the most important part of an information security program that many people are not paying attention to. Some might...

As tables increase in size and more and more users come online, it becomes necessary to fine-tune the database server from time to time. The secret...

A data model organizes data elements and standardizes their relation to each other and the properties of real-world entities. Edgar F. Codd...

The data management professionals of today are finding their landscape changing. They have multiple database platforms to manage and need to control...

If applications fail or suffer from low performance levels, then organizations lose revenues and customers. Information Technology (IT) operations...

Database administrators are busier than ever these days, so fighting fires is the last thing they want to spend their time doing. A proactive...