Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email Thank you for your patience.

Las Cruces & El Paso SQL Server Users Group

We will update meetings with slides and attachments as the presenters make them available.

Next Meeting




LCEP PASS June 2014 Chapter Meeting & Presentation "Refactoring T-SQL with Windowing Functions"

  • In-Person @ 700 N Main Las Cruces, New Mexico, United States (map)
  • 00:00 - 13:00 Mountain Daylight Time
  • Language: English

Recorded Presentation "Refactoring T-SQL with Windowing Functions"

Chapter Meeting, Pizza, Refreshments, Meet and Greet, Presentation (at 12:00) Discussion and Prizes.  (New Larger Room)

Find us on the web at HTTP://LCEP.SQLPASS.ORG

Email us at

Follow us at @LCEPPASS

Join the Professional Association of SQL Server  (PASS) at HTTP://WWW.SQLPASS.ORG

Help us out and click on the RSVP URL so we know how much Pizza and Drinks we should buy!

Visit LCEP SSUG Sponsors!

Red Gate – All sorts of great SQL Server Tools

Plural Sight – Excellent Online Training. Check them out, we’ve watched some of their sessions on Team Foundations Server and they were very useful.

O’Reilly – User group members save 40% off print and 50% off ebooks.  Discount Code:DSUG

Featured Presentation:

Surveying Your SQL Server Environment using CMS, SQL PowerDoc, EPBM & SQLBlitz

Sergio Pacheco, Database Administrator Mesilla Valley Transportation

To be a proactive DBA you must be thoroughly familiar with your SQL Server environment. A detailed survey can be a tedious and time-consuming process. Identifying issues and quantifying their potential severity even more so. Get a detailed, comprehensive view of the SQL Server configuration of your entire enterprise using SQL Server's built-in functionality, a little Powershell and some free tools. Out-of-the-box or with some tuning, quickly rank and begin to address problems, compliance issues and best practice violations.

About Sergio:
Sergio Pacheco is currently the Database Administrator for Mesilla Valley Transportation. Sergio has been in the IT field for about 15 years during which he has worked as a Database Administrator, Systems Admin, Network Admin and Consultant. He is passionate about SQL and IT in general. He enjoys sharing what he has learned with others and makes a mean Cochinita Pibil!

Refactoring T-SQL with Windowing Functions

Doug Lane SQL Theater

You’ve been querying comparative numbers like Year To Date and Same Period Last Year by using tedious CTEs and sub-queries. Beginning with SQL Server 2012, getting these numbers is easier than ever! Join Doug for a 30-minute T-SQL tune-up using window functions that will cut down dramatically on the amount of code you need to write.

About Doug:
Doug Lane is the founder of SQL Theater, a company specializing in helping junior developers and public speakers. Doug has over 15 years' experience in IT and holds a Bachelor of Arts degree in Media Production. In addition to presenting at conferences, SQL Saturdays, and user group meetings, Doug also blogs and produces video training courses.


Meeting Archive

Back to Top