Tag Archives: Developer

May 2013 ~ SQL Server Development and Administration Tips and Tricks ~ Roman Rehak

Presenter: Roman Rehak Topic: SQL Server Development and Administration Tips and Tricks Downloads: Presentation Materials (.zip) This presentation will cover many common issues, challenges and problems encountered when developing for, or administering SQL Server as well as examining best ways … Continue reading

Posted in Meetings | Tagged , , , , , | Comments Off on May 2013 ~ SQL Server Development and Administration Tips and Tricks ~ Roman Rehak

Apr 2013 ~ SSIS Best Practices, Tips and Techniques ~ Bryan Cafferky

Presenter: Bryan Cafferky Topic: SSIS Best Practices, Tips and Techniques Downloads: SSIS Presentation (.zip) Join us for this presentation on the best practices, tips and techniques of leveraging SSIS. Learn how to load any external file confidently and easily, how … Continue reading

Posted in Meetings | Tagged , , , , , | Comments Off on Apr 2013 ~ SSIS Best Practices, Tips and Techniques ~ Bryan Cafferky

Dec 2012 ~ Lightning talk ~ Various Members

  The December 2012 meeting will be devoted to developing new talent within the group. We will have several slots open for short fifteen to twenty minute talks on a Microsoft SQL Server topic of your choosing.   We will … Continue reading

Posted in Meetings | Tagged , , , | Comments Off on Dec 2012 ~ Lightning talk ~ Various Members

Oct 2012 ~ Effective Use Of Temporary Tables ~ John Miner

  Presenter: John Miner Topic: Effective Use Of Temporary Tables Downloads: Slides   Every developer eventually comes against business logic that can not be handled with a single simple or complex query. TSQL provides the developer with several constructs that … Continue reading

Posted in Meetings | Tagged , , , , , , | Comments Off on Oct 2012 ~ Effective Use Of Temporary Tables ~ John Miner

Aug 2012 ~ Bad Habits and Best Practices ~ Aaron Bertrand

  Presenter: Aaron Bertrand Topic: Bad Habits and Best Practices Downloads:Slides   In this session we will go over several bad habits that are quite pervasive in the SQL Server community, and show with demos and samples why these habits … Continue reading

Posted in Meetings | Tagged , , , , | Comments Off on Aug 2012 ~ Bad Habits and Best Practices ~ Aaron Bertrand

June 2012 ~ Full Text Indexing Basics ~ John Miner

  Presenter: John Miner Topic: Full Text Indexing Basics Downloads: Slides   Today’s large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the … Continue reading

Posted in Meetings | Tagged , , , , , , , , , | Comments Off on June 2012 ~ Full Text Indexing Basics ~ John Miner

May 2012 ~ On beyond Zebra AdventureWorks OR where did I go wrong? ~ Steve Simon

  Presenter: Steve Simon Topic: On beyond Zebra AdventureWorks OR where did I go wrong? Downloads: http://tinyurl.com/talkz Mentioned Link: Parameter Sniffing     No matter how well planned and executed, the data structures of any data warehouse oft times eventually … Continue reading

Posted in Meetings | Tagged , , , , , | Comments Off on May 2012 ~ On beyond Zebra AdventureWorks OR where did I go wrong? ~ Steve Simon

Apr 2012 ~ Aviation Disasters & IT Lessons From Them ~ Mike Walsh

  Presenter: Mike Walsh Topic: Aviation Disasters & IT Lessons From Them Downloads: Slides   What does a plane crash have to do with technical skills? You might be surprised. There are many lessons to be learned from disasters. Most … Continue reading

Posted in Meetings | Tagged , , , , | Comments Off on Apr 2012 ~ Aviation Disasters & IT Lessons From Them ~ Mike Walsh

Mar 2012 ~ T-SQL Deployment and Continuous Integration ~ Grant Fritchey

  Presenter: Grant Fritchey Topic: T-SQL Deployment and Continuous Integration Downloads: Slides   While most T-SQL developers focus on writing quality T-SQL code and efficient queries, what they often forget is how it should best be deployed. This includes deployment … Continue reading

Posted in Meetings | Tagged , , , , , , | Comments Off on Mar 2012 ~ T-SQL Deployment and Continuous Integration ~ Grant Fritchey

Sep 2011 ~ How to audit and prevent unwanted user actions ~ John Miner

  Presenter: John Miner of Sensata Technologies Topic: How to audit and prevent unwanted user actions   Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, … Continue reading

Posted in Meetings | Tagged , , , , , , , | Comments Off on Sep 2011 ~ How to audit and prevent unwanted user actions ~ John Miner