Expert User

Expert User

1 Followers
Posts 75
Comments 0
Likes 1
Views 223.967K

My Badges

w3sniff-Enthusiast
w3sniff-HotShot
w3sniff-Expert
w3sniff-Master
w3sniff-Guru
w3sniff-Populist
w3sniff-Legendary
w3sniff-Great Post
w3sniff-Energizer
w3sniff-Rocketman
w3sniff-Star of the Month
w3sniff-On the Spot

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.

Top Posts

Downgrade the SQL edition from Standard to Developer Edition

Downgrade the SQL edition from Standard to Developer Edition

Downgrading from higher edition to lower edition in SQL Server, we have to decommission the higher edition then install the lower edition with same setting as higher like instance name, backup location, system DBs location etc.

Expert User
By Expert User 8747
Add Name space in ASPX page

Add Name space in ASPX page
Expert User
By Expert User 7767 0
HTML page disable copy/paste - JavaScript

HTML page disable copy/paste - JavaScript
Expert User
By Expert User 5656 0
Alert in PHP

Alert in PHP
Expert User
By Expert User 4940 0

All posts

All Video posts

SQL Server CHECKPOINT, Lazy Writer, Eager Writer and Dirty Pages in SQL Server

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

Running Time: 00:00:00 1969 Watch the Video
SQL ACID Properties, Lazy Writer, Database Types

SQL ACID Properties, Lazy Writer, Database Types

Running Time: 00:00:00 915 Watch the Video

My interview questions and answers 39

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

2031 0 2 0

What is the purpose of sp_cycle_errorlog?

3156 0 2 0

Tell me something about the SQL Server Architecture?

3106 0 2 0

Define SQL Server Surface Area Configuration Tool?

3147 0 2 0

How to take backup of the Service master key?

3076 0 2 0

What are the types of keys used in encryption?

3256 0 2 0

What is Service master key?

3119 0 2 0

What is Transparent Data Encryption?

3063 0 2 0

What is Transparent Data Encryption?

3058 0 2 0

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

3697 0 2 0

How can SQL Server instances be hidden?

3072 0 2 0

How to troubleshoot issues with the Orphaned users?

3109 0 2 0

What are Orphaned Users?

3129 0 2 0

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

3160 0 2 0

What are Fixed Database Roles?

3110 0 2 0

What is a guest account?

3159 1 2 0

What are “View Definition” permissions?

3161 0 2 0

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

3147 0 2 0

What are Fixed Server roles and their importance?

3096 0 2 0

What is a schema?

3070 0 2 0

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

3119 0 2 0

What is a Securable?

3103 0 2 0

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

3169 0 2 0

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

3194 0 2 0

What’s the location of SQL Server log files?

3134 0 2 0

What is a Filestream?

3135 0 2 0

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

3039 0 2 0

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

3091 0 2 0

What is a slipstream installation and its usage?

3522 0 2 0

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

3225 0 2 0

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

3103 0 2 0

What is an Instance?

3027 0 2 0

What are Shared Features Directory and its usages?

3083 0 2 0

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

3428 0 2 0

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

3202 0 2 0

What is a service account?

3184 0 2 0

What is the location of the ConfigurationFile.ini file?

3458 0 2 0

What is the “ConfigurationFile.ini” file?

3073 0 3 0

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

3113 0 2 0
Home
Snippet
Search
Interview
LogIn