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 |
Can we take incremental backups in datapump?
How can you control the amount of free space in your index pages? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
by issuing "alter tablespace begin backup;" what happens to tablespace?
Explain how you would restore a database using RMAN to Point in Time?
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
Which autogrowth database setting is good? : sql server DBA
how can you schedule a job in database?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
If we issue alter database begin backup. What happens to database?
how can you initialize log miner?
what are the types of connection load-balancing?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)