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.

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

---

application server is slow what may be the problem

0 Answers   Microsoft,

---

Explain nested join?

0 Answers  

---

How can you list all the columns in a database?

0 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

---

If no size is defined while creating the database, what size will the database have?

0 Answers  

---

Why use “nolock” in sql server?

0 Answers  

---

Mention the 3 ways to get a count of the number of records in a table.

0 Answers  

---

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

---

What is exclusive locks?

0 Answers  

---

What are the source of constraints?

0 Answers  

---

What are system databases into sql server (2005/2008) : sql server database administration

0 Answers  

---