IndyPASS

Past Presentations at IndyPASS

2017


Tuesday January 17th, 2017
SQL Lightning Talks
Presenters: Joe McTaggart (Microsoft), Karen Smith (Anthem Inc.), Jay Robinson (Salesforce Marketing Cloud), Brandon Lukes (Microsoft)
Download Slides and Examples from this Meeting

2015


Tuesday October 20th, 2015
Database Continuous Delivery & Your Salvation!
Presenter: John Morehouse, Redgate
Download Slides and Examples from this Meeting

2014


Tuesday December 16th, 2014
Are Your Indexes Helping You or Hurting You?
Presenter: Jes Borland, Consultant Brent Ozar Unlimited

Tuesday September 16th, 2014
The Lost Science of Set Theory
Presenter: Aaron Cutshall, Solutions Architect, Encore
Download Slides and Examples from this Meeting

2013

Tuesday June 18th, 2013
For Better or For Worse, Can SharePoint and SQL Server Find Wedded Bliss?
Presenter: John Ferringer - Sogeti

Tuesday May 21st, 2013
Intro to PowerShell V3 and SQL Server 2012
Presenters: Matt Griffin & Kyle Neier - Apparatus

Tuesday February 19th, 2013
JBOTS (Just a Bunch of T-SQL) – Tips from the Trenches
Presenter: Eddie Wuerch, Exact Target
Download Slides and Examples from this Meeting

Tuesday January 15th, 2013
Columnstore Indexes in SQL Server 2012: Flipping the DW Faster Bit
Presenter: Jimmy May, Microsoft

2012


Tuesday December 18th, 2012
Business Analytics: Looking at the Market, the Changes, and the Tectonic Shifts for the mega-vendors. Then, what is Microsoft doing about this
Presenter: Jordan Martz, Lantech Training

Tuesday November 20th, 2012
Security, Data and the evolving role of the DBA...
Presented by Warren Sifre, PTI

Tuesday October 16th, 2012
VMWare, DTS, and migrating to SSDT. What can go wrong and how can I fix it?
Presented by Dexter Ploss, Database Administrator, MCP, MCSD, MCTS

Tuesday September 18th, 2012
Locks, Blocks, and Deadlocks
Presented by Kyle Neier, Perpetual Technologies

Tuesday August 21st, 2012
SQL Server AlwaysOn – What’s underneath the name?
Presented by Joe Carver, Microsoft

Tuesday July 17th, 2012
Powershell and Perfmon...Come on!
Presented by Shaun Watts, Perpetual Technologies, Inc.

Tuesday June 19th, 2012
BI Capabilities of SQL Server 2012 and SharePoint 2010
Presented by Jordan Ude, Apparatus

Tuesday May 15th, 2012
Join Us! Getting Started as a Technical Speaker
Presented by Eddie Wuerch, ExactTarget

Tuesday April 17th, 2012
Using Confio's Ignite tool to Monitor Database Performance and Wait States
Presented by Steven Estep

Tuesday March 20th, 2012
Mastering Knowledge Bases with Data Quality Services in SQL Server 2012
Presented by Arie Jones, Perpetual Technologies

Tuesday February 21st, 2012
SQL Server Memory Management: Mythbuster Edition
Presented by Joe McTaggart, Microsoft

Tuesday January 17th, 2012
T-SQL Tips & Tricks
Presented by Aaron Cutshall, Indiana Health Information Exchange
Download Slides and Examples from this Meeting

2011

Tuesday December 20th, 2011
Master Data Services in SQL Server 2012
Presented by Arie Jones, Perpetual Technologies

Tuesday November 15th, 2011
Page Latching for Mere Mortals
Presented by Eddie Wuerch, Exact Target

Tuesday October 18th, 2011
A complete BI Solution in about an hour!
Presented by Aaron King, Woundvision

Tuesday September 20th, 2011
SQL Server Codename Denali – What’s New?
Presented by Joe Carver, Microsoft

Tuesday August 16th, 2011
Monitoring and Alerting with SQL Agent and Powershell
Kyle Neier

Tuesday July 19th, 2011
Partitioning Doesn't Have To Cause A Splitting Headache
Montrial Harrell, Broadstroke Consulting

Tuesday June 21, 2011
The Benefits of SQL Azure
Aaron King, Woundvision TIS

Tuesday May 17th, 2011
What Can't Powershell Do?
Hope Foley, Perpetual Technologies

Tuesday April 19th, 2011
Master Data Services
Arie Jones, Perpetual Technologies, Inc.
 
Tuesday March 15th, 2011
SQL Server Parallel Data Warehouse 2008 R2 Drilldown
Presented by Derek Comingore, BI Voyage
 
Tuesday February 15th, 2011
Find Performance and Capacity Problems by Reading the Waits
Presented by Eddie Wuerch, ExactTarget
The slides for this presentation can be found at http://indydba.com/?page_id=21
 
