SQLSaturday #223 - Oklahoma City 2013
Event Date: 08/24/2013 00:00:00
Event Location:
- Sheraton Reed Center
- 5800 Will Rogers Rd
- Midwest City, Oklahoma
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).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Building Your First AlwaysOn Failover Cluster Instance
Abstract: Are you starting to plan for high availability and curious to see how clustering can keep your databases online and mitigate downtime during patching? Have you heard about clustering but have no idea what is required to build a successful cluster? If so, this session is for you. During this session we will compare the pros and cons of Failover Cluster Instances to ensure you implement the best solution to handle you’re HA requirements. We will build a windows cluster from scratch and go over all the requirements including failover cluster manager, nodes, shared storage, active directory, client access points, quorums and installing a SQL Server clustered instance. Finally, we will go over a basic framework to help you quickly perform a root cause analysis to determine why your SQL services went down.
Speaker(s):
- John Sterrett
Track and Room: DBA - N/A
Title: Table Partitioning: the Secret Weapon for your Big Data Problems.
Abstract: Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, its time you consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks. In this session you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance.
Speaker(s):
- John Sterrett
Track and Room: DBA - N/A
Title: Getting Started with Analysis Services 2012 Tabular
Abstract: The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model (“BISM”). He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”). Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.
Speaker(s):
- William E Pearson III
Track and Room: Business Intelligence - N/A
Title: Practical Self-Service BI with Excel 2010/2013
Abstract: SQL Server MVP and Business Intelligence Architect Bill Pearson leads an introduction to using Excel 2013 to deliver self-service business intelligence. The focus of this session is to help those unfamiliar with the BI features that debut in Excel 2013 to become familiar with the assembly of data from diverse sources into models that deliver BI upon demand. We’ll discuss accessing and relating data, and employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise. Moreover, we will overview other BI-related features, including Data Mining and the exciting new Power View reporting capabilities.
Speaker(s):
- William E Pearson III
Track and Room: Bonus - N/A
Title: Let’s Hadoop!
Abstract: This session provides a demonstration-rich introduction to the fundamentals of Hadoop and the Microsoft implementation, HDInsight. If you have heard of Hadoop but have struggled to get started with the technology, this session is for you.
Speaker(s):
- Bryan Smith
Track and Room: Bonus - N/A
Title: Unraveling Tangled Code
Abstract: Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will emerge victorious!
Speaker(s):
- Jennifer McCown
Track and Room: Developer - N/A
Title: Sharing SQL Data in SharePoint
Abstract: Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session get an overview of the basics of sharing a SQL table as a ‘List’ using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users dynamic PowerPivot analysis in a dashboard.
Speaker(s):
- Allen Smith
Track and Room: Developer - N/A
Title: Beginning Powershell for DBAs 1.0
Abstract: The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.
Speaker(s):
- Sean McCown
Track and Room: DBA - N/A
Title: SQL Security Best Practices Shrinking Your Attack Surface
Abstract: SQL Security is a very broad and scary topic, one which many days could be dedicated to speaking on it. In this session Matt will give a high level overview of what Database Security is, what tools Microsoft gives you to accomplish it and some simple things that you can do to shrink your attack surface.
Speaker(s):
- Matthew Brimer
Track and Room: DBA - N/A
Title: SQL Server vs The World
Abstract: While SQL Server is the 3rd most used database in the world, the landscape of how we build applications and the technology supporting them is quickly changing. As if keeping up with SQL Server isn’t enough on its own, we now have to deal with the terms and technology that comes with NoSQL (Not-Only-SQL) as well as fast moving, feature rich open source Relational DBs. In this session, we will explore some of the popular data stores, why AppDevs like using them and how your skills in SQL Server translate to them. Note: This session is geared towards OLTP systems. BI Solutions are NOT on the radar for this.
Speaker(s):
- Rob Sullivan
Track and Room: Developer - N/A
Title: Introduction to the XML Source
Abstract: XML is all over the place. But how do you get that data into SQL Server? SSIS provides an XML Source, but it is not easy to use. In this session we will handle increasingly complex XML documents. After an introduction to using the XML Source with a single set of elements, we will look at how to work with multiple element sets. This includes hierarchically structured XML documents.Attendees will be able to import simple XML using SSIS. They will be able to create import routines that pull data from different elements of more complex XML. They will understand the role the XML Schema plays in defining the XML data they import.
Speaker(s):
- Russel Loski
Track and Room: Developer - N/A
Title: Handling Errors and Data Anomalies in SSIS
Abstract: Even in the most reliable ETL system, it’s eventually going to happen: A package will fail, an output row count won’t match what is expected, a data anomaly will force a forensic search of the package infrastructure… In this session, we’ll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we’ll cover various ways to keep your ETL flowing when problems arise.
Speaker(s):
- Tim Mitchell
Track and Room: Business Intelligence - N/A
Title: 3D Geospatial Visualization Using Power Map
Abstract: Power Map, formerly called GeoFlow, is one of Microsoft’s latest releases in the BI spectrum. It provides for 3D geospatial and temporal visualization of data. In this session we’ll first compare and contrast the geospatial reporting capabilities of SSRS, Power View, and Power Map. We’ll then quickly learn the Power Map tool and create some interactive geospatial animated tours. We’ll also discuss the concept of datums, which is relevant for those using latitude and longitude.
Speaker(s):
- Kristin Ferrier
Track and Room: Bonus - N/A
Title: SMO Internals for High Performance PowerShell
Abstract: Ever wanted to know what happens in SQL Server when you use PowerShell and SMO to manage a SQL Server? How fast can your automation really go? I will take you through the most common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. We will dive deep through the collections that make SMO the powerful tool it is. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come peek behind the curtain and squeeze the speed out of your automation scripts using PowerShell and SMO. You’ll be glad you did.
Speaker(s):
- Ben Miller
Track and Room: DBA - N/A
Title: Introduction to BIML and BIMLScript
Abstract: Microsoft has provided some great tools for creating and editing SSIS packages. First Business Intelligence Development Studio (BIDS) then SQL Server Data Tools (SSDT). However, when creating an SSIS package you frequently repeat the same steps over and over. BIML is an XML markup language designed for representing the structure of an SSIS package. BIML Script takes that structure and generates an SSIS package.In this session we will use BIDS Helper to create a simple SSIS package using BIML. We will handle a couple SSIS scenarios with BIML and BIML Script.
Speaker(s):
- Russel Loski
Track and Room: Business Intelligence - N/A
Title: Database Design from User Requirements
Abstract: Designing databases from User requirements is an art form even when you focus on implementing a strict ANSI compliant system. There is more to the database design then table structures and T-SQL statements. In this session you will learn how to translate user requirements into a database design which utilizes the new and existing features to create an efficient and manageable system.
Speaker(s):
- Kat Long
Track and Room: Developer - N/A
Title: How Active Directory affects SQL Server
Abstract: If you have ever had a Kerberos or SSPI context error, then you won’t want to miss this session. SQL Server has a large surface area and Active Directory can influence a big part of it. I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server. By the end of the session you’ll have a check list of things to discuss with your domain administrator when you return to work.
Speaker(s):
- Ryan Adams
Track and Room: Bonus - N/A
Title: Agile Data Warehouse Design
Abstract: Ever wonder what should go in a fact table and what belongs in a dimension? Have a suspicion that you’re forgetting important dimensions? Wouldn’t it be great if somehow your design was self-documenting? In this session I’ll give you a couple new tools and show you a new way to look at your star schema. We’ll go past ‘why’ to see ‘how’ dimensional design is a great fit with the agile principles.
Speaker(s):
- Tim Costello
Track and Room: Business Intelligence - N/A
Title: Data Warehouse Mistakes You Can’t Afford to Make
Abstract: Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn’t until you’ve created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system.
Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them.
Speaker(s):
- David Stein
Track and Room: Bonus - N/A
Title: Scaling a SQL Data Warehouse to 100s of TBs
Abstract: Learn how to architect a data warehouse that gets predictable and reliable performance into the HUNDREDS of terabytes. This presentation will focus on both hardware and software best practices for data warehouse specific workloads and will also provide and introduction to Parallel Data Warehouse V2 which scales into multi-petabytes.
Speaker(s):
- Garrett Edmondson
Track and Room: Business Intelligence - N/A
Title: Have You Got the Urge to (T-SQL) Merge?
Abstract: You’ve got data to load into an already existing table, perhaps a slowly changing dimension, and need a method that is simple, supportable, and performs well. The T-SQL Merge statement, introduced in SQL 2008, can do all of this and more. Many DBAs investigate it, but find it unintuitive, time consuming, or they couldn’t get it to perform well. This doesn’t need to be difficult; after attending this session you’ll thoroughly understand the fundamentals of the merge statement and how to write them. You will also leave with scripts which automatically write well formed merge statements for you in less than 1 minute, guaranteed. Come see how.
Speaker(s):
- David Stein
Track and Room: Developer - N/A
Title: Data Warehouse ETL
Abstract: SQL provides many ways to move data from an OLTP source system to a data warehouse server, however choosing the most efficient and scalable ETL solution can be challenging. Various ETL architectures will be explored by analyzing their strengths and weaknesses with data warehouse workloads. Best practices based on having developed ETL systems that load 1+ TB/hr. will be presented.
Speaker(s):
- Garrett Edmondson
Track and Room: Business Intelligence - N/A
Title: Case Studies of Disaster Recovery
Abstract: From the expect disasters of failed hardware, malicious and unintentional data corruption, to the more unusual disasters of HVac failures, water main breaks, and fire, we will walk through case studies of each type, discuss what went right and what went wrong with the disaster recovery plan and how to plan better in the future. This session is intended to be interactive, to have you thinking about your own environment and what you need to put into place to help you successfully recover from disasters.
Speaker(s):
- Kat Long
Track and Room: DBA - 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.
Sean McCown
Twitter: - @KenpoDBA
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
Kristin Ferrier
Twitter: - https://twitter.com/sqlenergy
LinkedIn: Kristin Ferrier
Kristin is a software developer, business intelligence developer, and data architect with 10+ years SQL Server experience. She speaks frequently at local user groups with regional speaking credits including Tulsa Tech Fest and SQLSaturday Dallas.
Matthew Brimer
Twitter: - @sqlcenturion
LinkedIn: Matthew Brimer
Contact: http://www.sqlcenturion.com
Matthew Brimer has 10 years experience with SQL Server, 3 of which was spent as a Database Security expert for a Department of Defense Agency and 5 as the Database/Security Manager for a leading Pharmacy Services Company. These days Matt can be found helping customers get the most out of the Databases/Servers/Networks as a Consultant for InterWorks. Matt also holds several Security and Microsoft Certifications, is the President of OKC SQL PASS Chapter and is the former Event Chair for SQLSaturday Oklahoma City.
David Stein
Twitter: - @Made2Mentor
LinkedIn: David Stein
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
Ryan Adams
Twitter: - @ryanjadams
LinkedIn: Ryan Adams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.
Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
Bryan Smith
LinkedIn: Bryan Smith
Bryan is a Data Solution Specialist with Microsoft Las Colinas, focused on data-driven solutions in the Azure cloud. He also teaches analytics technologies within the MBA amp; MSBA programs at SMU Cox School of Business.
John Sterrett
Twitter: - JohnSterrett
LinkedIn: John Sterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/
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
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
John Sterrett
Twitter: - JohnSterrett
LinkedIn: John Sterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/
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
Rob Sullivan
Twitter: - @DataChomp
Contact: http://datachomp.com
In the early 1900’s, the data world was overrun by architects and project managers. Needing to bring some relief to the industry, then President Taft appointed Rob as the first Data Magistrate. From humble beginnings, he rose to inspire hope and change amongst data stores of all types. He saved countless tuples during the Great Data Civil War of the 90’s and helped found the ORM-pathy group designed to help less fortunate data models get a second chance at production. He currently resides in Okl
Tim Costello
Twitter: - timcost
LinkedIn: Tim Costello
Contact: http://www.timcost.com
Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Garrett Edmondson
Contact: http://garrettedmondson.wordpress.com/
MCITP, MCSE with over 10 years of experience working with Microsoft BI Stack. He has worked as consultant in wide range of industries, with the last 5 of years focused Microsoft’s Parallel Data Warehouse and Fast Track Appliances for large scale data warehouses into the hundreds of terabytes.
David Stein
Twitter: - @Made2Mentor
LinkedIn: David Stein
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
Russel Loski
Twitter: - sqlmovers
LinkedIn: Russel Loski
Contact: http://www.sqlmovers.com
Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.
Kat Long
Twitter: - @KatSQL
LinkedIn: Kat Long
Contact: http://blogs.xtivia.com/
Kat has been working with SQL Server since 1998 starting with SQL Server 6.5 up to the latest and greatest. Over the years, Kat has worked in many different environments from manufacturing to dotcoms to military and government institutions, and is now back in the private sector. Currently, as a Senior DBA at Xtivia, she is focused on monitoring SQL Server installations and troubleshooting performance issues.
Russel Loski
Twitter: - sqlmovers
LinkedIn: Russel Loski
Contact: http://www.sqlmovers.com
Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.
Jennifer McCown
Twitter: - https://twitter.com/MidnightDBA
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
Kat Long
Twitter: - @KatSQL
LinkedIn: Kat Long
Contact: http://blogs.xtivia.com/
Kat has been working with SQL Server since 1998 starting with SQL Server 6.5 up to the latest and greatest. Over the years, Kat has worked in many different environments from manufacturing to dotcoms to military and government institutions, and is now back in the private sector. Currently, as a Senior DBA at Xtivia, she is focused on monitoring SQL Server installations and troubleshooting performance issues.
Allen Smith
Contact: http://www.cognitiveinfo.com
Allen Smith is a business intelligence and data warehouse builder, speaker and trainer. Allen has an MBA in Computer Sciences and has worked in database services and data warehousing since 1998. Allen has a MCTS certification in Business Intelligence. Allen is a Sr. Business Intelligence Lead at Devon Energy. He enjoys sushi, traveling to obscure places, fixing Rubik’s cubes and prefers Marvel over DC.
Garrett Edmondson
Contact: http://garrettedmondson.wordpress.com/
MCITP, MCSE with over 10 years of experience working with Microsoft BI Stack. He has worked as consultant in wide range of industries, with the last 5 of years focused Microsoft’s Parallel Data Warehouse and Fast Track Appliances for large scale data warehouses into the hundreds of terabytes.
Sponsors
The following is a list of sponsors that helped fund the event: