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

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over 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 ...

So lets say I have 5 databases, all with the same schema, but different data. I want to be able to build reports based on the data in all of those databases. How could I construct a view which would ...