SQLSaturday #80 - Wheeling 2011

Event Date: 07/23/2011 00:00:00

Event Location:

West Virginia Northern Community College
1704 Market Street
Wheeling, West Virginia

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

Sessions
Speakers
Sponsors

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).

Sessions

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

Title: Design and Implement BI Like Edison!

Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.

Speaker(s):

William E Pearson III

Track and Room: Track 2 - N/A

Title: High Availability Solutions in SQL Server

Abstract: In SQL Server 2005 and later version of SQL Server, there are different technologies that are used to server as High Availability Solutions and they can be implemented as Disaster Recovery Solutions. Many critical systems need to be online 24x7 with very minimum downtime, if possible, without any downtime. To achieve this need, we can implement high availability solutions that are available in SQL Server. Which we want to implement? There are several of them: Replication, Database Mirroring, Log Shipping, Failover Clustering, and Replication. In this session, we will be talking about these technologies, their usage, advantages, and disadvantages using one over the other.

Speaker(s):

Abi Chapagai

Track and Room: Track 1 - N/A

Title: NoSQL- What is it and why do I care?

Abstract: NoSQL (or, more correctly NoRel) is a moniker applied to a family of non relational software systems for storing data and/or documents that powers some of the largest sites on the internet. Amazingly enough, some of these platforms have been around a very long time. A high level discussion of some of the pros and cons of this technology compared to traditional systems like Oracle and SQL Server. A survey of the most popular “NoSQL” platforms and who uses them.

Speaker(s):

Craig Purnell

Track and Room: Track 1 - N/A

Title: Building Your First SQL Cluster

Abstract: Interested in high availability, but don’t know where to start? This session will start at the ground level and work through all the requirements of building a SQL Cluster environment, including Windows steps, storage steps, and networking needs.

This will include a brief on what is coming down the pipe in Denali.

Of course, SQL Server will be included in this process.

Speaker(s):

Joseph D’Antoni

Track and Room: Track 2 - N/A

Title: Take Your Automation Script to the Next Level!

Abstract: DBA’s traditionally have a library of T-SQL scripts which they use in automating their job. PowerShell, Microsoft’s newest scripting language, can take those T-SQL scripts to the next level. PowerShell and the SMO (Server Management Objects) library allow a DBA to create scripts that will interact with the OS and SQL Server at the same time. In this session we reveal the power of automating SQL Server with PowerShell by reviewing a number of scripts that have been migrated from T-SQL to PowerShell. This session will include scripts that will backup databases, interrogate a server, and script out objects from a database.

Speaker(s):

Paul Hiles

Track and Room: Track 1 - N/A

Title: Lessons Learned: Starting your career as a DBA.

Abstract: System.Xml.XmlElement

Speaker(s):

Shannon Lowder

Track and Room: Track 3 - N/A

Title: Hello World (Schema) - Introduction to T-SQL

Abstract: So you’re ready to dump that Excel “database” and join the SQL Server crowd? Matt Velic will guide you on a whirlwind tour of Transact-SQL. You’ll learn a little about its history, what Data Definition Language (DDL) and Data Manipulation Language (DML) are, and how to write basic statements of your own. Finally, Matt will leave you with some resources that will take your T-SQL skills to the next level.

Speaker(s):

Matt Velic

Track and Room: Track 2 - N/A

Title: Automating Database Source Control

Abstract: Automating Database source code control and deployments

Speaker(s):

James Gaines

Track and Room: Track 2 - N/A

Title: DMVs- What are they and why should a DBA care?

Abstract: DMVs - Dynamic Management Views and Functions are the DBA’s looking glass into the internals of SQL Server. They will give a DBA a snapshot on how the database is performing and potential problem areas. In this session, we will review a number of DMVs describing the types of information that can be captures and how it might be used. This review will include index statistics, query performance, memory utilization to name a few.

Speaker(s):

Paul Hiles

Track and Room: Track 3 - N/A

Title: Automate Policy-Based Management using PowerShell

Abstract: The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.

Speaker(s):

Allen White

Track and Room: Track 3 - N/A

Title: Database Mirroring in the Real World

Abstract: Review of Database Mirroring in the context of operations in the real world. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; discussion of the pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.

Speaker(s):

Craig Purnell

Track and Room: Track 1 - N/A

Title: Wait-Time Based SQL Server Performance Management

Abstract: Using Wait Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues.

Speaker(s):

