Thursday February 9, 2012
Microsoft SQL Server 2008 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing environment or for those learning about databases or SQL Server for the first time who need a platform they can install on a personal computer to create a learning environment.
Read the full tutorial:
Installing SQL Server 2008 R2 Express Edition
Tuesday February 7, 2012
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it's certainly possible to install it on a desktop operating system like Windows 7. Once you do so, you'll have the tremendous power of the flexible MySQL relational database available to you for free. It's an extremely useful database for both developers and system administrators. Installing MySQL on Windows 7 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. Here's a step-by-step walkthrough of the process.
Read the full tutorial:
Installing MySQL on Windows 7
Thursday February 2, 2012
One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.
Read the full story:
Printing Mailing Labels in Access 2010
Tuesday January 31, 2012
In a
recent forum message, MRTK2012 wrote:
"Could anyone please let me know how to append a wildcard in bcp file to insert
data into database?
In the below example I want to use the wildcard after "inventory", so that I can run all bcp files in a single click:
bcp inventory.dbo.fruits in "C:\fruit\inventory0.txt" -c -T
bcp inventory.dbo.fruits in "C:\fruit\inventory1.txt" -c -T
bcp inventory.dbo.fruits in "C:\fruit\inventory2.txt" -c -T
Thanks in advance."
Can you help? Interested in answers to the same question? Visit the
About Databases Forum and join the discussion!