-
SQL DBA Cheatcode : SQL Server properties
In this article I am trying to outline about some important server properties which can help you out at the time of auditing and trace history of SQL Server. It has been checked in various SQL versions like SQL 2005, 2008, 2008 R2 and 2012. SELECT SERVERPROPERTY(‘BuildClrVersion’) AS [BuildClrVersion] , SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) AS ComputerNamePhysicalNetBIOS , SERVERPROPERTY(‘ServerName’)…
-
SQL Server Setup Discovery Reports & Related Queries
Microsoft Sql Server has given so many options to check which version of SQL installed on server. With this Discovery Report we can check how many instances installed on the server, what is the version, the instance belong to which edition, how many features are enabled for that instance, whether it is clustered or not.…
-
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…