-
Configure SSIS to use Named Instances
SQL Server family has various services like Database Services (SQL Server), Analysis Services, Reporting Services which supports Named Instance of the services but there are few others like Integration Services which does not support named instance. This means, we can have one and only one service of Integration Services on each server. By default, the…
-
Database Engine Instances (SQL Server): A Quick Refresher
SQL Server instance of the Database Engine is nothing but a copy of the sqlservr.exe executable that runs as an operating system service. This means for each running SQL Server instance you must see one sqlservr.exe in task manager. Like in screenshot. An instance can manage six system databases. An instance can manage one or more…