To finish up the month of April we’ve got sessions from AppDev and DBA and I’m even including one from PASS on ‘Intro to Speaking At PASS’. The AppDev group will be hosting the SARGability session twice, once for people having Lunch in Australia or Dinner in L.A. and once as a Late lunch for people in the UK (*I think).
Understanding SARGability (to make your queries run faster)
April 27th 12:30 PM Adelaide, AUS CST (GMT +9:30) [April 26th at 8:00 PM PDT (GMT -7)]
Add to Calendar (AUS)
April 27th 8:00 AM EDT (GMT -4)
Add to Calendar
Presenter: Rob Farley
SARGable means Search ARGument able. It relates to the ability to search through an index for a value, but unfortunately, many database professionals don’t really understand it. This can lead to queries which miss out on the potential to run much quicker. This is a talk involving lots of demos, showing plenty of queries and execution plans. Any time I’m not typing on the screen, I’ll be waving my hands around to explain things, with apologies to those tuned in through Live Meeting.
Rob Farley runs LobsterPot Solutions, a consultancy based in Adelaide, Australia. He has been consulting in IT since completing a Computer Science degree with first class honours in 1997 and using SQL Server since 1998. He is a regular presenter at conferences such as TechEd Australia, heads up the Adelaide SQL Server User Group and holds many Microsoft certifications. He is a Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server. Rob has also helped create several exams for Microsoft Learning, and has recently written two chapters for the book SQL Server MVP Deep Dives. Rob’s blog can be read at http://sqlblog.com/blogs/rob_farley/
How do I view the presentation?
Attendee URL (AUS): Live Meeting link
Attendee URL: Live Meeting Link
SQL Server 2008 Audit
April 28, Noon Eastern Time (GMT -4)
Presenter: Thomas LaRock
With SQL Server 2008 you now have the ability to set up auditing with SQL Server Audit. Attend this session for an overview of SQL Server Audit, learn how to initially configure an audit for your server or databases, and examine the audit logs to report on the information that is captured.
Thomas LaRock is a seasoned IT professional with over a decade of technical and management experience. Thomas is a member of Quest Software’s Association of SQL Server Experts, currently serves on the Board of Directors for the Professional Association for SQL Server (PASS), and is a SQL Server MVP. Thomas can also be found blogging at http://thomaslarock.com and is the author of DBA Survivor: Become a Rock Star DBA.
Door Prize: There will be a drawing for a $50.00 Amazon Gift Certificate
Registration: You can attend the meeting without registering but if you want to be entered in the drawing, you must register at https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=fmxpl8tdzwcrc6z0 no later than 5:00 PM Eastern on April 27th.
Live Meeting Link: https://www.livemeeting.com/cc/8000181573/join?id=6K8GPR&role=attend
Intro to Speaking At PASS: Creating a Winning Abstract (If I Can Do It, Anyone Can!)
April 28, Noon Central Time (GMT -5)
Presenter: Chuck Heinzelman
Have you ever attended a conference (such as PASS) and thought to yourself, “Wow, I wish I could speak at something like this!” Speaking at a conference like PASS is not something reserved for the superstar speakers. Each year PASS actively calls out for presentation proposals from members of the SQL Server community. During this session we’ll talk about what goes into creating a submission for the call for speakers with the goal of reducing the fear and anxiety that can go along with the process.
Coming in May…
Stuart Ainsworth presents “You Got XML In My Database? What’s Up With That?”
Patrick LeBlanc presents “Introduction to SQL Server Profiler”