Expert User

1 Followers

Posts 75

Comments 0

Likes 1

Views 250.446K

My Badges

About me

Hello, I’m a SQL Server DBA from New Delhi, India. Experienced SQL Server Database and Azure Administrator having experience in MS SQL Server 2008/2012/2014/2016/2017/2019/SQL AZURE/AWS RDS.

My interview questions and answers 39

What is DOM? What is the use of document object?

2290 0 2 0

What is the purpose of sp_cycle_errorlog?

3651 0 2 0

Tell me something about the SQL Server Architecture?

3536 0 2 0

Define SQL Server Surface Area Configuration Tool?

3577 0 2 0

How to take backup of the Service master key?

3524 0 2 0

What are the types of keys used in encryption?

3690 0 2 0

What is Service master key?

3545 0 2 0

What is Transparent Data Encryption?

3482 0 2 0

What is Transparent Data Encryption?

3476 0 2 0

Being a DBA what all measures you will follow to make SQL SE....

4130 0 2 0

How can SQL Server instances be hidden?

3500 0 2 0

How to troubleshoot issues with the Orphaned users?

3600 0 2 0

What are Orphaned Users?

3618 0 2 0

What is the purpose of db_denydatawriter and db_denydatarea....

3591 0 2 0

What are Fixed Database Roles?

3542 0 2 0

What is a guest account?

3649 1 2 0

What are “View Definition” permissions?

3612 0 2 0

What are “View Server State”, and “VIEW DATABASE STATE....

3615 0 2 0

What are Fixed Server roles and their importance?

3516 0 2 0

What is a schema?

3504 0 2 0

Explain the scope of securable on Server, Database, and Sche....

3545 0 2 0

What is a Securable?

3545 0 2 0

Is it possible to increase the retention of Error log files ....

3658 0 2 0

How many SQL Server log files can be retained in the SQL Ser....

3695 0 2 0

What’s the location of SQL Server log files?

3624 0 2 0

What is a Filestream?

3568 0 2 0

How to get the port number where the SQL Server instance is ....

3464 0 2 0

Can we change the default port of SQL Server, How?

3535 0 2 0

What is a slipstream installation and its usage?

3947 0 2 0

What is a Service Pack, Patch, Hotfix, and its difference?

3673 0 2 0

What are the Type of SQL instances and maximum no. of instan....

3556 0 2 0

What is an Instance?

3447 0 2 0

What are Shared Features Directory and its usages?

3511 0 2 0

What permissions are required to install SQL Server on a ser....

3901 0 2 0

Do we need to grant Administrator permissions on the Windows....

3708 0 2 0

What is a service account?

3674 0 2 0

What is the location of the ConfigurationFile.ini file?

3889 0 2 0

What is the “ConfigurationFile.ini” file?

3500 0 3 0

Where will you find the SQL Server installation-related logs....

3600 0 2 0

Expert User

My Badges

About me

Top Posts

Add Name space in ASPX page

Downgrade the SQL edition from Standard to Developer Edition

HTML page disable copy/paste - JavaScript

Alert in PHP

All posts

Database checkpoints (SQL Server)

MySQL SHOW USERS? – How to List All MySQL Users and Privil....

How to rename a SQL Server database?

The database principal owns a schema in the database, and ca....

The database principal owns a service in the database, and c....

The database principal owns a contract in the database, and ....

The database principal owns a message type in the database a....

HTML page disable copy/paste - JavaScript

How to Create an Animated Countdown Timer With HTML, CSS and....

Time zones in Azure SQL Managed Instance

Decommission or Un-install or Remove SQL Instance

Downgrade the SQL edition from Standard to Developer Edition

Configure backup of SQL Database in Azure Storage Account

Grant Access to user or logins on All databases

Execute permission was denied on the object xp-msver databas....

Execute permission was denied on the object xp_instance_regr....

Change the collation of SQL Server Instance

Query execution time of sql query

Redirect HTTP to HTTPS

Autocomplete location in text box from Google MAP

Date Comparison in javascript

Cookies in javascript

Get Auto increment ID in MYSQL using codeigniter

Auto Complete in CodeIgniter using jquery from database

Number Validation | Only Numbers allowed 0-9

Email Validation

Invoice Number | Order Number | Date | Current Date

Dynamic set place holder for asp input type in C#

Copy text and show a message in the toast

Add Session in C#

Add Name space in ASPX page

Alert in PHP

Find Min and Max

Allow Arabic language to insert in ASP.Net

All Video posts

SQL Server CHECKPOINT, Lazy Writer, Eager Writer and Dirty P....

SQL ACID Properties, Lazy Writer, Database Types

My interview questions and answers 39

What is DOM? What is the use of document object?

What is the purpose of sp_cycle_errorlog?

Tell me something about the SQL Server Architecture?

Define SQL Server Surface Area Configuration Tool?

How to take backup of the Service master key?

What are the types of keys used in encryption?

What is Service master key?

What is Transparent Data Encryption?

What is Transparent Data Encryption?

Being a DBA what all measures you will follow to make SQL SE....

How can SQL Server instances be hidden?

How to troubleshoot issues with the Orphaned users?

What are Orphaned Users?

What is the purpose of db_denydatawriter and db_denydatarea....

What are Fixed Database Roles?

What is a guest account?

What are “View Definition” permissions?

What are “View Server State”, and “VIEW DATABASE STATE....

What are Fixed Server roles and their importance?

What is a schema?

Explain the scope of securable on Server, Database, and Sche....

What is a Securable?

Is it possible to increase the retention of Error log files ....

How many SQL Server log files can be retained in the SQL Ser....

What’s the location of SQL Server log files?

What is a Filestream?

How to get the port number where the SQL Server instance is ....

Can we change the default port of SQL Server, How?

What is a slipstream installation and its usage?

What is a Service Pack, Patch, Hotfix, and its difference?

What are the Type of SQL instances and maximum no. of instan....

What is an Instance?

What are Shared Features Directory and its usages?