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 |
How to Get the last identity value used
What are truncate options available in sql server? : sql server database administration
Write a SQL command to insert and update only a particular field?
Where sql server usernames and passwords are stored in a sql server?
What is schemabinding a view?
Explain what are commit and rollback in sql?
What are the purposes of floor and sign functions?
How can u get the number of pupils connecting the database?
What are views in ms sql server?
What are the different authentication modes in sql server?
How to add additional conditions in SQL?
Why we need a group by clause?
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)