Scripts SQL Server

SQL Query to check port number of SQL Server

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
  • BY
  • February 9, 2023
  • 0 Comments
Oracle Cloud Computing

All About Oracle Database Cloud Offerings and Features – 2023

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
  • BY
  • January 15, 2023
  • 0 Comments
AWS Cloud Computing SQL Server

AWS RDS SQL Server Overview and Offering & FAQs

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
  • BY
  • January 15, 2023
  • 0 Comments
Interview Question Always On SQL Server

SQL Server DBA Interview Questions Answers – Always On availability group

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
  • BY
  • January 14, 2023
  • 0 Comments
Cloud Computing

Top 5 Cloud Computing Certifications of 2018

Usage of Data has led to companies plan, strategize and execute even more efficiently than before. With an increase in the trend of getting businesses online and moving towards economies
  • BY
  • February 6, 2018
  • 0 Comments

On Instagram

DBAMantra.com

@DbaMantra
Follow Us