Prevention is better than cure.

As DBAs, we have to manage a huge number of servers and deal with a high volumes of changes/releases and implement vendor products which need elevated levels of permission to run. As a result, all the control and scrutiny that we wish to exercise becomes hard and almost impossible.

Very often, this results in undesirable settings, sub-optimal setups or bad implementations creeping in our environment – all against best practices or our mandated guidelines.

Once they are in, it becomes extremely hard to fix or get rid of many of these issues and the reasons are wide ranging.

With this in mind, this session will explore ways for an administrator to implement solutions to prevent these issues from being introduced in the first place. Or if we cannot stop them, we should be notified about them as soon as they happen.

To accomplish this, we will look at Policy Based Management with Central Management Servers, SQL Server Audits and DDL Triggers.
Presented by Ajay Jadoo at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Ajay_Jadoo.JPG
    Ajay is a Microsoft Certified Master (MCM) in SQL Server. He works as Senior SQL Server DBA inLondon, at Morgan Stanley, one of the leading Investment Banks. While pursuing, the SQL Server 2008 MCM certification, Ajay also achieved the Microsoft Certified Solutions Expert (MCSE) Data Platform certification. He is the Lead SQL Server Subject Matter Expert/Product Specialist in the Global DBA Team. He is one the main points of escalations for troubleshooting complex SQL Server issues and provides guidance and advice to colleagues and users on various aspects of SQL Server and everything related to it. Moreover, as a leading member of the SQL Server Engineering subgroup, he is responsible for designing and developing TSQL stored procedures and PowerShell scripts to improve the efficiency of the Team by further enhancing the self-service suite for users and extending reporting and automation capabilities, for SQL Server.
    https://www.linkedin.com/in/ajayjadoo
  • Video
    The video is not available to view online.