Answer / Manas Mishra

"SQL Server offers various features to address scalability, availability, integration with the internet, and other considerations. These include:
1. Scalability: SQL Server supports high-performance computing through parallel processing, partitioning, and in-memory technologies like Memory Optimized Tables and Columnstore Indexes.
2. Availability: Features such as AlwaysOn Availability Groups, Database Mirroring, and log shipping help ensure database availability and recoverability.
3. Integration with the Internet: SQL Server can be integrated with the internet through services like SQL Server Reporting Services (SSRS), Analysis Services (SSAS), and Integration Services (SSIS).
4. Security: SQL Server offers robust security features, such as encryption, auditing, role-based access control (RBAC), and Active Directory integration to protect your data and applications."

How to get a list of columns in a view using the "sp_columns" stored procedure?

1 Answers  

---

What are the steps you must follow to hide sql server instances?

1 Answers  

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

What is difference between sql and sql server?

1 Answers  

---

What are the different types of locks in the database?

1 Answers  

---

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---

What is sql injection? How to protect against sql injection attack?

1 Answers  

---

What is database architecture? : SQL Server Architecture

1 Answers  

---

Explain magic tables in sql server?

1 Answers  

---

what's the maximum size of a row? : Sql server database administration

1 Answers  

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

Difference between drill down and drill through report.

1 Answers  

---