Answer Posted / 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

Which autogrowth database setting is good? : sql server DBA

1242

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2028

---

what are the benefits of flashback feature?

1092

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2016

---

What are the different types of indexes available in sql server? : sql server DBA

1266

---

How can you control the amount of free space in your index pages? : sql server DBA

1383

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2094

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2458

---

Why does Oracle not permit the use of PCTUSED with indexes?

3016

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1266

---

What authentication modes does sql server support? : sql server DBA

1265

---

Can you redefine a table online?

1156

---

what are the types of connection load-balancing?

1046

---

Explain materialized views and how they are used.

2498

---

how can you process messages in order asynchronously?

1037

---