We need Dynamic SQL to build the object from text strings. Another problem to deal with is that the source for some database objects can exceed 32,767 characters, the maximum limit for VARCHAR2 ...

We have really just dipped our toe into the water that is using SMO with PowerShell to explore and report on various portions of SQL server and its database and tables. We can also do things such as ...

Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they ...

Since SQL Server has many deployment options, like editions, server locations and so on, different situations might need different specific configurations. However, pointing the application to the ...

Optimizing the performance of operational databases and the applications that access them is a constant battle for DBAs. Of course, writing efficient SQL is the most important aspect of ensuring ...

DBAs spend a lot of time on tuning application code and SQL statements to boost efficiency and optimize access. But SQL is only one aspect of database systems performance. It is also important for ...

SQL*Loader is a fast and easy way to get data into a database without writing long, complicated scripts. Find out how to to work better with Oracle objects. Written by Scott Stephens, Contributor ...