explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
- 1 Answers
- 1184 Views
- I also Faced
- E-Mail Answers
Answer Posted / Mohd Kasif
Securing SQL Server involves several steps: (1) Setting up strong authentication and authorization, including using Windows Authentication when possible. (2) Implementing database roles and permissions to control access to sensitive data. (3) Using auditing and monitoring tools to track activity within the database. (4) Enabling encryption for sensitive data. (5) Regularly updating the server with service packs and security patches.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we shrink data file in sql server?
What is a view in sql?
How do I create a trace in sql server?
what is spatial nonclustered index
What are the different subsets of sql?
How efficient you are in oracle and SQL server?
What is a coalesce function?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How to connect php with different port numbers?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Why use identity in sql server?
What is an indexed view?
What is temporary table in sql server? Why we use temp table?
What are the different types of subquery?
List the ways in which dynamic sql can be executed?
