There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...

In SQL Server 2000, if Fred created a table called “Mytable” in the “Pubs” database on the “Usaserver”, the fully qualified name would be Usaserver.Pubs.Fred.Mytable.

I needed to copy the SQL Server database, with its most recent schema changes, down to my laptop for a client demonstration at a location where Internet connectivity might not be available. Even ...

Idera, a provider of management and administration solutions for Microsoft SQL Server, has announced SQL comparison toolset v1.1, ... MultiValue Database Technology. NoSQL : Register now for Data ...

SQL database is a relational database. The basic quality of NoSQL is that it may not require fixed table schemas, usually avoid join operations, and typically scale horizontally. Skip to primary ...