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.
Sorry, there are no downloads available for this session.
Ajay works as Senior SQL Server DBA in London, at Morgan Stanley, one of the leading Investment Banks. He has been at Morgan Stanley for four years now and he is a Microsoft Certified Master (MCM) in SQL Server.
He is a 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.
Prior to joining Morgan Stanley, Ajay worked for 3 years as a SQL Server DBA at Bank of America, where he joined on the graduate program in 2007. He was placed in the SQL Server DBA team and from that point, he started to develop a real passion and interest for SQL Server.
He has experience with all the SQL Server versions from 2000 to 2012 and some areas which he is really interested in are SQL Server optimization, performance and tuning, automation and database maintenance. While pursuing, the SQL Server 2008 MCM certification, Ajay also achieved the Microsoft Certified Solutions Expert (MCSE) – Data Platform certification.
Ajay is originally from Mauritius and came to the UK to study at City University, London. He graduated with a First Class Honours degree in BEng. Computer Systems Engineering.
The video is not available to view online.