Author Archives: admin

Sep 2014 ~ What the VLF? ~ Mike Hillwig

Posted on September 9, 2014 by

Presenter: Mike Hillwig Topic: What the VLF? Downloads: Available at CrankyDBA.com Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up … Continue reading →

Posted in Meetings | Tagged , , | Leave a comment

Aug 2014 ~ SQL Server Statistics: The Secret Sauce ~ Tim Harkin

Posted on August 13, 2014 by

Presenter: Tim Harkin Topic: SQL Server Statistics: The Secret Sauce Learning how to write a query is a basic SQL skill. Eventually, a curious developer wants to know how SQL actually returns the data. Statistics are the “secret sauce” that … Continue reading →

Posted in Meetings | Tagged , , , | Comments Off on Aug 2014 ~ SQL Server Statistics: The Secret Sauce ~ Tim Harkin

July 2014 ~ Building a vision for IT ~ Dave Ramsden

Posted on July 7, 2014 by

Presenter: Dave Ramsden Topic: Building a Vision for IT …is about creating a vision that will make IT more strategic as we move into the dramatically changing IT landscape of the first digital decade. The overall theme stresses focusing on … Continue reading →

Posted in Meetings | Tagged , , | Comments Off on July 2014 ~ Building a vision for IT ~ Dave Ramsden

June 2014 ~ In-Memory tables: Working with Millions of rows ~ Andy Novick

Posted on June 9, 2014 by

Presenter: Andy Novick Topic: SQL Server 2014 In-Memory tables, Working with Millions of rows Memory optimized tables are one of the cool new features in SQL Server 2014. They’re being marketed as a high transaction throughput solution for OLTP. We’ll … Continue reading →

Posted in Meetings | Comments Off on June 2014 ~ In-Memory tables: Working with Millions of rows ~ Andy Novick

May 2014 ~ Advanced Tabular Development ~ Christopher Schmidt

Posted on May 12, 2014 by

Presenter: Christopher Schmidt Topic: Advanced Tabular Development In this session, we’ll cover some of the more advanced concepts in tabular databases. First we’ll take a look at things like partitions and perspectives, and how we can use them to assist … Continue reading →

Posted in Meetings | Tagged , | Comments Off on May 2014 ~ Advanced Tabular Development ~ Christopher Schmidt

April 2014 ~ A brief introduction to Power Tools? ~ John Miner

Posted on April 9, 2014 by

  Presenter: John Miner Topic: A brief introduction to Power Tools. Downloads: Available on CraftyDBA.com In recent months, there has been a big push for self service business intelligence tools by Microsoft. The center of this universe is Microsoft Excel, … Continue reading →

Posted in Meetings | Tagged , , , , | Comments Off on April 2014 ~ A brief introduction to Power Tools? ~ John Miner

March 2014 ~ Mind your language!! Cursors are a dirty word ~ Steve Simon

Posted on March 11, 2014 by

  Presenter: Steve Simon Topic: Mind your language!! Cursors are a dirty word     Although many SQL Server folks become irate at the thought of using cursors, like anything else in life there is a time and place. In … Continue reading →

Posted in Meetings | Tagged , , | Comments Off on March 2014 ~ Mind your language!! Cursors are a dirty word ~ Steve Simon

Feb 2014 ~ Advanced Transactional Replication ~ John Flannery

Posted on February 3, 2014 by

Presenter: John Flannery Topic: Advanced Transactional Replication We will cover several advanced topics in Transactional Replication including how to make a ddl change to one table in the publication without reinitializing the publication; how to make a ddl change to … Continue reading →

Posted in Uncategorized | Tagged , , | Comments Off on Feb 2014 ~ Advanced Transactional Replication ~ John Flannery

Jan 2014 – The PowerShell Database Cookbook: Best Recipes ~ Bryan Cafferky

Posted on January 6, 2014 by

Presenter: Bryan Cafferky Topic: The PowerShell Database Cookbook: Best Recipes Downloads: Presentation Bundle Maybe you’ve heard about all the great features of PowerShell, Windows scripting language, but thought, Ok, so how do I actually put PowerShell to use? In this … Continue reading →

Posted in Meetings | Tagged , , | Comments Off on Jan 2014 – The PowerShell Database Cookbook: Best Recipes ~ Bryan Cafferky

Dec 2013 ~ SSIS Design Patterns for Better Performance ~ Matt Batalon

Posted on December 4, 2013 by

Presenter: Matt Batalon Topic: SSIS Design Patterns for Better Performance These days ETL developers face two common problems: 1: They are managing more and more ETL processes that have to complete in a shorter time window, and 2: their data … Continue reading →

Posted in Meetings | Tagged , | Comments Off on Dec 2013 ~ SSIS Design Patterns for Better Performance ~ Matt Batalon