Tag: sql server instance

The Stored Procedure to Get the Instance Settings

13:01 Database development, Stored Procedures

SQL Server instances house databases containing the data for the backend stack of a business model,...
Read More

Restoring the SQL Server Master Database

14:59 Database administation, Database Optimization & Structure, Uncategorized

INTRODUCTION The master database contains records of the structure/configuration for both the current instance and all other databases....
Read More

SQL Server System Databases – Basic Concepts

14:44 Database administation, Database Optimization & Structure, Uncategorized

Introduction The SQL Server design implies a one-to-many mapping between the database engine (instance) and the databases hosted on the...
Read More

How To Migrate SQL Server Jobs From One SQL Server Instance To Another

10:43 Database administation, Database Optimization & Structure, Uncategorized

Introduction In a previous article, we highlighted that the msdb database stores practically all...
Read More
Close