30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

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. 
        

Speaker focus

Satya Jayanty

DSC00193.JPG
Knowledge is the power and you will gain by sharing it;
Subject Matter Expert, Consulting & technical expertise for Databases, Business Intelligence & Architecture solutions. Working as Solutions Architect & Consultant for database solutions with over 18+ years of experience in Software Engineering and Database applications using industry famous technologies & software, having awarded MVP since the year 2006. Active member, Contributing Editor & Moderator for MSDN and other popular SQL Server related forums, in addition to regular participation as a Speaker & Subject-Matter-Expert in the major events such as Microsoft Tech-Ed, SQLBits, SQLPASS and other European based conferences. Founder & Writer of www.sqlserver-qa.net [knowledge sharing network] and writer for sqlblogcasts.com/blogs/ssqanet/default.aspx site.

Satya Jayanty's blog http://sqlserver-qa.net/blogs/Bloggers.aspx



Downloads

File Type Ext ContentName
Zip File .zip Slides & Demos
<< 1 >> 

Other sessions from this conference

Denormalisation –having your cake and eating it.
Design patterns for SSIS Performance
Designing and Tuning high speed data loading
Event Driven Cube Performance and Security Monitoring
Fast Track Foundations: Get Serious about Sequential I/O
Getting Started with SQL Azure
High Availability in the Real World!
High performance functions
Improving Database Performance by Removing the Database
Inside the SQL Server Query Optimizer
Introduction to Performance Tuning Analysis Services 2008
Lessons Learned from 128 Core OLTP Testing
Monitoring and Tuning Parallel Query Execution
Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory
Optimizing tempdb and temporary object use
Performance Management for SQL Server with SCOM 2007
Performance Monitoring & Tuning - Documented Tips & Tricks
Performance Troubleshooting made easy with PAL
Photograph: SQL Server Crash Dump Analysis
Scaleout scenarios with Service Broker
SQL Server 2008 Reporting Services Scalability and Performance
Supercharge MDX performance using MDX Studio
Transaction Log Performance Tuning, Stop shouting Timber!