This week at the PASS Community Summit in Seattle, I’m delivering two full length sessions, one lightening session, and chairing a committee meeting to discuss the election process. If you’re attending the conference, I hope you’ll join me at one of these sessions.

Using Covering Indexes (Wed 1:30pm)

Covering indexes can dramatically reduce disk i/o and improve performance. In this 5-minute Lightening Session, I’ll show you how you can make better use of your nonclustered indexes and reduce Key Lookups.

Conducting Effective Meetings (Wed 3:00pm )

Ever been in a meeting that drones on and on? It starts late, runs long, and doesn’t really accomplish anything. It’s a complete waste of everyone’s time. Worse yet, since nothing was resolved you’ll have to have a follow up meeting. Argh! In this session you’ll learn some of the keys to conducting an effective meeting. You’ll gain practical tips for making your meetings more productive and dramatically improving one of the most inefficient parts of your day.

PASS Election Review Committee Community Meeting (Wed 4:30pm)

The PASS Election Review Committee will host a community feedback session to discuss the PASS election procedures. We’d like your input as we strive to improve the selection of the future leaders of PASS.

The PowerShell CookBook for the DBA (Thurs 1:00pm)

The best DBAs work hard so that they don’t have to, well, work hard. In this session, we’ll discuss how you can use the PowerShell cmdlets and snap-ins to create scripts that automate the more mundane tasks in your role as a DBA or developer. We’ll create scripts that check the status of SQLAgent jobs, verify the configuration of your servers, and retrieve information from your SQL Server database. You can even store your results in a database table if you’d like. This session is mostly demos with only a few PowerPoint slides to get us started.

If you’re in Seattle, be sure to stop by and say hi at any of these sessions or in the hallways. I’m always up for good cup of coffee.

Filed under: Community, Events, SQLServerPedia Syndication