Data pro Thomas LaRock dives into the intricacies of SQL Server design, emphasizing the power of smart datatype decisions.

Microsoft plans to release the 70-229 SQL Server 2000 Design exam on April 14. The exam tests capabilities to design, optimize, and secure multi-user normalized SQL Server databases. The exam is ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...