After completing the process of installing and configuring Microsoft SQL Server, any database administrator is entitled to sit back and take a well-deserved break. However, it's important to remember that ... Read More

Looking for a quick, efficient way to summarize the data stored in your database? The SQL ROLLUP and CUBE commands offer a valuable tool for gaining some quick and ... Read More

Fed up with the world of commercial software licensing? Are you looking for a stable database platform for your organization but sweating at the hefty price tags attached to mainstream ... Read More

SQL Server replication allows database administrators to distribute data to various servers throughout an organization. You may wish to implement replication in your organization for a number of reasons, such ... Read More

Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks.

The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major ... Read More

If you’re a Microsoft Office power user, you might be familiar with the encryption features of Word, PowerPoint and Excel. These programs all allow file owners to easily apply encryption. ... Read More

By their very nature, our databases contain a lot of data. In previous features, we've explored methods of extracting the specific data we're looking for using the Structured Query ... Read More

If you've been reading the IT industry's help wanted ads recently, there's no doubt you've come across a number of ads seeking professional database administrators, designers and developers. Have you ... Read More

Oftentimes, you wish to share data with users in your organization who may, in turn, wish to create their own forms and reports. While you may want them to have ... Read More

In this article, we'll begin a series that looks at the details of using ADO in a real-world environment. The sample code in these tutorials will assume that you're a ... Read More

In a recent forum posting, Paul wrote: "We currently have multiple SQL DB's across multiple Servers (includes sharepoint, some Japanese DB's and accounting/asset management). I have been asked to consolidate these DB's ... Read More