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.

Previous Next

This SQL script produces front-end ADO called a function by a stored procedure name. By default the script will process all user stored procedures and generate an ADO function for each procedure. If you need to specify the stored procedures, just uncomment “– and name in (‘list _proc’)” line — then list the desired procedures.  Please click below for download:

Create ADO Call Using T-SQL

 

Search