What are the steps you will take, if you are tasked with
securing an SQL Server?
Answer / sandeep
Again this is another open ended question. Here are some
things you could talk about: 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.
Read the white paper on SQL Server security from Microsoft
website. Also check out My SQL Server security best practices
Is This Answer Correct ? | 3 Yes | 1 No |
how does an oracle clusterware manage crs resources?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the different ways of moving data or databases between servers and databases in SQL Server?
What is dcl? : sql server DBA
when does an alert gets signaled?
What is replication? : sql server DBA
by issuing "alter tablespace begin backup;" what happens to tablespace?
Which autogrowth database setting is good? : sql server DBA
Explain CREATE DATABASE syntax?
What does coalescing a tablespace do?
If we issue alter database begin backup. What happens to database?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA