Ajay is a Microsoft Certified Master (MCM) in SQL Server. He works as Senior SQL Server DBA/Engineer in London, at Morgan Stanley, one of the leading Investment Banks. Ajay also achieved the Microsoft Certified Solutions Expert (MCSE) - Data Platform certification.
Ajay is really passionate about SQL Server and has about 9 years of experience working with all the SQL Server versions from 2000 to 2014 (and been evaluating 2016 CTP). Some areas which he is really interested in are SQL Server optimization, performance and tuning, automation and database maintenance.
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 the SQL Server Engineering subgroup lead, he is responsible for:
- SQL Server Infrastructure design and build
- SQL Server Proof of Concepts and New Version adoption and rollout
- Designing and developing scripts (Powershell and TSQL) to improve the efficiency of the Team
- Developing scripts to further enhance the self-service suite for users and extending reporting and automation capabilities, for SQL Server.
Come to learn how to implement solutions to prevent undesirable settings creeping in your SQL Server environment. To accomplish this, we will look Policy Based Management with Central Management Servers, SQL Server Audits and DDL Triggers.