Tag: sql server instance

The Stored Procedure to Get the Instance Settings

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

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

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

Database administation, Database Optimization & Structure, Uncategorized

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