Bronwyn Altizer

Track and Room: Track 2 - N/A

Title: Windows PowerShell Best Practices for DBA’s

Abstract: Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences.

Speaker(s):

Ed Wilson

Track and Room: Track 1 - N/A

Title: An Overview of PowerPivot

Abstract: In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …”

Speaker(s):

William E Pearson III

Track and Room: Track 2 - N/A

Title: Designing an SSIS Framework

Abstract: In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.

Speaker(s):

Andy Leonard

Track and Room: Track 3 - N/A

Title: Let Service Broker Help You Scale Your Application

Abstract: How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.

Speaker(s):

Allen White

Track and Room: Track 3 - N/A

Title: Windows PowerShell Best Practices for DBA’s part 2

Speaker(s):

Ed Wilson

Track and Room: Track 1 - N/A

Title: “I See a Control Flow Tab. Now What?”

Abstract: This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

Speaker(s):

Andy Leonard

Track and Room: Track 3 - N/A

Speakers

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

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

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

Paul Hiles

Paul has over 20 years of experience in the IT field which includes: programmer, system administrator, technical manger and both an operational and application DBA. He has been working with SQL Server since 2000 starting with version 7.0. He is currently a Data Architect where he specializes in SSIS, SSRS and database design and performance tuning.

Abi Chapagai

I am a Database Administrator at CR software in Fairfax, VA. I have 7 years of IT experience and about 6 years in Relational Database Management System, focusing in Microsoft SQL Server. I am Microsoft Certified IT Professional (MCITP 2005 Database Administrator). I enjoy learning SQL Server Internals, volunteer for the 2010 DC SQLSaturday.

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

Matt Velic

Twitter: - mvelic

LinkedIn: Matt Velic

Contact: http://mattvelic.com

Matt Velic is a database developer for Sanametrix in Washington, DC. When not jet setting between projects at work, you can find him at a board game, a video game, or playing a guitar.

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.

Bronwyn Altizer

Bronwyn Altizer has over 15 years of DBA experience including database design, development support, database implementation and performance tuning of many critical business applications. Soft skills include working with both the business and technical teams to deliver consistent superior support in both daily and crisis situations. Bronwyn is currently working as a senior DBA for Cardinal Health. Before Cardinal, Bronwyn was a DBA at a consumer marketing company and managed a team of DBAs.

Ed Wilson

Twitter: - ScriptingGuys

LinkedIn: Ed Wilson

Contact: http://HTTP://WWW.ScriptingGuys.Com/Blog

Ed Wilson is the Microsoft Scripting Guy and a well-known scripting expert. He writes the daily Hey Scripting Guy! blog. He has also spoken at TechEd, Tech Ready, Geek Ready, SQL Rally and various SQLSaturday conferences. A Microsoft-certified trainer he has taught scripting to Microsoft Premier Customers worldwide. He has written 11 books including 9 on Windows scripting that were published by Microsoft Press. His Windows PowerShell 3.0 Step by Step for MSPress is a current best seller.

Paul Hiles

Craig Purnell

Twitter: - @CraigPurnell

LinkedIn: Craig Purnell

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

Shannon Lowder

Twitter: - @shannonlowder

LinkedIn: Shannon Lowder

Contact: http://shannonlowder.com

For over 15 years Shannon Lowder has been spotting patterns and learning ways to work smarter instead of harder. He started with development and moved into database administration. Using TSQL, Database Jobs and PowerShell, he automated himself out of contracts quickly. As Business Intelligence became a greater demand, he moved into SSIS, SSRS, and SSAS development. Early on, he tried using PowerShell and .Net to automate BI Development. Later those efforts turned to Biml. After founding a startup six years ago, he finds himself a data platform consultant, designing and guiding other professionals to build highly automated enterprise solutions. Today, he is a Biml Hero candidate and is awaiting the final approval for the award.

James Gaines

Contact: http://allkindsofdatabasestuff.blogspot.com/

James Gaines currently works as a Custom Software Developer in the area of Database Development for Mylan, Inc. utilizing SQL Server and .Net technologies. In the past he has worked with a variety of databases and operating systems, as a Database Administrator / System Administrator. He specializes in OLTP database implementations, support and tuning.

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

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

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

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

Ed Wilson

Twitter: - ScriptingGuys

LinkedIn: Ed Wilson

Contact: http://HTTP://WWW.ScriptingGuys.Com/Blog