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

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

what is a user-defined lock?

0 Answers   Oracle,

---

Explain the concept of the DUAL table.

3 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---