Tag: SQL Server Integration Services

  • Configure SSIS to use Named Instances

    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…

  • March towards SQL Server : Day 6 – SQL DBA Interview Questions Answers – All about SQL Server Services

    March towards SQL Server : Day 6 – SQL DBA Interview Questions Answers – All about SQL Server Services

    This blog is all about the SQL Server Services which are required for the functionality of SQL Server components. It also contains Questions answers about the important parameters and SQL Server start process. 1) List out various services which are important for SQL Server and its components functionality? SQL Server Service SQL Server Agent service…