In SQL Server 2005, Microsoft introduced the new Schema object. This allowed us to de-couple the owner from the name of the object. You see, in previous releases the naming convention for a database ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

SQL Server 2005 is so packed with new features that it can be hard to keep track of it all. Like a tightly packed peloton of Tour de France riders, the new capabilities of SQL 2005 may appear as a ...

Hi,<BR><BR>Recently in developing an application it has become clear that using a *.mdb file will be far easier than deploying MSDE and the speed and functionality of MSDE isn't fully needed.

Use the Microsoft Sync Framework to synchronize data changes between SQL Server 2008 Standard, SQL Server 2008 Express and SQL Server Compact Edition 3.5. Despite the availability of wireless and ...

When Excelon Corp. disclosed plans for its Extensible Information Server (XIS) XML database to support Oracle 9i, the company's Coco Jaenicke was often asked an important question: Why would one ...