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 |
syntex of insert
What is the use of custom fields in report?
Explain the disadvantages/limitation of the cursor?
What is the difference between a primary key and a unique key? Are they the same?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is the difference between osql and query analyzer?
What is outer join in sql server joins?
What is 2nf in normalization?
What samples and sample databases are provided by microsoft?
What does it mean to invest in the index?
How to execute a sql statement using odbc_exec()?
What is a mutating table error and how can you get around it?
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)