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 administrators and developers can use load testing to verify that the system can handle the workload with reasonable performance....

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

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

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 technology does not address this problem and may make it worse because data governance is a process rather than a...

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 traditional approach and the non-invasive approach to putting a formal program in place. The benefits and the issues that result...

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 performance metrics from all critical system components and helps you detect and correct the root causes of problems...

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 can be intimidating. But at its heart, it is straightforward–guaranteeing our data has meaning. The good news is...

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. This also extends to data lakes and many other extensive databases. People ask them to do this using relational database...

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 about pragmatic monitoring within management of service-level agreements and application monitoring. Robert will help...

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 associated with it that may exceed the benefits it provides. A performance monitoring tool is essential for...

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 traditional approach and the non-invasive approach to putting a formal program in place. The benefits and the issues that result...

Consider these database security risks

Database security is perhaps the most important part of an information security program that many people are not paying attention to. Some might assume that network or server security controls are adequate to protect databases. They are not. Gaps in Information...

Learn about data model behavior

A data model organizes data elements and standardizes their relation to each other and the properties of real-world entities. Edgar F. Codd introduced the relational database model in 1970, which uses tables to make databases independent of other software...

Deploy and manage complex Azure environments

The data management professionals of today are finding their landscape changing. They have multiple database platforms to manage and need to control these complex configurations. Watch the educational Geek Sync webinar “Deployment and management of complex Azure...

Avoid common enterprise pitfalls of IT systems monitoring

If applications fail or suffer from low performance levels, then organizations lose revenues and customers. Information Technology (IT) operations managers and administrators need to adopt a complete IT dashboard. It needs to provide total visibility over the IT...

Be a proactive database administrator

Database administrators are busier than ever these days, so fighting fires is the last thing they want to spend their time doing. A proactive approach to database performance and maintenance helps keep them ahead of trouble and prevents minor problems from turning...

1 7 8 9 10 11 124