Previous Next

What you need to know to improve your backup and recovery strategy and meet your SLAs.

According to a recent poll, less than a quarter of respondents are completely confident that 100% of their backed-up data can be recovered, with more than a third asserting that they were sure their data COULD NOT be 100% recovered.   And one-third of respondents don’t know/are unsure they meet backup and recovery SLAs.

With database size continuing to exponentially grow, and corporate governance rules frequently making executives liable for the security of corporate information, it’s become increasingly important to make sure your backups are occurring efficiently.  You need the proof that your data can be recovered in a secure and timely manner.

Here are the top 5 benefits of conducting a backup and recovery assessment of your environment, and some tips on ensuring that you get the information that is truly going to improve your backup and recovery strategy, and your day-to-day operations.

Previous Next

The Problem: Your boss has asked you to make changes to an application that will affect an MS SQL Server database, and first needs to know the impact analysis of those changes before any work is performed.


The Solution: Utilize this simple Find All query to help you find all impacted objects in your database with minimal effort.


Let’s say you need to find all occurrences of “status” in your database. Click to view query syntax that will find all objects (tables, stored procedures, views, functions, triggers, keys, and default values) that include the string “status” somewhere in the name or contents of the object, and provide a count of those occurrences.

Previous Next

According to a survey conducted by Career Builder many US companies are recruiting contract workers over full-time permanent positions as a solution to quickly support a leaner workforce.  Contract to hire is an especially great fit for the IT industry:  specialized projects with an often pre-determined life cycle make IT positions particularly well-suited to staffing via contract and contract to hire. Contract to hire is a post-recession trend in the IT industry that appears to be growing.  So what should you know?

Previous Next

As 2012 comes to an end, we’ve noticed an interesting trend. The demand for Database Administrators is on the rise, expected to reach 30 percent growth by 2020, according to the Bureau of Labor Statistics. In fact, CNN Money recently ranked Database Administration number 8 for job growth.

But, what’s fueling the growth? And why, all of the sudden, do so many companies need Database Administrators? Trends suggest increased adoption of cloud computing may be a factor.

Previous Next

Organizations are managing hundreds of terabytes of information, to mine, analyze and better understand markets. So, it’s no surprise that when data is unavailable, inaccurate or lost, the effects are widespread and crippling.

That’s why even companies with full-time DBAs are enlisting the help of firms offering remote database administration; supplementing database support or outsourcing the function altogether. Read on to discover why it’s a trend that experts say is here to stay.