DBAMantra

09/02/2023

Can multiple SQL Server instances listen on same port installed on same server?

In this Video we will check if two SQL Server instances can listen on same port which are installed on same windows server.I have two SQL Server instances in...

09/12/2019

From Big Data clusters to faster database recovery, here are the biggest changes Microsoft has made to its new flagship database server.

07/02/2018

Performance Counters Data collection using TypePerf utility.

Performance Counter Data collection is the key aspect of SQL Server and Windows operating system performance tuning.

03/02/2018

Database encryption is the process of converting the data within database into some ciphertext using encryption keys and suitable algorithm. Database encryption ensures even if the attackers break through the firewall and bypass the access control policies, they would need encryption keys to decipher the data.

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

21/01/2018

SQL Server encryption is a valuable tool to help ensure security, it should be considered for all sensitive data and connections. When we are deciding whether to implement encryption, consider how users will access data. If users access data over a public network, data encryption might be required to increase security.

SQL Server Encryption, Data Encryption, SQL Server Encryption, Data Protection, Data Protection using SQL Server Data Encryption, Sensitive Data Protection

18/01/2018

One of the Best Cousre on - AWS Certified Solutions Architect - Associate

Amazon Web Services (AWS) Certification is fast becoming the must-have certificates for any IT professional working with AWS. This course is designed to help you pass the AWS Certified Solutions Architect (CSA) – Associate Exam. Even if you have never logged in to the AWS platform before, by the e...

01/11/2016

Udemy's $19 sale on IT Courses
Listed some of the SQL Server and Oracle database administration related course on the below post. Take a look and register ASAP. Sale ends by November 1st.

In today’s unpredictable IT world, learning is not only a straightforward thing to do — it is key to the survival in the competition. Particularly in the recession time, it is important for individuals to learn new abilities and upgrade their skills to add value to their Roles and Responsibilities.…

27/10/2016

Every DBA uses multiple tools to perform the day to day Database Administration tasks to make his\her life easy.I am writing here for SQL Server DBA Tools.

19/10/2016

This blog contains series of most commonly asked SQL Server DBA Interview Questions regarding one of the important DBA tasks- Database Backups and Restore. Since this is very wide topic, I will try to cover all the sub topics in 2-3 blogs. 1) What are database backups? A Database backup is a copy of...