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 |
Define compound operators?
Can we write ddl in trigger?
How to create new tables with "select ... Into" statements in ms sql server?
Explain the benefits of user-defined functions?
What are the dmvs? : sql server database administration
How do you test your database? : sql server database administration
What is the return type of executeupdate ()?
what are user defined datatypes? : Sql server database administration
What is a non equi join?
Where is trigger in sql server?
How to download and install microsoft .net framework version 2.0?
What is openxml in sql server?
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)