SQL Query to check port number of SQL Server

  • February 9, 2023
  • 0 Comments

We can use below query to check the port on which SQL Server is listening. DECLARE @InstanceName nvarchar(50) DECLARE @value VARCHAR(100) DECLARE @RegKey_InstanceName nvarchar(500) DECLARE @RegKey nvarchar(500) SET @InstanceName=CONVERT(nVARCHAR,isnull(SERVERPROPERTY(‘INSTANCENAME’),’MSSQLSERVER’)) –For SQL Server 2000 if(SELECT Convert(varchar(1),(SERVERPROPERTY(‘ProductVersion’))))=8 BEGIN if @InstanceName=’MSSQLSERVER’ Begin SET @RegKey=’SOFTWARE\Microsoft\’+@InstanceName+’\MSSQLServer\SuperSocketNetLib\TCP\’ END ELSE BEGIN SET @RegKey=’SOFTWARE\Microsoft\Microsoft SQL Server\’+@InstanceName+’\MSSQLServer\SuperSocketNetLib\TCP\’ END EXECUTE xp_regread @rootkey = ‘HKEY_LOCAL_MACHINE’, @key […]

All About Oracle Database Cloud Offerings and Features – 2023

  • January 15, 2023
  • 0 Comments

Oracle Database Cloud Offerings Oracle Database is a widely used relational database management system (RDBMS) that is available in various cloud-based offerings and on-premises versions. Oracle Cloud Infrastructure (OCI) provides several options for running Oracle Database in the cloud, including: Autonomous Database: A fully managed, self-driving database service that eliminates the need for manual administration […]

AWS RDS SQL Server Overview and Offering & FAQs

  • January 15, 2023
  • 0 Comments

Amazon RDS (Relational Database Service) for SQL Server is a fully managed service that makes it easy to set up, operate, and scale SQL Server databases in the cloud. It allows users to launch a fully managed SQL Server instance, with the ability to choose from several versions and editions, including Express, Web, Standard, and […]

SQL Server DBA Interview Questions Answers – Always On availability group

  • January 14, 2023
  • 0 Comments

Availability Groups is a feature in SQL Server that allows you to create a group of read-write and read-only replicas of a primary database to provide high availability and disaster recovery. The feature was first introduced in SQL Server 2012 and since then it has been improved and enhanced in later versions. Availability Groups allow […]

SQL Server Feature – In Memory OLTP (Online Transaction Processing)

  • January 14, 2023
  • 0 Comments

In Memory OLTP (Online Transaction Processing) is a feature in SQL Server that allows you to improve the performance of your transactional workloads by keeping the data and indexes in memory. This feature was introduced in SQL Server 2014 and is based on a new storage engine called the Hekaton engine. There are several benefits […]