Skip Ribbon Commands
Skip to main content

Title

SQL Admin Best Practices with DMV's

Abstract

In this practical and script-focused session, we'll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV's are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up.

Speaker(s)

William Assaf

Company

Sparkhound

Bio

William Assaf is a senior database developer and team lead at Sparkhound Inc. in Baton Rouge, LA. He started off as a .net developer and moved into database administration and architecture, and has been lead db designer on major application and DW projects in the private and public sectors since 2006. He blogs about SQL at sqltact.com, where his slidedeck and sample scripts will be posted. He's organizing SQL Saturday Baton Rouge in August and is President of the Baton Rouge SQL Server User Group.

Session

1

Track

SQL Server

Time

9:30-10:30

Room

Room 303

Attachments

Content Type: Item
Created at 7/26/2013 8:50 AM by Richard
Last modified at 9/10/2013 8:39 AM by Richard
Houston TechFest 2012
Design by Expert Point Solutions Expert Point Solutions