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

There’s a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

Much of a SQL server's configuration is held in master/model/msdb, so it isn't exactly easy to replace (restoring the master database is a pain, for example).

I'm glad you asked. To successfully copy a login from one server to another, you'll need to ensure that the copy has the same SID and password. The link between database users and logins is done with ...

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

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup If you need to know where the actual SQL engine is located, look at the tag SQLPath, which is also in this same node.