DBA Stuff Performance Tuning Scripts SQL Server

SQL Server Query Store: A Complete Guide for DBAs

Enabling and Using Query Store in SQL Server As a SQL Server DBA, the Query Store is one of the most powerful tools for monitoring query performance, detecting regressions, and
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

On Instagram

DBAMantra.com

@DbaMantra
Follow Us