Make your DBA life better using SQL Server technologies - notes from field & best practices
This session details a typical DBA's day demonstrating the new improvements of the Management Platform & Performance monitoring made for Microsoft SQL Server 2008.
We will concentrate on how best you can make use of tools (pre-installed) of Microsoft, as they pertain to efficient systems management, multi-server management, performance tracking, and policy implementation. Take advantages of detection and enforcement of security policies & design practices in your database environment using both graphical and command-line tools. We cover everything from the new Management interface in SQL Server and Management Data Warehouse that also have a practical demonstration of PowerShell integration in SQL Server administration tasks, not to mention about best practices.
Knowledge is the power and you will gain by sharing it;
SQL Server MVP and Subject Matter Expert with consulting & technical expertise for Databases, Business Intelligence & Architecture solutions with over 19+ years of experience. My work experience inclduesa wide range of industries, including the stock exchange, insurance, tele-communications, financial, retail, and manufacturing sectors, among others.
A regular Speaker and SME volunteer at major technology conferences such as Microsoft Tech-Ed (Europe, India and North America), SQL PASS (Europe and North America), SQL Bits – UK and manages Scottish Area SQL Server user group based in Scotland. A moderator in majority of web based SQL Server forums (Microsoft Technet & www.sql-server-performance.com), writer, contributing editor & blogs at www.sqlserver-qa.net, www.sql-server-performance.com and www.beyondrelational.com websites.
Author of Microsoft SQL Server 2008 R2 Administration cookbook (released May 2011) - www.packtpub.com
Author - Microsoft SQL Server 2012 Analysis Services Cube Security How-to - www.packtpub.com
Co-Author of MVP Deep Dives SQL Server Volume II from Manning Publications.