In today's IT landscape, we are faced with meeting an ever increasing number of laws, regulations, and industry standards. The good news is that the majority of these different requirements overlap with each other and we can configure our SQL Servers accordingly. In this webinar we'll take a look at those standard configuration settings you should be setting in your environments as well as what you'll be auditing for in order to meet all of your compliance criteria. We will start with the recommended security "good" practices for managing identity and permissions. From there we will move on how to audit SQL Server, both with security changes and actual activity. There may be specific items you need to account for and we'll walk though how to set those up within SQL Server. Finally, we'll briefly discuss what it would take to deploy this across your entire environment, especially using the functionality provided out of the box by Microsoft and with tools like PowerShell.
K. Brian Kelley is an author, columnist, and former Microsoft SQL Server MVP focusing primarily on SQL Server and Windows security. In addition to being a database administrator, he has served as an infrastructure and security architect encompassing solutions with Citrix, virtualization, and Active Directory. Brian is also a Certified Information Systems Auditor (CISA) and has been the head of a financial organization’s computer incident response team. Brian is active in the IT community having spoken at DevConnections, SQL Saturdays, code camps, and user groups.
Topics: Database Monitoring, Database Compliance, Database Diagnostics Products: SQL Compliance Manager