CACTUSS

Capital Area Central Texas User of SQL Server

PASS affiliated user group for Austin, TX

Contact us: Email: CACTUSS.SQL (at) (gmail) (dot) (com)
Twitter:@CACTUSS_SQL
LinkedIn:https://www.linkedin.com/groups/149440
Meetup:https://www.meetup.com/Austin-SQL-Server-User-Group/

Upcoming Meeting Dates

  North South
Mar
2017
Tue 3/21/2017
Speaker: Yell McGuyer
Topic: Our experience with nonclustered columnstore indexes
Mon 3/20/2017
Speaker: OPEN
Topic: Submit your own presentation to give
Apr
2017
Tue 4/18/2017
Speaker: David Williams
Topic: SQL Server on Linux
Mon 4/17/2017
Speaker: David Williams
Topic: SQL Server on Linux
May
2017
Tue 5/16/2017
Speaker: Chris Hyde
Topic: SQL Server R Services in SQL 2016
Mon 5/15/2017
Speaker: Chris Hyde
Topic: SQL Server R Services in SQL 2016
Jun
2017
Tue 6/20/2017
Speaker: Jay Falck
Topic: BCP and Format Files
Mon 6/19/2017
Speaker: Jay Falck
Topic: BCP and Format Files
Jul
2017
Tue 7/18/2017
Speaker: OPEN
Topic: Submit your own presentation to give
Mon 7/17/2017
Speaker: OPEN
Topic: Submit your own presentation to give

 


Meeting Locations

CACTUSS North

  • Meeting dates: 3rd Tuesday of the month
  • Meeting starts: 6:00 pm with food and a QA session
  • Presentation: 6:30 pm and goes to 7:30 pm
  • Address
    • Quarry Oaks II - Microsoft Office
    • 10900 Stonelake Blvd., Suite 225
    • Austin, TX 78759
      • * Free parking
      • * Coming from Braker, go right/straight at the traffic circle and it's the building on the left.
      • * The building is also across from the outdoor basketball court
      • * Not the building attached to the parking garage
      • * Inside the Microsoft office, go right, past the reception desk, to the far back and left
      • * If there is interest, there is sometimes an after-gathering at a local place to talk casually
    • Map: http://binged.it/1HOSMWm

CACTUSS South

  • Meeting dates: 3rd Monday of the month
  • Meeting starts: 5:30 pm with food and a QA session
  • Presentation: 6:00 pm and goes to just after 7:00 pm
  • Address
    • SQLWatchmen Office
    • Suite 209
    • 1524 S IH-35
    • Austin, TX, 78704
      • * Free parking
      • * South bound side
      • * From north of Riverside, use the Woodland exit
      • * From south of Riverside, use the Riverside exit and turn around (it's a long traffic light)
      • * Wooden bridge in the middle of the L shape is the closest entrance
  • Map: http://binged.it/2kMuQQ8
 

Next Meeting

Tuesday,

June

20

NORTH
BCP and Format Files
Jay Falck

10900 Stonelake Blvd. Suite 225 - Microsoft Office
Austin, Texas 78759
Time: 18:00 - 19:30

Title: BCP and Format Files
by: Jay Falck

Summary:

Do you still use BCP instead of SSIS for staging table loads? Do you have clients that won't or can't stay current with changes to your staging schema? BCP Format files can help.

What we'll cover:
1. What is a format file and how is it used?
2. What are the "gotchas"?
3. Automatic creation of format files using Perl.
4. Automatic creation of format files using Python.
5. Automatic creation of format files using PowerShell.
6. Demos

Speaker: Jay Falck:
Bio: I started as a night shift computer operator out of high school. I moved to applications development after graduation from SAC. After a few years with the State as an applications developer, the manager of Systems Programming decided it would be better to have me on the inside looking out rather than on the outside trying to get in. I spent the next 14 years as a mainframe system programmer for two state agencies. In 1996 I moved to Healthcare IT and have been that ever since. I've spent most of the past 14 years doing ETL, performance and HIPAA security. In these various jobs, I've used all manner of databases including InfoTec IMP, IBM VSAM and DB2, Interbase, Informix, Universe, Oracle 9i and SQL Server from 6.0 to 2008 R2.

Special Notes:

 

Available Attachments: