What are the steps you will take, if you are tasked with securing an SQL Serve

What are the steps you will take, if you are tasked with
securing an SQL Server?

Question Posted / guest

1 Answers
5384 Views
STC, I also Faced
E-Mail Answers

What are the steps you will take, if you are tasked with securing an SQL Server?..

Answer / sandeep

Again this is another open ended question. Here are some
things you could talk about: Preferring NT authentication,
using server, databse and application roles to control
access to the data, securing the physical database files
using NTFS permissions, using an unguessable SA password,
restricting physical access to the SQL Server, renaming the
Administrator account on the SQL Server computer, disabling
the Guest account, enabling auditing, using multiprotocol
encryption, setting up SSL, setting up firewalls, isolating
SQL Server from the web server etc.
Read the white paper on SQL Server security from Microsoft
website. Also check out My SQL Server security best practices

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More DB Administration Interview Questions

why Datapump is faster than traditional export and import

4 Answers Mphasis,

What is the dataguard background process??

1 Answers iGate,

How can we see the database version in os level

6 Answers Oracle,

which background process invoke at the time of upgradation tell me???

0 Answers iGate,

what is the diffrence between core dba and apps dba?

0 Answers Cap Gemini,

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers

how to restore files with rman?

0 Answers

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

what are the performance views in an oracle rac environment?

0 Answers Oracle,

why we use cursors

1 Answers

For more DB Administration Interview Questions Click Here