Tag Archives: DBA

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

  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

  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

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

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

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

  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

July 2012 ~ Introduction to Extended Events ~ Brandon Leach

 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

  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