Las Cruces & El Paso SQL Server Users Group

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

Next Meeting

Thursday,

February

12

LCEP SSUG Feb 2015 Meeting " Auditing Database DDL Changes with SQLVer " with Sergio Pacheco

  • In-Person @ 1625 Hawkins Blvd. El Paso, TX El Paso, Texas, United States (map)
  • 12:00 - 13:00 (UTC-07:00) Mountain Time (US & Canada)
  • Language: English

The Las Cruces-El Paso SQL Server User Group (LCEP) will be having its next meeting, Thursday 02/12/14 from 12:00 PM - 1:00 PM at the New “New Horizons Center” at 1625 Hawkins Blvd. El Paso, TX 79925 Sergio Pacheco will be sharing his knowledge.  Join us for his presentation “Auditing Database DDL Changes with SQLVer”, and learn how you can track changes to your databases, roll them back, ID slow stored procedures and SQL connections, receive alerts and more.  Ask Sergio questions, get to know your peers, may be win a prize and have lunch on us!

 

Attend this FREE SQL training event!

RSVP and be eligible to win a “60 day Plural Sight Subscription”

 

Sign up for your free PASS membership at: http://www.sqlpass.org/ 

LCEP SSUG SPONSORS 

New HorizonsThe IT Training Leader: New Horizons El Paso delivers a full range of technology and business skills training

Red Gate - Simple tools for DBA's & developers.  The Leader for SQL and .NET tools.  If you haven't already

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:

Auditing Database DDL Changes with SQLVer

Sergio Pacheco, DBA Mesilla Valley Transportation

SQLVer is a useful tool by David Rueter for tracking changes to database objects. Ideally all changes to database structures would be done via a source control system. However there are several issues with this in a real world production environment. Not every database is managed by source control (i.e. vendor databases). Source control systems can be difficult to manage and auditing info is not easily exposed to management. DDL (data definition language) events such as adding or dropping indexes, altering stored procedures, disabling triggers etc. sometimes must be done on the fly. While SQL Developers and DBA’s are typically teammates and will generally keep each other informed when this happens, when things get busy our memory tends to lose fidelity. Going back and updating source code to reflect every change may not be feasible. If you come in on Monday and users suddenly begin complaining of slow performance, it can be very difficult to identify what changed much less by who. SQLVer is a lightweight solution that addresses these issues and more. I have extended it to log more information, log the information in a central admin table and configured alerts to inform me of changes as they happen. As a DBA I consider it a vital addition to your toolkit.

About Sergio:
Sergio Pacheco is Database Administrator for Mesilla Valley Transportation Company in Las Cruces NM (6/14 to present). Previously he was DBA for the City of Las Cruces, NM (8/12-6/14). and the System Administrator for Midwest-Textile Co. (1999-2012). He began his SQL server career as an "Accidental DBA" in 2005 when he was assigned to administer a small application called SAP. In the process of rising to the challenge he became a SQL Server 2005 MCITP. He currently is the Chapter Leader for the Las Cruces - El Paso SQL Server User Group. He enjoys problem solving, implementing database dreams for Dev's, inducing eye rolls from SAN Admins, architecting database solutions, vexing Vendors, swimming competitively, confounding Consultants, biking mountains and makes a mean Cochinita Pibil

Supplementary Materials

The following event attachments are available to you:

EventArchive

Meeting Archive

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids