MSSQL database migration to another database server

When a database is migrated to another server by copying the database file or restoring it from a backup file, the original database user account references are also carried with it. Those accounts contain the account IDs specific to the original database server. To provide access to the restored database on the new database server […]

Microsoft SQL Server clients

To connect to an MSSQL database on Macintosh Install the Azure Data Studio Download it from Download and install Azure Data Studio on Windows Install SSMS (SQL Server Management Studio Download it from Download SQL Server Management Studio (SSMS) Install the Azure Data Studio Download it from Download and install Azure Data Studio

How to restore a Microsoft SQL database from backup with the Microsoft SQL Server Management Studio (MSSMS) user interface

There are multiple reasons to restore a database from backup. One of them can be disaster recovery, the other is to bring the production database to the developer machine. In both cases, the computer already has the old version of the database. In the new version of Microsoft SQL Server Management Studio (MSSMS) we cannot find […]

How to migrate the Visual Studio 2013 user database to SQL Server 2008

When you create a new web application in Microsoft Visual Studio 2013 the user database it creates is version 706. SQL Server 2008 can only open databases up to version 663 or earlier. To migrate the new Visual Studio 2013 databases to SQL Server 2008 script the database tables and create them again in the […]

Insert multiple rows into a Microsoft SQL Server database

There is a great way to insert multiple rows into a Microsoft SQL Server database in one statement. This notation has multiple advantages: simplicity and the grouping of multiple instructions into one transaction. INSERT MyTable (name, description)VALUES(‘John’, ‘Manager’),(‘Bill’, ‘Truck driver’) Script from Ernie Cruz