SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

Due to my background working with other major database platforms such as Oracle, MySQL, and PostgreSQL, I’ve long been an advocate for the SQL Server Migration Assistant (SSMA). This powerful and easy ...

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

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...

Mostly lost among the flock of announcements at Microsoft Corp.’s Mix08 Web developer conference last week was the news that Redmond is starting to test a Web database service based on its popular SQL ...