Tuesday January 18th, 2011
Sharing Report Components
Presented by David Leininger, Defender Direct

2010

Tuesday December 21st, 2010
Geographic Analysis with Spacial Data
Presented by Dan Crawford, Integrated Network Strategies
 
Tuesday November 16th, 2010
Journey From Student to DBA
Presented by Tom Ahler
Ask The Experts (bring your questions!)
Facilitated by Steven Estep
 
Tuesday October 19th, 2010
Sharepoint for the DBA
Guest Speaker: Jim Grabinski and Hope Foley, Perpetual Technologies, Inc.
 
Tuesday September 21st, 2010
SQL Server Synonyms
Guest Speaker: Steven Estep, Crowe Horwath
 
Tuesday August 10th, 2010
** Meeting cancelled **
 
Tuesday July 20th, 2010
Using SQL Server 2008 Auditing Feature for PCI Compliance
Guest Speaker: Kyle Neier

Tuesday June 15th, 2010
Accelerating SQL with Solid State Technology
Guest Speaker: Darren Burton, Fusion IO

Tuesday May 18th, 2010
Multiple Instance Consolidation Practices
Guest Speaker: Alex Prusakov
 
Tuesday April 20th, 2010
Writing Effective Queries
Guest Speaker: Eddie Wuerch, ExactTarget
 
Tuesday March 16th, 2010
Gemini
Guest Speaker: Derek Comingore, BI Voyage
The slides for this presentation can be found at http://bivoyage.com/Presentations/PreparingforPowerPivot.pdf
 
Tuesday February 16th, 2010
Database Object Schemas
Guest Speaker: Steven Estep, Crowe Horwath
 
Tuesday January 19th, 2010
SQL Service Brokers
Guest Speaker: Dan Crawford, Integrated Network Strategies 
The slides for this presentation can be found at http://www.slideshare.net/DanCrawfordMBA/sql-server-service-brokers

2009

Tuesday, December 15, 2009 
Tuna Helper - Proven Process for Tuning SQL
Guest Speaker: Janis Griffin, Confio Software

Tuesday, November 17, 2009
Kilimanjaro
Guest Speaker: Tom Pizzato, Microsoft Corporation

October 20, 2009 
Virtualization of SQL Server
Guest Speaker: Steve Brunner, Mezolink

September 15, 2009
Database Normalization
Guest Speaker: Arie Jones, Perpetual Technologies, Inc.
 
August 18, 2009
SQL Server 2008 Policy Based Management
Guest Speaker: Joe Carver, Microsoft Corporation
 
July 21, 2009
Go Big, Go Huge... Go Fast!
Leveraging Table Partitioning to Speed Performance and Ease Management of Large Tables

Guest Speaker: Eddie Wuerch, ExactTarget

 June 16, 2009
DTS to SSIS Conversion:  What Are Your Options?
Guest Speaker: Mike Davis, PragmaticWorks

May 19, 2009
SAN multipathing and how to test it with SQLIO
Guest Speaker: Brent Ozar, Quest Software

April 21, 2009
Looking into the Cloud with SQL Server Data Services
Guest Speaker: Tom Pizzato, Microsoft Corporation

March 17, 2009
Comparing Clustering Methods
Guest Speaker: Alex Prusakov, Sr. Microsoft Consultant, Perpetual Technologies
The slides for this presentation can be found at http://www.slideshare.net/AlexDepo/compare-clustering-methods-for-ms-sql-server

February 17, 2009
Introduction To Transparent Data Encryption
Guest Speaker: John Magnabosco, SolutionAvenue

January 20, 2009
Wait-Time Based SQL Server Performance Management
Guest Speaker: Dean Richards, Senior DBA, Confio Software


2008

December 16, 2008
I/O Performance Considerations
Guest Speaker: James Jordan, Strategic Data Management

November 18, 2008
Powershell in SQL Server 2008
Guest Speaker: AJ Jones, Perpetual Technologies, Inc. (PTI)

October 21, 2008
101 Things NOT to do on a SQL Server (tales from the field)
Guest Speaker: Bryan Oliver, SQL Server Domain Expert at Quest Software

September 16, 2008
LINQ to SQL
Guest Speaker: George Huey, Microsoft Corporation

August 19, 2008
Tuning T-SQL (Plus CLS vs. T-SQL)
Guest Speaker: AJ Jones, Perpetual Technologies, Inc. (PTI)

July 15, 2008
Deadlock Graphs and Event Notifications
Guest Speaker: Eddie Wuerch, Exact Target

June 17, 2008
3rd Annual Birthday Bash
Guest Speaker: Tom Pizzato, Microsoft Corporation
Surprize Guest: Buck Foley, Internationally Renowned Motivational Speaker

May 20, 2008
Introduction to SQL Server Management Objects (SMO) and SQL Server Replication Management Objects (RMO)

