SQL Server Archives - DBA Mantra

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...

BY Technical Editor
April 13, 2024
0 Comment

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...

BY Editor
February 9, 2023
0 Comment

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,...

BY Editor
January 15, 2023
0 Comment

Interview Question Always On SQL Server

SQL Server DBA Interview Questions Answers – Always On availability...

Availability Groups is a feature in SQL Server that allows you to create a group of read-write and read-only replicas...

BY Editor
January 14, 2023
0 Comment

Server Properties SQL Server

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

In Memory OLTP (Online Transaction Processing) is a feature in SQL Server that allows you to improve the performance of...

BY Editor
January 14, 2023
0 Comment

SQL Server Performance Tuning

SQL Server Performance Counter Data collection using TypePerf utility

https://dbamantra.com/wp-content/uploads/2018/02/TypePerf-1.jpgSQL Server performance tuning and Optimizing SQL Server is part of the day to day job of a Database administrator....

BY Editor
February 7, 2018
0 Comment

SQL Server Backup\Restore

How to Perform database restore with Database Encryption

Database encryption is the process of changing the information inside database into some ciphertext using encryption keys and appropriate algorithm....

BY Harsh Diwan
February 3, 2018
0 Comment

SQL Server Standards

How to use SQL Server Encryption to Secure data?

SQL Server Encryption Implementation What is Data Sensitivity? Data protection and security is one of the most important aspects of...

BY Harsh Diwan
January 20, 2018
0 Comment

SQL Server MySQL

SQL Server 2016 SP1 Release – A bold move by...

A bold move by Microsoft, Is not it? With the emergence of cloud technology, there is a huge competition in...

BY Technical Editor
November 21, 2016
0 Comment

Oracle Featured SQL Server SQL Terminologies

Database Online training offers – Udemy $14.99 sale

In today’s unpredictable IT world, learning is not only a straightforward thing to do — it is key to the...

BY Editor
October 31, 2016
0 Comment

Archives

Categories

Meta

How to Setup SQL Server Audit

SQL Query to check port number

All About Oracle Database Cloud Offerings

AWS RDS SQL Server Overview and

How to Setup SQL Server Audit using SQL scripts

SQL Query to check port number of SQL Server

AWS RDS SQL Server Overview and Offering & FAQs

SQL Server DBA Interview Questions Answers – Always On availability...

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

SQL Server Performance Counter Data collection using TypePerf utility

How to Perform database restore with Database Encryption

How to use SQL Server Encryption to Secure data?

SQL Server 2016 SP1 Release – A bold move by...

Database Online training offers – Udemy $14.99 sale

Best online courses on SALE – All Courses $9.99

How to Setup SQL Server Audit using SQL scripts

SQL Query to check port number of SQL Server

All About Oracle Database Cloud Offerings and Features – 2023

How to Setup SQL Server Audit using SQL scripts

SQL Query to check port number of SQL Server

All About Oracle Database Cloud Offerings and Features – 2023

AWS RDS SQL Server Overview and Offering & FAQs

How to Setup SQL Server Audit using SQL

SQL Query to check port number of SQL

All About Oracle Database Cloud Offerings and Features