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

Bharat Kumar Dokka is a distinguished Associate Technical Architect with over 15 years of experience in database product ...

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

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

In the box that appears, specify the SQL Server and database hosting the data to be profiled (I’m using the AdventureWorksLT2012 database) then click OK.

Incidentally, if I was using SQL Server 2005 (or any database that supports XML as a colunmn-type and supports XPath/XQuery) I would consider creating an XML Schema that support international ...

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