SAVE $150 and support PASSMN by registering with our PASS Summit 2015 Discount Code >> LC15TNJ3 <<
Abstract: Data Warehousing and ETL processes have become standard at most businesses, but testing ETL processes remains difficult and less refined than testing in conventional OO application development. This session will offer practical tools, techniques and discussion of how to make ETL development more test-centric, and improve the quality and agility of data warehouse work. We will look at techniques to automate warehouse testing/data validation and how to move ETL requirements toward something resembling test-driven design, even when the data sources span different applications or technologies.
About Merrill: Merrill Aldrich is a consultant and DBA with RBA Consulting, Minneapolis
Abstract: Properly managing indexes for a database is a common use in many environments. When reviewing an index, should it have a single or multiple columns? Should the table be a heap, a clustered index or clustered columnstore index? These considerations are often at the forefront when analyzing your indexes. In this session, we'll look at easy methods for identifying new indexes, we'll review patterns for index consolidation, and discuss how and when to remove indexes. At the end, you'll have a strategy that helps design indexes to improve performance.
About Jason: Jason Strate is a Microsoft SQL Server MVP. He is a highly-skilled database administrator with a strong background in database/data warehouse architecture and best practices, business analysis, mentoring and leadership. He has recently worked with a number of clients to review and analyze their SQL Server environments and make recommendations related to performance improvement and reliability.
Abstract: Trent will discuss wait state analytics and how to find which statements hitting your SQL Server will give you the most benefit when tuned. Methods to find bottlenecks at both the server resource and individual statement level will be discussed. Native utilities for accomplishing this will be covered first, and then we will take a look at two Dell Software Tools that use these approaches: Spotlight on SQL Server and Performance Analysis for SQL Server.
About Trent: Trent Mera has been a Systems Consultant with Quest and Dell Software for 8 years, helping customers to understand, evaluate and use administrative and performance management tools for SQL Server.
Prior to Quest/Dell, he worked as a development and administrative DBA in the Real Estate, Finance and Defense industry for 7 years.
Abstract: In this session, we will travel the course of how some organizations are embracing the concept of a Modern Data Warehouse by unifying different technologies for handling large volumes of data. Parallel Data Warehouse, or PDW, is a solution that offers high performance data warehousing using the MPP architecture and ability to reach over and combine data from the Hadoop platform. We will learn how this technology works and offers extreme performance and yet a very easy platform to manage for the DBA, Infrastructure, and Developers alike.
About Mike: Mike Fulkerson is a Technology Specialist at Microsoft who helps customers plan and design solutions on the Microsoft data platform. He has a diverse background in application development, database operations, data warehouse design, BI, ETL, and network engineering.
Previous to his current role with Microsoft, Mike held the title of Director at UnitedHealth Group. In this role, he was the technical leader on an enterprise-wide business intelligence initiative using products like APS, SQL Server, and ASP.NET. His past employment includes Northwest Airlines, Bluestem Brands, Sogeti, and Microsoft as a consultant in MCS and before that as a software development engineer in Redmond working on a team that started Expedia.com. He has been working with SQL Server since version 6.5 and extolling the virtues of Microsoft's data platform across a variety of organizations and industries for the past 17 years.
Abstract: It is no accident the term “Business Intelligence” starts with “Business.” Any Business Intelligence initiative should, likewise, start with the needs of the Business. For many years, BI was seen as a technology project. This is one reason why so many BI initiatives fail. Rather than a Technology Project, BI is a Business Program. It must grow and evolve as the Business grows and evolves. In this session, we will discuss the following:
About Mark: Mark Vaillancourt is a SQL Server MVP and a Business Intelligence Enterprise Consultant for Digineer, a Microsoft partner based in Plymouth, MN. He has been working with SQL Server since 2007 and holds the MCITP – Business Intelligence Developer 2008 certification. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.
Abstract: The Ola Hallengren scripts cover backups, index and stats maintenance, and checkdb. This will also include an explanation of how Tony has integrated the suite into the maintenance routines at multiple sites, plus the use cases for when the suite is (and maybe isn't) a good fit. And it fits into any budget: it's free!
About Tony: A SQL Server DBA with 19 years experience in data management and development, dev group management, infrastructure, ERP, and compliance. He has kept the data flowing in industries ranging from collectibles to biofuels, groceries to HVAC.
Abstract: Learn how to make BI really work for you with Power Query in Excel. In this session, you'll see how to make business intelligence truly actionable for your end users by mashing data together that might seem unrelated at first. You'll find out how to use the Power Query platform to take data from tables in websites and mash it with data in proper relational databases. Then, see how to present the data to end users with Power BI.
About Brian: SQL Server MVP, MCITP, is the co-founder of SQLServerCentral.com, JumpstartTV.com, and was on the Principal Board of Directors of the Professional Association for SQL Server (PASS). Brian is a contributing columnist for many industry magazines and sites. He has co-authored and authored more than 15 technology books. Brian has spoken at dozens of conferences like PASS, SQL Connections and TechEd and many Code Camps.
About Dave: A Development DBA with over 10 years of experience with SQL Server and development technologies, specializing in Business Intelligence and ingenious solutions. Dave has also been an Adjunct Professor at Metropolitan State University for the past 10 years educating students in Database Management and Application Development.
Dave started giving back to the SQL community a few years ago by presenting at Local PASS Chapters, SQL Saturday Events, and blogging at IngeniousSQL.com
Abstract: You’re the DBA, the guy in charge, the guy who gets pounced on first thing in the morning with complaints of “my report took FOREVER to run last night, why?”, or “customers are saying the web site was really slow at 3:00am this morning, why?”. You’re expected to be able to answer questions like that. Can you? Do you know what your servers are doing when you’re not looking? By the end of this presentation, you'll be able to answer those questions. You'll come away with scripts to collect information on what your servers are doing, what they're waiting on, as well as scripts to help analyze that collected information.
About Tracy: Currently a Principal Data Architect with Pearson VUE, crossing over to the development dark side after two decades as a production DBA. He blogs frequently, has spoken at several SQL Saturday events, and is active on social media. When not working with SQL Server, he might be found working on his model railroad, honing his photography skills, running, playing pickleball, or deeply immersed in some sort of home improvement project.