Tag Archives: SQL Server

Sept 2013 ~ Stacia Misner ~ Taking BI to the Next Level: Collaboration

Posted on August 26, 2013 by

Presenter: Stacia Misner Topic: Taking BI to the Next Level: Collaboration Self-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work … Continue reading →

Posted in Meetings | Tagged , , , | Comments Off on Sept 2013 ~ Stacia Misner ~ Taking BI to the Next Level: Collaboration

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

Posted on November 3, 2012 by

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

Posted on November 3, 2012 by

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

Mar 2013 ~ Why is an SSIS Framework important? ~ James Phillips

Posted on November 2, 2012 by

FREE! Query Optimizer eBook and SQL Prompt trial This free ebook from Red Gate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the … Continue reading →

Posted in Meetings | Tagged , , , | Comments Off on Mar 2013 ~ Why is an SSIS Framework important? ~ James Phillips

Feb 2013 ~ Windowing Functions and SQL Server ~ Christina Leo

Posted on November 2, 2012 by

Presenter: Christina Leo Topic: Windowing Functions and SQL Server Biography: Christina has worked with various database platforms since 1994. She has earned her MCITP Developer/Adminstrator for SQL Sever 2005. Christina currently works with a small team of database developers and … Continue reading →

Posted in Meetings | Tagged , | Comments Off on Feb 2013 ~ Windowing Functions and SQL Server ~ Christina Leo

Dec 2012 ~ Lightning talk ~ Various Members

Posted on October 27, 2012 by

  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

Posted on October 1, 2012 by

  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

Posted on August 1, 2012 by

  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

July 2012 ~ Introduction to Extended Events ~ Brandon Leach

Posted on July 1, 2012 by

 Presenter: Brandon Leach Topic: Introduction to Extended Events   Profiler is a clunky old tool. In this session we will take a look at Extended Events in SQL Server 2008 and 2012. We’ll start by discussing the various components and … Continue reading →

Posted in Meetings | Tagged , , , | Comments Off on July 2012 ~ Introduction to Extended Events ~ Brandon Leach

June 2012 ~ Full Text Indexing Basics ~ John Miner

Posted on June 1, 2012 by

  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