SQLSaturday #126 - Indianapolis 2012

Event Date: 07/28/2012 00:00:00

Event Location:

  • The University of Indianapolis
  • 1400 E. Hanna Ave
  • Indianapolis, Indiana

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: (SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Abstract: Fuzzy Matching, Similarity Matching or Record Linkage is the most critical and least understood process in any Data Warehouse, BI, Integration, Big Data , Data Quality, MDM , Social Network or integrating crap effort. Over at LinkedIn there is Group run by Henrik Liliendahl Sorensen for Data Matching, Bill Winkler, principal researcher at the US Census” has written a series of white papers on record linkage and particular a technique called “Blocking Indexs”. In addition we wil cover William Cohen Research Professor, Machine Learning Department, Carnegie Mellon University white papers an implementations. Presented will be our collection of “real world” examples(Code) and you will leave a master of record linkage and the concepts behind it


  • Ira Warren

Track and Room: Track 5 - N/A

Title: Tame Your Unruly Data…With Constraints!

Abstract: Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!


  • Rob Volk

Track and Room: Track 2 - N/A

Title: SQL Azure Scalability with Federations

Abstract: With more and more companies moving to a cloud solution, the necessity to easily and efficiently scale their database solution is critical. This session will discuss how to scale SQL Azure using SQL Azure Federations, a recent addition to SQL Azure that provides the ability to build scalable, elastic, and multi-tenant solutions in SQL Azure. SQL Azzure Federations bring the sharding pattern into SQL Azure as a first class citizen as a way to achieve greater scalability and performance from the database tier of your application through horizontal partitioning at the database level. This session will look at Federations from a real-world point of view, by applying Federations to a real-life database. We will also look at performance benefits.


  • Scott Klein

Track and Room: Track 3 - N/A

Title: PWNED! Security, SQL Server, and You!

Abstract: With an ever increasing workload, security is often hoisted upon the DBA. So where do you start? Sometimes it’s better to start off by understanding what an attacker could do to you in order to get a clearer picture of what you need to do to prevent it. In this session, we will delve into the key features of the SQL Server and explain what the various attack vectors are, what an attack can do with them, and what you can do about them. We’ll also look at important features such as SQL Audit that, while not helping to prevent, can definitely help you in definitely help in figuring out what is going on. It’ll be AWESOME!


  • Arie Jones

Track and Room: Track 1 - N/A

Title: Introduction to the new Data Alert feature in SSRS

Abstract: SSRS 2012 provides a brand new feature called data alerts. It allows users to monitor changes in report data and send data alert messages by email when report data follow rules that define data of interest to you. This session introduces this great new feature and will show real world scenarios for its application.


  • Ludwig Armbruster

Track and Room: Track 5 - N/A

Title: Parameter sniffing - make it work for you !

Abstract: Parameter Sniffing is usually thought of as the bad guy, in association with a performance problem in your database. Contrary to the popular belief, Parameter Sniffing is usually the good guy, continuously working under the hood to help your database applications run faster. However, it can sometimes go wrong, causing severe performance degradation of your queries. In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario.


  • Sanil Mhatre

Track and Room: Track 5 - N/A

Title: Database Crime Scene Investigation

Abstract: Sometimes, bad things happen in a server, and someone has to investigate. What kinds of tools are out there for Database Adminstrators, and what are some common methods that we can use to explore what has happened the “aftermath” of something going wrong? This session will explore some methods, tools, and examples that I’ve used as the database administrator to uncover and analyze “what went wrong”.


  • Brent Dragoo

Track and Room: Track 4 - N/A

Title: Data Quality Services–Finally!

Abstract: Every organization that stores data stores dirty data, and suffers with how best to handle this unpleasant fact.Organizations must rely on people to deal with data problemseither by paying them to clean it or paying them to work around it. Either way it is costly and only becomes more so over time. Finally with the release of SQL Server 2012, there is a tool to help. Learn how to use the key parts of Data Quality Services: how to create a Knowledge Base, how to create Data Cleansing Projects to cleanse data both in the DQS client and inside SSIS 2012, and how DQS Matching Projects can integrate with Master Data Services for de-duplication of data. Session focuses on DQS, but also explains how DQS, MDS, and SSIS work together.


  • Julie Smith

Track and Room: Track 4 - N/A

Title: Professional Networking for IT Pros

Abstract: Want to invest in your long term career success? You need to network. C’mon give it a try! It’s not that bad! This presentation will explain some in-person networking tips and some do’s and don’ts for networking on LinkedIn. Takeaways include: -How to find events -Tips on getting to most out of attending events -How to develop and maintain your network of contacts -A Review of Linkedin networking best practices and profile optimization strategies.


  • Craig Purnell

Track and Room: Track 3 - N/A

Title: Manage SQL Server 2012 on Server Core w/PowerShell

Abstract: Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.


  • Allen White

Track and Room: Track 1 - N/A

Title: Powershell and Perfmon…Come on!

Abstract: Many DBA’s and sysadmins are starting to use PowerShell to automate routine/daily tasks. A task that can be time consuming to setup on each server is performance monitoring with Perfmon. A great way to automate that task is to use PowerShell. So, let’s take a venture into PowerShell land and see how to write our very first script. Along the way we will capture performance counters and then export them to a blg formatted file for viewing.


  • Shaun Watts

Track and Room: Track 4 - N/A

Title: TempDB Performance Troubleshooting and Optimizing

Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.


  • Eddie Wuerch

Track and Room: Track 1 - N/A

Title: Parallel Query Execution Deep Dive

Abstract: What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it’s use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.


  • Kevin Boles

Track and Room: Track 2 - N/A

Title: Seven SQL Agent Jobs You Should be Running

Abstract: 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 an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won’t buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what’s going on in your environment.

You’ll learn how to implement seven simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You’ll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more.


  • Mike Hillwig

Track and Room: Track 2 - N/A

Title: Optimizing SQL Server I/O with Solid State Drives

Abstract: Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure


  • Luke Jian

Track and Room: Track 3 - N/A

Title: Overcoming Barriers and Avoiding Mistakes with BI

Abstract: A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI.


  • William E Pearson III

Track and Room: Track 3 - N/A

Title: Writing Professional Database Code

Abstract: As protectors of arguably, the most important asset companies’ have we are tasked with ensuring quality, security and performance. However the ways in which we utilize and obtain those assets are often not formalized and therefore suffer from degraded quality. Let’s discuss some strategies that can be implemented to not only raise the bar of quality, but also make you sleep easier at night.


  • Aaron Lowe

Track and Room: Track 5 - N/A

Title: Performance Troubleshooting Sql Server

Abstract: Perfomance is a concern for every dba. How do you baseline performance? What do you do when users complain about performance? What tools can you use to gather data and how do you analyze that data? We will start a basic performance troubleshooting methodology and move into more specifics of what data to collect and how to use that data to isolate a performance problem.


  • Joe McTaggart

Track and Room: Track 2 - N/A

Title: Looking to the future - Tabular Mode SSAS

Abstract: In this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.


  • Josh Fennessy

Track and Room: Track 2 - N/A

Title: Powershell? Yea, but I’m a DBA!

Abstract: Powershell has become a very popular scripting language for Windows, Exchange, Sharepoint and other admins. In this session, we’ll get our heads down and our inner geek on as we explore how Powershell can add value to our lives a DBAs. We’ll explore how Powershell can handle common tasks as well as several tasks that are difficult or even impossible with TSQL. We’ll wrap up by discussing how Powershell could be used to fully automate your install and post-install processes, standardizing your environment. Get your typing skills honed as you will leave here desiring to never click again.


  • Kyle Neier

Track and Room: Track 4 - N/A

Title: Contained DB? Did it do something wrong?

Abstract: Imagine an environment where moving a database from a SQL Instance to another is as simple as just restoring the database. (Yes, no other steps!) SQL Server 2012 RC0 now supports Partial Contained databases. We will cover the different levels of containment, configuring SQL Server to support it, and much more (i.e. Demos).


  • Warren Sifre

Track and Room: Track 2 - N/A

Title: SSIS: The DBA Multiplier

Abstract: er wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another. You will also learn how SSIS can be used in assisted HA and DR failover strategies as well as backup solutions that go beyond the simple BACKUP statement. We’re going to take SSIS and make it a standard tool for your administrative tasks!


  • Ted Krueger

Track and Room: Track 1 - N/A

Title: The Script Task, powerhouse of SSIS

Abstract: Everyday more DBAs and SQL developers are given responsibility for ETL development. They have a strong SQL background with little or no .Net language programming experience. As they progress with SSIS, they can come up against perceived limitations in the capabilities of SSIS using only the built-in tasks. What they may not realize is the extensibility available to SSIS via the Script Task. This presentation will provide them with the tools they need to move beyond that perceived limitation. Updated for SSIS 2012.


  • Norman Kelm

Track and Room: Track 3 - N/A

Title: A Complete BI Solution in About an Hour!

Abstract: In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.


  • Aaron King

Track and Room: Track 5 - N/A

Title: SQL Server and Sharepoint: Best Frienemies

Abstract: SharePoint is a rapidly growing application that relies heavily on SQL Server. In this session, we will discuss what a DBA needs to know to successfully manage instances hosting SharePoint databases. What configurations options are best for a SharePoint workload? What kind of maintenance shoule be performed? How should databases be provisioned? What the heck are all these databases for anyway? We will also discuss some nomenclature and key components of SharePoint to help better communicate with SharePoint application teams.


  • Joe McTaggart

Track and Room: Track 1 - N/A

Title: Transactional Replication 101

Abstract: Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring.

We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.


  • Wendy Pastrick

Track and Room: Track 3 - N/A

Title: Read Dirty to Me - Isolation Levels/User Impact

Abstract: Issue a “SELECT {data} FROM {myTable}” statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.


  • Wendy Pastrick

Track and Room: Track 1 - N/A

Title: Understanding SSIS Performance

Abstract: Many casual users of SSIS (including database professionals using the SSMS Import/Export Wizard) don’t necessarily understand the inner workings of SSIS and what factors impact performance. During this session, we’ll look at different aspects of SSIS and discuss their impact on package performance. We’ll take a deep dive into the Data Flow component, looking at how SSIS manages data as it moves from sources, through transformations, and then to destinations. Finally, we’ll talk about several of the top performance killers casual SSIS users experience and discuss strategies for overcoming these common issues.


  • Dave Fackler

Track and Room: Track 5 - N/A

Title: Consulting The Good, The Bad, The Ugly

Abstract: Ted Krueger will join Hope in presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it and why should I do it? Come join us on a discussion of the Pros and Cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We’ll field questions with real world experiences. Once you leave this open floor session, you’ll be able to make better choices in your own professional development and how consulting may or may not effect it.


  • Hope Foley

Track and Room: Track 4 - N/A

Title: SQL Server 2012 AlwaysOn Readable Secondaries

Abstract: One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups and the ability to have readable secondary replicas. In this session, we will cover the pros and cons of using AlwaysOn as well as the basics of how to set it up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you’re just curious about AlwaysOn, then you won’t want to miss this session.


  • Adam Belebczuk

Track and Room: Track 4 - N/A


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Arie Jones

Twitter: - @programmersedge

LinkedIn: Arie Jones

Contact: http://www.programmersedge.com

Arie Jones (quot;AJquot;) is one of the owners and Vice President of Emerging Technologies for Indy Data Partners, Inc. in Indianapolis, IN. AJ is a frequent speaker at national conferences and local user groups. With over 15 years of experience in application development and database administration on various platforms, he specializes in developing cross-platform solutions with an emphasis on .NET and SQL Server technologies. He blogs extensively at http://www.programmersedge.com.

Luke Jian

Twitter: - @sensware

LinkedIn: Luke Jian

Contact: http://blog.sqlpositive.com

Luke Jian is an experienced database architect with a leading healthcare information company. A frequent speaker at conferences and local user groups he has 15+ years of experience in database design, development and optimization on SQL Server and Big Data projects.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

Contact: http://dataperfpro.com/blog/

Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Adam Belebczuk

Twitter: - @SQLDiablo

LinkedIn: Adam Belebczuk

Contact: http://www.sqldiablo.com/

Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.

Wendy Pastrick

Twitter: - @wendy_dance

Contact: http://wendyverse.blogspot.com

Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Joe McTaggart

I have worked with Microsoft for 8 years. I started with SQL Server in 2001 with CTS at Microsoft. Currently I am a Premier Field Engineer based out of Indianapolis.

Kyle Neier

Twitter: - @Kyle_Neier

LinkedIn: Kyle Neier

Contact: http://sqldbamusings.blogspot.com/

Kyle has been working professionally with computers since 1995, the past 10 years being dedicated to SQL Server. He currently works as an Engineer for Apparatus (apparatus.net) where he continues to chase his passion to automate DBA processes. He is a proud father of 5, a leader of the local PASS chapter (www.indypass.org), a Microsoft Certified Master (MCM), and enjoys sharing his passion for SQL Server with others by speaking and mentoring at local and regional events.

Dave Fackler

Twitter: - @sqlbiguru

LinkedIn: Dave Fackler

Contact: http://davefackler.blogspot.com/

Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.

Mike Hillwig

Twitter: - @mikehillwig

LinkedIn: Mike Hillwig

Contact: http://www.mikehillwig.com

Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.

Shaun Watts

Shaun Watts has been working with SQL Server for over 6 years as a DBA developer and has been in the IT industry for over 11 years. Shaun is currently a Microsoft Consultant for Perpetual Technologies, Inc. located in Indianapolis, where he does remote DBA work, SSRS, and custom database solutions.

Ted Krueger

Contact: http://blogs.lessthandot.com/index.php/All/?disp=authdirauthor=68

Ted Krueger has been working in development and database administration for over a decade. Ted currently works for a respected consulting company, Magenic Technologies as a valued Database Professional resource. He is a PASS Region Mentor, Friends of Red Gate member, SQL Server MVP and community mentor. Ted blogs and is also one of the founders of LessThanDot Technical Community

Aaron Lowe

Contact: http://www.aaronlowe.net

Aaron has over 14 years of SQL Server experience. He is strong in database design development, also having extensive experience in SSIS, SSRS, and administration, including performance, migrations and replication. Aaron is a MCITP in 2005 and 2008 as well as having a Masters in Information Systems Management. He is currently co-president of the Chicago SQLPASS Chapter and founder of SQLFriends.org. When he’s not working, he’s spending time with his bride, 5 children and 2 dogs.

Aaron King

Twitter: - https://twitter.com/trendoid

LinkedIn: Aaron King

Contact: http://www.aaronstanleyking.com

Aaron King is an application architect specializing in enterprise web applications and very large databases. He has helped several successful startups move to the software plus services model. He is currently working as an independent consultant on several long term engagements. Aaron is also a community leader and active in Indy PASS.

Josh Fennessy

Senior Business Intelligence Consultant at BlueGranite, Inc., Josh Fennessy has been working with the Microsoft BI stack exclusivley for the last 5 years. He has earned MCITP in both SQL 2005 and SQL 2008 versions of the tools. Josh is also the chapter leader of the West MI SQL Server Users Group.

When he’s not building BI solutions, he enjoys spending time with his 6 year old son, slinging lead at the range, and exercising (but never in his underwear. Promise!)

Wendy Pastrick

Twitter: - @wendy_dance

Contact: http://wendyverse.blogspot.com

Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.

Brent Dragoo

Twitter: - brentdragoo

Brent Dragoo lives in Noblesville, Indiana

Joe McTaggart

I have worked with Microsoft for 8 years. I started with SQL Server in 2001 with CTS at Microsoft. Currently I am a Premier Field Engineer based out of Indianapolis.

Eddie Wuerch

Twitter: - @EddieW

LinkedIn: Eddie Wuerch

Contact: http://www.indydba.com

Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.

Julie Smith

Twitter: - @juliechix

LinkedIn: Julie Smith

Contact: http://datachix.com

Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.

Norman Kelm

Contact: http://www.gerasus.com/

Norman Kelm is the owner of Gerasus Software, http://www.gerasus.com/, the maker of SSIS-DTS Package Search the only utility that can search SSIS and DTS packages. Norman has been working in IT for over 20 years. He worked as a FORTRAN and C developer for 8 years before making the jump to databases with Sybase. He then moved on to SQL Server working as a production and development DBA on SQL Server since version 6.5. He is also a founding member of the Tampa Bay SQL Server User Group.

Hope Foley

Contact: http://hopefoley.com/

Hope has over 12 years experience in the IT world, she has worked across many industries from small business enterprises to Fortune 500 companies. She has a vast knowledge of database design, administration and support, data warehousing and data mining, and custom database solutions. Hope joined PTI in 2007 as a SQL Server Database Administrator/Analyst, and took over as Principal Microsoft Consultant, where she now leads a team of expert DBAs and developers. She is also a SQL Server MVP.

Sanil Mhatre

Twitter: - sqlsuperguru

LinkedIn: Sanil Mhatre

Contact: http://sqlwithsanil.com

Sanil Mhatre is a Senior Data Engineer, currently focused on delivering Analytical insights for a large Technology solutions Services company in Missouri. He has a Master’s degree in Information systems and enjoys working with various Data processing technologies, analytics tools and visualization platforms. Sanil has an interest in Data Science, is an active member of PASS and a frequent speaker at technical conferences and user groups. He volunteers with STEM mentorship programs, blogs and loves to keep up with developments in the fields of Machine Learning AI. When Sanil isn’t working he enjoys spending time with family and friends, tasting craft beer and hiking with his dogs.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com

Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.

Ira Warren

 Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.

Ludwig Armbruster

Ludwig Armbruster is a Technical Solution Professional and helps customers with their analytical investments in Azure.

Craig Purnell

Twitter: - @CraigPurnell

LinkedIn: Craig Purnell

Contact: http://www.craigpurnell.com/

Craig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 15 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQLSaturdays, and the PASS Summit in 2012 and 2013


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page