Guest Speaker: AJ Jones, Perpetual Technologies, Inc. (PTI)

April 15, 2008
Analysis Services and BI

Guest Speaker: Craig Utley

March 18, 2008
VSTS for Databases

Guest Speaker: Paul Hacker, Microsoft MVP!

February 19, 2008
ToolReview 2008

SQL Compare from Red-Gate Review by Steven Estep
Change Director from Quest Software Review by Jamal Khan
SQL Delta from The Australian Software Company Review by Dave Leininger

January 16, 2008
SQL Server Disk Partition Alignment: 
Increase I/O Throughput by up to 30% or More
(The Best Kept Secret in SQL Server Disk I/O Performance)
Guest Speaker: Jimmy May, Microsoft Corporation

2007

December 2007


November 20, 2007
Achieving Identity Protection Through PCI Compliance

Guest Speaker: Joshua Forman, Symplified
 
October 16, 2007
Thinking Outside the Box: Creating A Design Solution to Overcome Complex Business Needs
Guest Speaker: Arie 'AJ' Jones, Perpetual Technologies

September 18,2007
Common Table Expressions and Better performing Indexes

Guest Speaker: Steven Estep, Crowe Chizek

August 21, 2007
SQL Server 2008: What's New?

Guest Speaker: Joe Carver of Microsoft Corporation
 
July 17, 2007
A Practical Guide to Making Sense of Your SQL Server Application Performance

Guest Speaker: Taya Blanchard of Quest Software

June 14, 2007
2nd Annual Birthday Bash
Guest Speaker: Bill Baker, SQL Server Business Intelligence General Manager at Microsoft
Special Entertainment: Buck Foley, Internationally Renowned Motivational Speaker
Musical Entertainment: Right on Red

May 15, 2007
DoubleHeader Night
1) Introducing Visual Studio Team Edition for Database Professionals
Guest Speaker: Paul J. Hacker, Independent Software Engineer
2) Lock and Block Management Strategies
Guest Speaker: Joe Carver, Microsoft Corporation

April 18, 2007
Open Mic Night

March 20, 2007
SQL IO

Guest Speaker: Joe Carver, Microsoft Corporation

February 20, 2007
2nd Annual Winter Challenge
Congratulations to Boby Joseph, Winner of Winter Challenge 2007.

January 16, 2007
Best Practices for Auditing & Securing SQL Server Databases

Guest Speaker: Jeremy Gaige, Senior Software Engineer, Idera

2006

December 19, 2006
Business Intelligence and PASS Recap
Guest Speaker:Bret Updegraff

November 21, 2006
Threat Modeling

Guest Speaker: John Magnabosco

October 19, 2006
Stored Procedures Best Practices

Guest Speaker: Kevin Kline of Quest Software and the President of PASS

September 19, 2006
Windows PowerShell and SQL Server 2005

August 15, 2006
Disaster Recovery
Guest Speaker: Bob Roudebush of NSI

July 18, 2006
SQL Server Analysis Services
Guest Speaker: Joe Carver, Database Technology Specialist with Microsoft

June 29, 2006
1st Annual Birthday Bash

Guest Speaker: Bill Baker, SQL Server Business Intelligence General Manager at Microsoft.
Special Entertainment: Buck Foley, Internationally Renowned Motivational Speaker.

May 16, 2006
Integrating Reporting Services into Visual Studio 2005
Guest Speaker: Denise Herne, of Crowe Chizek

April 18, 2006
SQL Server 2005 Management and Performance Tools

Guest Speaker: Joe Carver, Database Technology Specialist with Microsoft

March 21, 2006
*Meeting Cancelled*
Our March meeting was cancelled due to a Spring Snow Storm. 

February 21, 2006
Winter Challenge 2006
Congratulations to Tom Waltz, Winner of Winter Challenge 2006.

January 17, 2006
MyGeneration Tool

Guest Speaker: Mike Griffin from MyGeneration Software

2005

December 15, 2005
The Best of SQL Server 2005 Launch
The Microsoft event titled "The Best of SQL Server 2005 Launch" took the place of our regularly scheduled meeting.

November 15, 2005
Open Mic Night

October 18, 2005
Reporting Services
Guest Speaker: Bret Updegraff

September 20, 2005
DTS and Integration Services
Guest Speaker: Bret Updegraff

August 16, 2005
Backup and Recovery Best Practices
Guest Speaker: Bryan Oliver, Lead Developer at Quest Software.

July 19, 2005
SQL Server 2005 Overview
Guest Speaker: Tom Pizzato, Database Technology Specialist with Microsoft

June 16, 2005
User Group Kick Off Meeting
Guest Speaker: Bill Baker, head of the Business Intelligence Unit within the SQL Server product development group.

Sponsors

Apparatus
Indy Data Partners
Moser Consulting
New Horizons
SIOS
Vaco Technologies
Violin Memory

Supporters

Quest Software
ingeniously simple tools
Back to Top