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

Oracle and SQL Server both include “built-in” stored procedures, and some of them are very handy. Unfortunately, relying on them is not advisable—you have no assurance that the database ...

Sample Database Diagram - SQL Server 7.0 Here is a sample E-commerce application database structure. For a relational database to work properly you should have a field in each database that uniquely ...

Slowly Changing Dimensions – a cool new transform in SSIS Bill Gates is giving us a break with SQL Server licensing – or is he? Database failure? Don’t update your resume – You can be the ...

News SQL Design Exam Live April 14 Exam tests SQL Server 2000 database design skills. 04/04/2001 Microsoft plans to release the 70-229 SQL Server 2000 Design exam on April 14. The exam tests ...