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 |
Tell me what is sql profiler?
What are the advantages of using a stored procedure?
What are the tables in sql?
Explain contrast amongst grouped and non-bunched records?
what is denormalization? : Sql server database administration
What is a data source or ds? : sql server analysis services, ssas
How do you open a cluster administrator?
What is the difference between row_number and dense_rank?
What is user-defined scalar function?
When would you use a before or after trigger?
What is the difference between left and right outer join?
SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES
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)