Answer / Digvijay Pratap Singh

When securing an SQL Server, follow these best practices:
1. Set up strong authentication methods such as Windows Authentication and SQL Server Authentication.
2. Create and manage roles and permissions to control access to the database objects.
3. Use encryption for sensitive data at rest and in transit.
4. Implement auditing and monitoring to track user activity and detect potential threats.
5. Apply patches and updates regularly to address known vulnerabilities.

Tell me can we use custom code in ssrs?

1 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

select names starts with a,b,c

8 Answers   Scope International,

---

What authentication modes does sql server support?

1 Answers  

---

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

1 Answers   HCL,

---

Explain the various types of concurrency problem?

1 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---

How do you know which index a table is using?

4 Answers  

---

What are Row versions of DataRow?

1 Answers  

---

Do you know what is openxml in sql server?

1 Answers  

---

When I run the sql server 2000 setup, it just hangs. What do I do?

1 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

1 Answers  

---