Expert User

Expert User

1 Followers
Posts 75
Comments 0
Likes 2
Views 311.072K

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

Add Name space in ASPX page

Add Name space in ASPX page

Add Namespace in ASPX page to write the C# code in aspx page

Expert User
By Expert User 14977
Downgrade the SQL edition from Standard to Developer Edition

Downgrade the SQL edition from Standard to Developer Edition
Expert User
By Expert User 10504 1
HTML page disable copy/paste - JavaScript

HTML page disable copy/paste - JavaScript
Expert User
By Expert User 6972 0
The database principal owns a service in the database, and cannot be dropped

The database principal owns a service in the database, and c....
Expert User
By Expert User 5756 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 2442 Watch the Video
SQL ACID Properties, Lazy Writer, Database Types

SQL ACID Properties, Lazy Writer, Database Types

Running Time: 00:00:00 1176 Watch the Video

My interview questions and answers 39

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

2740 0 2 0

What is the purpose of sp_cycle_errorlog?

4868 0 2 0

Tell me something about the SQL Server Architecture?

4626 0 2 0

Define SQL Server Surface Area Configuration Tool?

4658 0 2 0

How to take backup of the Service master key?

4653 0 2 0

What are the types of keys used in encryption?

4813 0 2 0

What is Service master key?

4662 0 2 0

What is Transparent Data Encryption?

4548 0 2 0

What is Transparent Data Encryption?

4552 0 2 0

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

5232 0 2 0

How can SQL Server instances be hidden?

4581 0 2 0

How to troubleshoot issues with the Orphaned users?

4792 0 2 0

What are Orphaned Users?

4818 0 2 0

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

4664 0 2 0

What are Fixed Database Roles?

4646 0 2 0

What is a guest account?

4848 1 2 0

What are “View Definition” permissions?

4731 0 2 0

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

4737 0 2 0

What are Fixed Server roles and their importance?

4589 0 2 0

What is a schema?

4576 0 2 0

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

4619 0 2 0

What is a Securable?

4631 0 2 0

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

4829 0 2 0

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

4927 0 2 0

What’s the location of SQL Server log files?

4818 0 2 0

What is a Filestream?

4653 0 2 0

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

4540 0 2 0

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

4624 0 2 0

What is a slipstream installation and its usage?

5033 0 2 0

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

4801 0 2 0

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

4649 0 2 0

What is an Instance?

4506 0 2 0

What are Shared Features Directory and its usages?

4629 0 2 0

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

5037 0 2 0

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

4917 0 2 0

What is a service account?

4897 0 2 0

What is the location of the ConfigurationFile.ini file?

4972 0 2 0

What is the “ConfigurationFile.ini” file?

4618 0 3 0

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

4794 0 2 0
Home
Snippet
Search
Interview
LogIn