DBAMantra

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

Myth Buster Series -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...

SQL Server 2019 Is Here: A Roundup of Its Best Features -- Redmondmag.com From Big Data clusters to faster database recovery, here are the biggest changes Microsoft has made to its new flagship database server.

Performance Counters Data collection using TypePerf utility.

Performance Counters Data collection using TypePerf utility - DBA Mantra Performance Counter Data collection is the key aspect of SQL Server and Windows operating system performance tuning.

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.

How to Perform SQL Server 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.

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.

How to use SQL Server Encryption to Secure data? - DBA Mantra SQL Server Encryption, Data Encryption, SQL Server Encryption, Data Protection, Data Protection using SQL Server Data Encryption, Sensitive Data Protection

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

One of the Best Cousre on - AWS Certified Solutions Architect - Associate - DBA Mantra 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...

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.

Database Online trainings offers - DBA Mantra 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.…

SQL Server DBA Interview Questions and Answers – SQL Server DBA Tools and Executables - DBA Mantra 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.

SQL Server DBA Interview Questions and Answers – Database Backups and Restore-1 - DBA Mantra 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...