Idera, a provider of management and administration solutions for Microsoft SQL Server, has announced SQL comparison toolset v1.1, a solution that is aimed at helping DBAs save time in comparing and ...

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

Embarcadero, a provider of multi-platform database tools and developer software, has announced a special edition of DBArtisan for SQL Azure. DBArtisan is Embarcadero's database administration tool for ...

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.

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

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