Tag Archives: DBA

Nov 2013 ~ How isolated are your sessions? ~ John Miner

Posted on November 1, 2013 by

  Presenter: John Miner Topic: How isolated are your sessions? Downloads: Available on CraftyDBA.com   Have you ever executed a TSQL program that crashed due to an integrity error? Upon inspecting the job history, the error code states you have … Continue reading →

Posted in Meetings | Tagged , | Comments Off on Nov 2013 ~ How isolated are your sessions? ~ John Miner

June 2013 ~ Using File Partitioning And Data Compression For An Effective Data Warehouse Solution ~ John Miner

Posted on November 4, 2012 by

  Presenter: John Miner Topic: Using File Partitioning And Data Compression For An Effective Data Warehouse Solution Downloads: Available on CraftyDBA.com   Biography: John has over twenty years of IT experience including a Masters degree in Computer Science from the … Continue reading →

Posted in Meetings | Tagged , , , | Comments Off on June 2013 ~ Using File Partitioning And Data Compression For An Effective Data Warehouse Solution ~ John Miner

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

Jan 2013 ~ Building Your Own Monitors with the SQL Agent ~ Mike Hillwig

Posted on November 1, 2012 by

Presenter: Mike Hillwig Topic: Building Your Own Monitors with the SQL Agent Downloads: Available at CrankyDBA.com See those things around your ankles? You hope they’re your socks because no DBA wants to be caught with their pants down. Whether you’re … Continue reading →

Posted in Meetings | Tagged , , , | Comments Off on Jan 2013 ~ Building Your Own Monitors with the SQL Agent ~ Mike Hillwig

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