Checklist, Scripts and Reports for a SQL Server Security Audit

HexaTier sponsored on-demand webinar

Webcast Abstract

Don’t become a statistic. With the numerous data breaches and internal data theft, securing your SQL Server environment can help keep your company out of the news. Unfortunately, a single SQL Server configuration, coding technique or operational practice in your environment can put you at risk. Now is the time to be proactive for your own peace of mind or prepare for your organization’s next formal SQL Server audit. This session will provide key scripts and reports to build your SQL Server auditing checklist.

In this session you will learn about the following topics:

  • Permissions - Elevated permissions for logins at the instance and database level
  • Logins - Creation and modification of logins as well as failed login attempts
  • Operations - Out of cycle backups, phantom SQL Server Agent Jobs and changes to standard operating procedures that should raise the red flag
  • Configurations - Whether it is xp_cmdshell, Linked Servers or password policy changes, these need to be recorded
  • Code Changes - Code changes sneaking into production would never happen, so be able to prove it
  • Data Auditing - With awareness for confidential data rising, report on who accessed and when
  • and more
Don’t miss this demo centric session and also see how you can take your auditing to the next level with a solution from GreenSQL.

Speaker - K. Brian Kelley and David Maman

K. Brian Kelley is a SQL Server author, columnist and Microsoft MVP focusing primarily on SQL Server and Windows security. In addition to being a DBA, Brian is also a Certified Information Systems Auditor (CISA).

David Maman is a recognized international expert in computer security advising companies on threat management, real-time network protection, advanced network design, and security architecture. In addition to his degrees in computer science, David confesses to being heavily self-taught—a quality that has served him well in this highly dynamic industry.

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.




get free sql tips
agree to terms