What are the steps you will take, if you are tasked with
securing an SQL Server?
Answer / swapna
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.
| Is This Answer Correct ? | 4 Yes | 0 No |
What happens if you add a new index to large table?
How to get a list all databases on the sql server?
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
What is a sql join?
What is a virtual table in sql?
Explain what is the function of sql server agent windows service?
What is a transaction and what are ACID properties?
14 Answers Config Systems, IBM, TCS, Virtusa,
What are the differences between local and global temporary tables?
Differencr Between DELETE and TRUNCATE?
What are the advantages of passing name-value pairs as parameters?
what are the problems in logshipping?
Is sql server is free?
Oracle (3259)
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)