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 ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

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 ...

Database connectivity gives desktop and Web applications much of their value. .NET developers have products and framework objects that can tie a front-end application to SQL Server, MySQL, Sybase, ...

Object-oriented databases play nicely with object-oriented programming languages. This post is one of a series that introduces the fundamentals of NOSQL databases, and their role in Big Data ...

Traditionally, SQL Distributed Management Objects (DMO) and SMO have been complicated enough to code that many DBAs stayed away from them.

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...