SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

PASS Virtual Chapters Late April Presentations

By Aaron Nelson,

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 -4)]
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:

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:

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)

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.

Live Meeting Link: https://www.livemeeting.com/lrs/0000000379_116/Registration.aspx?pageName=nk4md836r0tzp94j

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"

Total article views: 435 | Views in the last 30 days: 1
Related Articles

Presenting To Columbus SQL Server User’s Group on April 14

I will be doing a live, virtual presentation for the Columbus, Ohio SQL Server User’s Group on Thurs...


Presenting Dr. DMV by Live Meeting on April 19 at 12PM CDT

I will be presenting my Dr. DMV presentation for the St. Louis SQL Server User’s Group on April 19...


Presenting at New England SQL Server Users Group April 11

I am proud to present an in-person presentation for the New England SQL Server Users Group entitled ...


SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)

On Aprill 2010 is available the SQL Server 2008 R2 Update for Developers Training Kit. This training...


Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012

Atlanta MDF presents: SQL Saturday #111 Pre-Conference Sessions SQL Saturday is coming back to...

sql server 2008