Database Administration

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

When writing SQL queries, there is almost always more than one way to write the query to get the intended result. However, there are best practices that help with speed and efficiency. While there are many tips for writing SQL for Oracle, here is a short list of seven tips to help ensure a faster execution plan. 

  1.  Improve your queries. Rather than writing complex SQL statements that perform multiple tasks, write a separate statement for each individual task. 

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Perhaps you’re interested in reducing the amount of time spent on managing your current SQL Servers, or maybe you’d like to use a more modern approach. Maybe you’re considering lowering managing costs, improving performance, scaling your business, or there is even a chance that you are proactively seeking a high availability/disaster recovery solution. 

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Is your database healthy? The importance of a State of Health Check

Knowledge is power and proactively determining what’s causing problems in your system is integral to keeping your system functioning and keeping you in the driver’s seat. There are many reasons to perform a State of Health check, including:

       A Departure: Staff departs and takes key environmental knowledge with them.

       New Management or Staff: A "changing of the guard" occurs when management or new staff is added and you need to quickly collect and provide cross-environment information.

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

As every person in IT knows, monitoring the health of your database environment is extremely important for the stability and availability of your data, but… your DBA staff is stretched thin and overworked, your environment is continually growing due to evolving business operations, and pretty soon any attempt at enterprise-wide monitoring of availability, performance, and growth is de-centralized, disjointed across environments and/or multiple third-party solutions, or simply doesn’t exist at all.

A large scale effort to implement enterprise-wide monitoring seems overwhelming, especially when there are so many immediate fires to fight.

Read on to discover why implementing Remote Database Monitoring is worth it:

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

On Saturday, August 17, 2013, John Abrams hosted a speaker session at SQL Saturday #235 in New York City.  In case you missed it, or just want to revisit our presentation….we’ve posted it here…

As every DBA knows, the one question you want to be able to answer affirmatively is “Can you recover that data?” Monitoring is critical, but monitoring methods can be imperfect. Traditional methods are difficult to set up and maintain across your entire environment, resulting in incomplete monitoring and missed alerts, so that it’s difficult to be sure of your answer to that all important question. This presentation will:

• Show you how to implement a better way to monitor your database environment that is more efficient, easier to maintain, and guarantees that you never miss an alert.

• Share the methodology, framework, and key syntax, so that you are certain the databases you are responsible for are always up, always backed up, and never run out of disk/file space. So that your answer to that all important question is always YES!

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Continually evolving businesses (e.g., entering new markets, mergers, and acquisitions), coupled with high DBA-turnover rate can quickly result in an inefficient database environment: you could be backing up defunct databases or not backing up active databases, under- or over-utilizing server space, and, as a result, spend too much in licensing and operating costs.

As IT organizations search for new ways to reduce costs, more and more organizations are looking to database consolidation efforts to improve efficiency and reduce infrastructure operating costs. 

Database Consolidation:  A Smart Way to Reduce Costs:  Database consolidation is a smart way to reduce costs and optimize resources.  Reducing the number of databases and spreading active databases over fewer servers allows you to save money by reducing licensing costs software (e.g. Oracle, SQL Server, OS), and realize costs savings by reducing energy needs and the resources needed for support.

But, as more and more organizations are running with a leaner staff, they often don’t have the time to dedicate to assess and plan a large scale consolidation effort.