It's official – I've submitted my abstracts for the 2009 PASS Summit and received my confirmation. Now I wait to see if the abstract selection committee decides if I am worthy. As I promised in my interview with Brent Ozar, I'm publishing my submissions for all to see. If you happen to be at SQL Saturday Atlanta this weekend you can catch my presentations on Disk Performance and XML. If you're headed to SQL Saturday Jacksonville on May 2 I'm on the schedule to present all four.
Disk Performance and Configuration: How & Why
Would you buy a million dollar race car then show up to the track on a clear day with rain tires that aren't properly inflated and wonder why you're only doing 180 when the manufacturer says it can do 220? Let's suppose that your million dollar race car is really your DB server and your tires are your hard drives. Do you know the right configuration to use to get the best performance out of them? This session will examine the results of extensive testing to reveal how partition offset, RAID stripe size, allocation unit size, controller caching, and failed disks affect OLTP performance on local disks and disk arrays.
Session Goals:
- Identify optimal RAID stripe size, allocation unit size, and partition offset to use for OLTP data and log files
- Understand how failed drives impact OLTP performance
- Understand how controller caching impacts OLTP performance
<title>Working With XML in SQL Server</title>
XML in SQL 2000 wasn't very exciting and it was easy to dismiss it altogether by just relying on developers to handle any XML needed within the application. SQL 2005 changes the game and this session will show you how to use the XML data type, do basic operations on XML data, and showcase the changes to FOR XML that make it so much more useful. This isn't a session to convince you to use XML, but to show you what you can do with XML if you do need to use it!
Session Goals:
- Learn how to use the FOR XML PATH and WITH XMLNAMESPACES clauses
- Understand the use of the XML data type, XML schema collections, how to use XML DML to manipulate XML data, and how to use FLWOR to query XML data
- Learn how to create indexes on XML data
Transactional Replication: Beyond The Basics
At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.
Session Goals:
- Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, & agent profiles. Learn how to configure advanced options such as vertical and horizontal filtering
- Demonstrate how to monitor transactional replication performance
- Learn advanced troubleshooting techniques to apply when problems occur
Configuring Secure SQL Access for the Web Developer\Administrator
By now we all know that we should use Windows Authentication to connect to SQL Server from our IIS applications...but most of us don't know how. This session aims to clear up the confusion by demonstrating the ways that ASP & ASP.NET applications can be configured to make secure connections from different versions of IIS so that we can keep our connections secure and our DBAs happy.
Session Goals:
- Understand the concept of impersonation
- Learn how ASP and ASP.NET applications can be configured to use impersonation to make secure connections to SQL Server
- Learn how to configure IIS 5, 6, & 7 and Windows XP, 2003, and 2008 to support impersonation
