Permission & Security Scripts SQL Server

How to Setup SQL Server Audit using SQL scripts

Navigating the complexities of SQL Server auditing can be daunting. Whether you’re ensuring compliance, securing data, or simply looking to understand changes within your database environment, auditing is critical. This
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

On Instagram

DBAMantra.com

@DbaMantra
Follow Us