SQLSaturday #149 - Minnesota 2012
Event Date: 09/29/2012 00:00:00
Event Location:
- University of Minnesota - Keller Hall
- 200 Union Street SE
- Minneapolis, Minnesota
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: Using Microsoft Tools for Healthcare BI
Abstract: Based upon experience with implementing healthcare BI solutions for clients with hospital visit data, this presentation will discuss common healthcare BI challenges and review solutions for those challenges using Microsoft tools. A demonstration of how Microsoft BI tools can be used to provide valuable reporting insights will be accompanied by a discussion about architectural challenges with healthcare data. How can there be a unified data warehouse when various departments have different requirements? How can Microsoft BI tools such as SSAS, SSRS, PerformancePoint, Excel, and PowerPivot provide immediate reporting value? Can Performance Measures be built into a BI solution? These questions and more will be reviewed and discussed.
Speaker(s):
- Greg Beaumont
Track and Room: Keller 3-115 - N/A
Title: Creating a Metadata Mart w/ SSIS - Data Governance
Abstract: This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.
Speaker(s):
- Ira Warren
Track and Room: Rapson 56 - N/A
Title: Real Time big data with Microsoft StreamInsight
Abstract: Are you trying to make sense of large amounts of data rapidly flowing past your doorstep? Using Microsoft StreamInsight I will show how we can consume and process information in real time so your business can react to information more rapidly with Complex Event Processing (CEP) applications. Whether you are trying to monitor the stock market for exciting opportunities, keep an eye on the conditions of your warehouse floor, or attempting to trend patterns on social media, StreamInsight gives you a handle on enormous amounts of rapidly changing data.We will start with an overview of Services Oriented Architecture (SOA) and how tools like Microsoft BizTalk and Microsoft StreamInsight can help you intelligently architect your busines
Speaker(s):
- Jeff Krebsbach
Track and Room: Keller 2-260 - N/A
Title: PowerShell 101
Abstract: If you haven’t dug in to PowerShell at this point, you’re missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work.
Speaker(s):
- Merrill Aldrich
Track and Room: Rapson 45 - N/A
Title: Anatomy of a Join
Abstract: A lot of database professionals today do not have a Computer-Science Degree so they never attended a “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans.
Speaker(s):
- Luke Jian
Track and Room: Rapson 43 - N/A
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: Keller 3-210: MVP-MCM - N/A
Title: An Intro to Columnstore Indexes in SQL Server 2012
Abstract: This session will introduce the new xVelocity Memory-Optimized Columnstore Index feature of SQL 2012. This presentation will describe what a column store index is, how this feature is used to store data by columns instead of by rows and compare the advantages and disadvantages between the two storage methods. Live demos will explore how to create columnstore indexes, when to create them, best practices for using them and typical data warehouse scenarios that can leverage the columnstore index to drastically speed up data warehouse queries, in many cases by a factor of 10 to 100, so you are equipped to start implementing this feature into your database environment.
Speaker(s):
- Derek Dai
Track and Room: Rapson 54 - N/A
Title: SQL server 2012 - Contained Database
Abstract: One of the new exciting features of SQL server 2012 is called Contained Database. We will explore what is contained database, what is partially contained database, what are its components, benefits of using it, some of the limitations, contained database authentication and security best practices, and how to migrate a partially contained database.
Speaker(s):
- Sarita Garg
Track and Room: Rapson 54 - N/A
Title: Real-Time Analytics with SSAS Tabular DirectQuery
Abstract: In this session we will explore how SQL Server Analysis Services Tabular running in DirectQuery mode can be used to power real-time analytics. In DirectQuery mode the data is guaranteed to be up-to-date, no refreshing or processing is necessary, because DirectQuery mode queries data that is stored in a SQL Server database. We will provide concepts and step-by-step examples of setting up a BI Semantic Model, including security, best practices for getting the most out of Power View and the differences between DirectQuery and the In-Memory VertiPaq cache, so you are equipped to start building real-time analytics solutions with SSAS and Power View.
Speaker(s):
- Paul Doyle
Track and Room: Keller 3-125 - N/A
Title: Practically Normal
Abstract: Normalizing a database - splitting apart tables into simpler, more focused tables - can yield concrete benefits, including manageability, scalability, and space savings. The concept is a central tenet of a relational database system such as SQL Server, yet far too many database professionals are unfamiliar with it. This session will present a practical primer on normalization: what it is, why it’s beneficial, how to do it, and when not to do it.
Speaker(s):
- Ed Leighton-Dick
Track and Room: Keller 2-260 - N/A
Title: SRS Report Builder for Business Intelligence
Abstract: Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio. See how SQL Report Builder allows creation of executive dashboards that display cash on hand, payables, receivables, sales, and purchase order commitments with drill-downs!
Speaker(s):
- David Eichner
Track and Room: Keller 3-125 - N/A
Title: Getting to Know Index Operation Stats
Abstract: There’s a lot that goes on under the covers of SQL Server with your indexes. But it’s not as secretive as you might think. Most of this information is made available to you through DMVs. While this information is useful - you need a clear understanding of what is in the DMVs in order to understand what is going on. In this session we’ll take a dive into sys.dm_index_operational_stats to find out what it does and what you can do with this information.
Speaker(s):
- Jason Strate
Track and Room: Rapson 45 - N/A
Title: Dimensional Data Model Prototyping With PowerPivot
Abstract: Data modeling is often an abstract exercise involving a lot of talk and diagrams, but little hands-on experimentation. This may still be viable in the world of transactional systems where a lack of source data prevents the modeler from quickly creating a prototype system, however in the world of dimensional modeling where source data is abundant there’s no longer a reason to treat data modeling as an academic exercise. This session will cover how to use PowerPivot for Excel to quickly create prototypes of different dimensional models to try out and discard as necessary. The features of PowerPivot which allow quick import of data from a variety of data sources will also be demonstrated.
Speaker(s):
- Eric Ness
Track and Room: Keller 3-115 - N/A
Title: Break it up! Implement Table Partitioning
Abstract: Tables getting big? Not allowed to delete the data? Consider table partitioning a great way to help manage large tables. It is also useful for implementing a data retention and archiving strategy.
Speaker(s):
- Kirby Richter
Track and Room: Rapson 56 - 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.
Speaker(s):
- Aaron King
Track and Room: Keller 3-115 - N/A
Title: Advancements in CDC with SSIS in SQL 2012
Abstract: There are some great new tasks in SSIS 2012 to take advantage of (CDC) Change Data Capture. I’ll walk you through adding CDC to your database and tables and then updating incremental changes using the New CDC Control Task, CDC Source and CDC Splitter.
Speaker(s):
- MIKE DONNELLY
Track and Room: Rapson 54 - N/A
Title: The Creepy DBA, How to Stalk Your Users
Abstract: Do you know when your users are using the production login accounts from their workstations? Are you aware of changes being made to the development servers that may impact future deployments? Has the new Junior DBA start giving out access like candy? As DBAs, we are responsible for knowing and acting on all of this and much more. Fortunately, SQL Server provides a number of features that you can use to monitor and track user activity. In this session, we’ll look at these features and demonstrate how you can use them to the extent that your users find you creepy!
Speaker(s):
- Jason Strate
Track and Room: Rapson 54 - N/A
Title: The What, Why, and How of Filegroups
Abstract: Having multiple database files and filegroups is one of many strategies to improve performance and make administration easier. What are filegroups, and how do you use them? In this session, I’ll show you how to create filegroups, create objects in them or move objects to them, and discuss how they can help performance. I’ll also cover Enterprise-level features like piecemeal restores.
Speaker(s):
- Jes Schultz
Track and Room: Keller 3-210: MVP-MCM - N/A
Title: GeoGRAPHY and GeoMETRY Spatial Data Types
Abstract: In this session explore the use of the SQL Server spatial data types. We will see an example of the geography spatial data type used to represent data in a round-earth coordinate system. Then the geometry spatial data type which represents data in a flat coordinate system will be demonstrated. Both spatial types are CLR data types and provide a powerful way for businesses; such as; retailers to identify where their shoppers are concentrated, or for call centers to visualize the effect of top performers on others.
Speaker(s):
- Ross McNeely
Track and Room: Keller 2-260 - N/A
Title: Make Your Voice Heard!
Abstract: SQL Server professionals like to talk - a lot. We blog, we tweet, we answer forum questions, and more to help others. Add your voice! Learn about the different ways you can share your experience and knowledge. Once you start teaching others, you’ll realize how much knowledge you have!
Speaker(s):
- Jes Schultz
Track and Room: Keller 2-260 - N/A
Title: Beginners Guide to Execution Plans
Abstract: This session will explore SQL Server Execution Plans. Learn how the server is processing a query, see potential pain points, how to know if an index is needed. This session is designed for intro level DBA’s, designers, programmers or anyone who hasn’t used Execution plans before
Speaker(s):
- Eric Zierdt
Track and Room: Rapson 43 - N/A
Title: SQL Bonsai - Identifying dead schema
Abstract: In order to keep your database schema healthy, you need to trim unused tables from time to time. In this session, we’ll cover how to use the procedure cache and SQL audit to show you where to start pruning!
Speaker(s):
- Ben Thul
Track and Room: Rapson 56 - N/A
Title: MDX Trek: First Contact
Abstract: Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.
Speaker(s):
- Mark Vaillancourt
Track and Room: Keller 3-115 - N/A
Title: Beginning TSQL Tips and Tricks
Abstract: This session will demonstrate tips and tricks that will help you complete tasks fast and efficient using TSQL. This session is targeted at TSQL beginners to SQL Server experts looking to add to their TSQL bag of tricks. The focus of this session will be on leveraging builtin functions, scripts to create scripts, troubleshooting procedures and other uses.
Speaker(s):
- Andy Lohn
Track and Room: Rapson 43 - N/A
Title: Documenting Your Integrated Microsoft BI Solution
Abstract: Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document. In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.”
Speaker(s):
- William E Pearson III
Track and Room: Keller 3-125 - N/A
Title: Advanced Dimensional Design and Implementation
Abstract: Practical, real world implementation of advanced dimensional design concepts using SQL Server Analysis Services 2012. Topics, examples and demos will include the appropriate use of Reference Dimensions, Fact Dimensions,and Many-To-Many Dimensions, to effectively architect and implement SSAS solutions that meet complex business requirements.
Speaker(s):
- Fazel Haris
Track and Room: Keller 3-125 - N/A
Title: Big Data
Abstract: Drill into Microsoft’s Big Data solution and learn how to derive the most value from all your data, including previously untapped unstructured data. Microsoft’s Big Data solution offers breakthrough insights by enabling customers to combine the richness of relational data from databases with unstructured data from Hadoop.
Speaker(s):
- Lara Rubbelke
Track and Room: Keller 3-180 - N/A
Title: Hadoop for the SQL Developer/DBA
Abstract: How does Apache Hadoop fit into our neat tidy database world? In this technical session we’ll examine Big Data through the lense of an SQL DBA/DW guy who became a Cloudera Certified Hadoop Developer. Find out in detail what HDFS and Map/Reduce actually are. Learn what Hadoop really means to the SQL Server Professional. See demos of real-world data tasks that Hadoop can accomplish.
Speaker(s):
- Bill Preachuk
Track and Room: Rapson 45 - N/A
Title: Quest Software Session - TBD
Abstract: Quest Software Session - TBD
Speaker(s):
- Paul Timmerman
Track and Room: Keller 3-180 - N/A
Title: A Window into Your Data: Using SQL Window Function
Abstract: Window functions are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions.
Speaker(s):
- Steve Hughes
Track and Room: Rapson 45 - 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.
Speaker(s):
- Hope Foley
Track and Room: Rapson 43 - N/A
Title: Locks, Blocks, and Deadlocks
Abstract: We’ve all heard these words - but what do they all mean? No - this isn’t about getting boats up a hill, small building bricks, or an uncommon hairstyle. In this session we’ll identify the most common locks and discuss how to leverage and avoid their use. We’ll discuss how these locks can turn into blocks and discuss several techniques that can be employed to insure increase data availability and improve performance. Wrapping up the trio, we’ll discuss what deadlocks are and what they are not as we discuss strategies for both detection and remediation of this often misunderstood concept.
Speaker(s):
- Kyle Neier
Track and Room: Rapson 54 - N/A
Title: Master Data Services
Abstract: Does your company have similar data in multiple locations? Not really sure which set of data is accurate? Want to give subject matter experts the ability to maintain their own data? In this session we will cover SQL Server’s solution to Master Data Management. We will talk about MDS from start to finish including installation, creating models/entities, working with data, using the new Excel add-in, security, hierarchies, views, versions, and business rules.
Speaker(s):
- Jeff Prom
Track and Room: Keller 2-260 - 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.
Speaker(s):
- Aaron Lowe
Track and Room: Keller 3-180 - N/A
Title: Freaky Fast Database Development Tips
Abstract: Join Rick and Dave on this most excellent adventure as they teach you how to get more work done in less time. Leave your checkbook at home, because this is all about maximum productivity with minimum budget. Leave with Visual Studio and SQL Server Management Studio shortcut keys, extensions, and add-ins. We guarantee you will see something you haven’t seen before, or your money back. Co-Presenter: Rick Krueger (@DataOgre)
Speaker(s):
- David Valentine
Track and Room: Rapson 45 - N/A
Title: Resolving Cardinality Estimate Issues
Abstract: When the query optimizer inaccurately predicts the number of rows for query execution plan iterators, performance can suffer due the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed.
Speaker(s):
- Joe Sack
Track and Room: Keller 3-210: MVP-MCM - N/A
Title: Fast Track to Spatial Reporting
Abstract: SSRS 2008 R2 has opened a new realm of reporting possibilities by including the spatial data support. By the end of this session, you should be familiar with the basic spatial concepts, creating map reports in SSRS from different sources, drilling down on map reports, aggregating custom data in the maps and some interesting tips and tricks revolving around them.
Speaker(s):
- Jason Thomas
Track and Room: Rapson 56 - N/A
Title: A Powershell Driven Life
Abstract: Why am I here? This is a question you might ask yourself each day at work. Perhaps its mundane tasks, reactive troubleshooting, or just filling out TPS reports on a Friday afternoon. This session is going to attack the mundane and show you some of the things Powershell can bring to the table for working with SQL Server. From performance monitoring to writing tests, it promises to be entirely scripts and demos compiled from real work on a large OLTP SQL environment . The theoretical will be ignored as well as any common decency towards mass produced beer.
No SSIS or Powerpoint will be harmed during this presentation.
Speaker(s):
- Zach Mattson
Track and Room: Rapson 56 - N/A
Title: Posh Eye for the BI Guy
Abstract: In this session we will explore the many ways that PowerShell can help with all aspects of the software development process. Including Development, Deployment, and Administration. Specific products in the stack covered will be SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). We will spend time going over some basic project structure and configuration management best practices as well. Some previous minor exposure to PowerShell or .Net programming is assumed.
Speaker(s):
- Jason Horner
Track and Room: Keller 3-125 - N/A
Title: Merge Replication for Offline Data Mobility
Abstract: How many times have you been sitting in a meeting and you hear, “We want all our users to have access to the data, 24/7. That includes when they are offline and on a client location”. At this point you may start letting out a large sigh because you are thinking, “How could the user get to the data if there is no connection?” This isn’t as hard as you may think and this session will show how to use SQL Servers Merge Replication in order to accomplish the task. Merge replication offers a scalable option for data mobility. This session will go over how Merge Replication can be used to replicate data to users that spend many hours offline.
Speaker(s):
- Ted Krueger
Track and Room: Keller 3-210: MVP-MCM - N/A
Title: Power View - Bringing your Data to Life!
Abstract: The world of self-service BI just keeps getting better. From self-service analysis with PowerPivot to self-service reporting with Microsoft Power View. This session will discuss the new BI Semantic Model concept, show you how to build models with PowerPivot and Analysis Services, and then go over using the new browser based reporting tool Power View to provide highly interactive reporting solutions. There is fun to be had by all and who knew that analyzing data could be so fun, come and find out more and see how it all works and what to expect with the upcoming release of SQL Server.
Speaker(s):
- Dan English
Track and Room: Keller 3-180 - N/A
Title: SSRS: Reporting on Reports
Abstract: Business Intelligence gets a lot of press these days, but do you often wonder to yourself as you are writing a report, ‘Who is going to use this’? Learn about the rich information that SSRS is already capturing for you about your reports: who is running them and how often, how long do they take to execute, how much time is spent in data retrieval vs rendering, which parameters were passed in, and more…
Co-Presenter: Dave Valentine (@IngeniousSQL)
Speaker(s):
- Rick Krueger
Track and Room: Rapson 43 - N/A
Title: Top Features of SQL 2012 Nobody Told You About
Abstract: This isn’t the same old AlwaysOn demo that everyone else is doing. This is the stuff that almost nobody is talking about, but they are very important features that will save you time, frustration, and even money. These are the top features of SQL Server 2012 that you may not even be aware of. Come learn about these really cool features and see them in action.
Speaker(s):
- Robert Davis
Track and Room: Keller 3-210: MVP-MCM - N/A
Title: Recovering from Corruption
Abstract: Corruption cannot always be avoided. You can take steps to ensure early detection, and you can prepare for the eventuality of it occurring, but it’s not possible to completely prevent it. Early detection is your best protection against data lost due to corruption.
In this session, we will discuss the protections within SQL Server to help identify corruption and to help recover from it. We will look at the different types of corruption that could hit your database and the best way to deal with each type. Includes live demos recovering from different types of corrupt databases.
Speaker(s):
- Robert Davis
Track and Room: Keller 3-180 - 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 Lohn
Contact: http://sqlfeatherandquill.com
Andy Lohn works as a SQL Server Development DBA for Medtronic. He has been working with SQL Server since 1998. Since that time, he has had many titles, ranging from Operational DBA to Special Projects Lead. His specialties include TSQL, Performance tuning, working with very large databases and creating repeatable, scalable solutions.
Paul Doyle
Paul Doyle is a BI Consultant with GNet Group, where he has helped customers in manufacturing, retail and insurance industries successfully implement enterprise data warehouse solutions and self-service BI. With 11+ years of development experience with SQL Server and PerformancePoint. He was a contributing author of the Microsoft white paper, “Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition” AppDev courseware “Microsoft SQL Server 2005 Integration Services “
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
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.
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.
David Eichner
Twitter: - @ICANSoftware
LinkedIn: David Eichner
David Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics amp; Acumatica ERP partner firm that sell and implements ERP and CRM software, develops software solutions and provides technology consulting. He is the host of a radio show called Business In The Cloud that airs weekly on KLAY 1180AM. He is skilled in building integrated cloud app solutions. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP, Acumatica CRM and ERP)
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.
Lara Rubbelke
Twitter: - @sqlgal
Lara Rubbelke brings her passion for architecting, implementing, and improving Azure data solutions to the community as a Principle Software Development Engineer for Microsoft. Many know Lara from her work on the DDP Framework, EPM Framework, and Separation of Duties Framework. Her expertise involves Big Data, analytics, OLTP and DW systems. Lara frequently delivers technical presentations at conferences and events including Build, PASS Summit, SQLBits, and webcasts on Channel 9 and MSDN.
Ross McNeely
Contact: http://mcneelydwbi.wordpress.com
Ross McNeely, BI Practice Manager, C2 IT Solutions
Ross has presented at several SQLSaturday events in Minnesota, Wisconsin, and Iowa. Recently, Ross adds real-world examples from the Financial Services, Logistics, and Retail industries in his presentations. Regardless if you have a beginner, intermediate, or advanced skill set, Ross will provide a solid foundation for each topic he presents. Please join Ross McNeely for a fun and informative meeting.
David Valentine
Twitter: - https://twitter.com/IngeniousSQL
LinkedIn: David Valentine
Contact: http://www.ingenioussql.com
Dave Valentine is a Development DBA with over 15 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 15 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, SQLSaturday Events, and blogging at IngeniousSQL.com.
Jason Strate
Contact: http://www.jasonstrate.com
Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to M
Ed Leighton-Dick
Contact: http://thedatafiles.com
Ed Leighton-Dick is a DBA with ten years of experience in SQL Server and over twenty years of experience in software development and IT. He is currently Senior Database Administrator for GreatAmerica Leasing Corporation in Cedar Rapids, Iowa, and the chapter leader of the I-380 PASS SQL Server User Group. Outside of work, Ed is a devoted husband, father of two beautiful girls, and beginning runner.
Fazel Haris
Over 22 years of experience developing application across multiple platforms including Oracle, Sybase and SQL Server. His last 7 years have been focused on architecting Business Intelligence solutions using Microsoft stack. He has provided technical leadership to deliver robust BI solutions for HCMC, Wilder Foundation, CHS, Lawson, Federal Reserve - NY, RBC, St. Jude Medical, and many more. Fazel has an undergraduate degree in Computer Science and MBA from Carlson School of Management.
Greg Beaumont
Contact: http://blog.gnetgroup.com
Greg Beaumont is a Business Intelligence Consultant at GNet Group. He joined GNet Group in 2009, and has industry vertical experience including healthcare, manufacturing, logistics, retail, and public/government data. His professional focus is upon building industry standard reporting methodologies into BI solutions. He enjoys staying up-to-date with technology related to his career within the world of Microsoft BI.
Steve Hughes
Twitter: - dataonwheels
LinkedIn: Steve Hughes
Contact: http://www.dataonwheels.com
Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.
Sarita Garg
Working at United Health Group as IT Database Consultant Project DBA PLM Lead. Responsible to provide Solution, Design, Delivery of infrastructure build to integrate legacy systems, PLM, and Merger Acquisition systems into managed services. Experienced in databases and business processes related to super computing, finance, marketing, non-profit organization, student services, trucking, CRM, and travel industry. Education BA, BEd, MA, BBBA, AA in CIS and CPPM.
Rick Krueger
Contact: http://www.premierapps.com
Rick Krueger is a SQL Server indie based in the Twin Cities with 17 years of software and database development experience, working with SQL Server since 1998 (6.5). Don’t let his developer credentials (MCPD) and background fool you, he knows a thing or two about SQL, and is currently focusing on Development DBA work. Rick has recently started tweeting as @DataOgre to get more involved in the SQL Community.
Jeff Prom
LinkedIn: Jeff Prom
Contact: http://jeffprom.com/
Jeff Prom is a Data and BI Developer with over 15 years experience. From a wide variety of industries, he has worked at corportations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Silver Bay Realty Trust Corp as a Data Architect in Minnesota.
Jason Strate
Contact: http://www.jasonstrate.com
Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to M
Bill Preachuk
Bill Preachuk, for one, welcomes the advances of our Hadoop Overlords. He is a SQL Server MCTS, and is employed as a DBA/Data Warehouse Designer at Emergent Networks. Bill has been in IT since 1991 and has presented at prior SQLSaturday events in the Twin Cities and Iowa.
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
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.
Paul Timmerman
Contact: http://blogs.lessthandot.com/index.php/author/mndba/
Paul is a Microsoft SQL Server MVP and the Lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has fifteen years of experience in database administration and currently the Chapter Leader of the Minnesota SQL Server User Group, PASSMN. Paul is an active member of the PASS community and routinely speaks at user group meetings and SQLSaturday conferences.
Jes Schultz
Twitter: - http://twitter.com/grrl_geek
LinkedIn: Jes Schultz
Contact: https://blogs.lessthandot.com/author/jes-borland
Jes Schultz is a Software Engineer with Microsoft who has experience with a wide range of SQL Server features from version 2005 through 2019, and is on the cutting edge with Azure technologies. Since graduating Fox Valley Technical College with an IT-Programmer/Analyst degree, Jes has worked as an SSRS developer, DBA, and consultant. Before joining Microsoft, Jes was a six-time Data Platform MVP, recognized for her community work. Jes tackles every project and problem with tenacity and her enthusiasm is unmatched in the SQL Server community. In her free time, Jes never stops moving, and counts fitness, coffee, cooking, and travel as essentials in life.
Zach Mattson
Twitter: - @WIDBA
Contact: http://widba.blogspot.com
Zach Mattson is a reformed DBA turned BI Developer for Trek Bicycle Company in Waterloo, WI. Zach has spoken at multiple community events and been published several times on using Powershell for SQL Server monitoring. He now works from home full time, guarded full time by his yellow labs while developing solutions utilizing the full BI stack of Microsoft tools.
Mark Vaillancourt
Twitter: - @markvsql
LinkedIn: Mark Vaillancourt
Contact: http://markvsql.com
Mark is a Data Solutions Architect for Microsoft, helping organizations design data solutions in Azure. He has been working with Microsoft data technologies since 2007. Before joining Microsoft, he was a Business Intelligence consultant and two-time Microsoft Data Platform MVP. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.
Eric Zierdt
Twitter: - @EricZierdt
LinkedIn: Eric Zierdt
Contact: http://ericemployed.blogspot.com
Eric is a level 70 Data Slayer, who has worked with SQL Server since 2000. Eric has worked with benefit systems, real estate data, marketing, game data, and medical device data. Eric enjoys performance tuning, T-SQL programming, and SQL Server Administration.
Jeff Krebsbach
Contact: http://geekswithblogs.net/jkrebsbach/Default.aspx
Jeff Krebsbach is an MCPD for ASP.Net 4.0 and a Senior Consultant with Superior Consulting Services based in Burnsville, Minnesota. With extensive experience throughout the Microsoft BI stack, Jeff has worked on several applications requiring real time data delivery for financial institutions and billing offices, and helped many companies meet their Business Intelligence needs with Microsoft technologies throughout the twin cities area and across the country.
Robert Davis
Twitter: - @SQLSoldier
LinkedIn: Robert Davis
Contact: http://www.sqlsoldier.com
Robert is a SQL Server Certified Master, MVP, and has spent 17+ years honing his skills in security, performance tuning, SQL development, high availability, and disaster recovery. He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and in various roles at Microsoft specializing in SQL Server administration, development, and architecture. He currently works as a Database Engineer at BlueMountain Capital Management where he spends a vast majority of his time tuning massively parallel queries. Robert feeds his passion for security by acting as co-leader of the PASS Security Virtual Chapter.
Eric Ness
LinkedIn: Eric Ness
Eric Ness has over ten years of experience in IT with a focus on data management and business intelligence on the Microsoft SQL Server platform during the last five. He tackles a variety of BI challenges as a Business Intelligence Consultant at Superior Consulting Services. He also currently serves as the Education Officer for the Minnesota chapter of DAMA. Eric has presented at SQLSaturdays in Minnesota and Iowa as well as Enterprise Data World 2012.
Robert Davis
Twitter: - @SQLSoldier
LinkedIn: Robert Davis
Contact: http://www.sqlsoldier.com
Robert is a SQL Server Certified Master, MVP, and has spent 17+ years honing his skills in security, performance tuning, SQL development, high availability, and disaster recovery. He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and in various roles at Microsoft specializing in SQL Server administration, development, and architecture. He currently works as a Database Engineer at BlueMountain Capital Management where he spends a vast majority of his time tuning massively parallel queries. Robert feeds his passion for security by acting as co-leader of the PASS Security Virtual Chapter.
Ira Warren
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
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
Kirby Richter
Twitter: - @sqlkirby
LinkedIn: Kirby Richter
Kirby Richter is a Minnesota SQL Server Professional with 20 years’ experience. Currently Principal Database Architect at Dell Storage, specializing in Database Administration, large databases and Performance Tuning. Working with all versions of SQL Server since 6.5 Enjoys Development, Database Administration and Business Intelligence. Presents periodically at local events. Hobbies include kayaking, camping and amateur Astronomy.
Joe Sack
Twitter: - @JoeSackMSFT
LinkedIn: Joe Sack
Joe Sack is a Principal Program Manager in the SQL Server product team at Microsoft, with a focus on the Query Optimizer. Joe is an author and speaker with over 18 years of experience in the industry, specializing in performance tuning, high availability and disaster recovery.
Derek Dai
Derek Dai is a consultant at GNet Group with over 8 years of experience in database design, development, and administration using a wide variety of tools and technologies. His focus is on delivering Business Intelligence solutions using the Microsoft SQL Server BI toolset (SSAS, SSRS, SSIS, PowerPivot, BI Semantic Model and Data Mining). Derek holds multiple certifications including Microsoft Certified Trainer (MCT), Microsoft Certified IT Professional (MCITP) and Project Management Professional
MIKE DONNELLY
Twitter: - SQLMD
LinkedIn: MIKE DONNELLY
Contact: http://sqlmd.wordpress.com
Michael Donnelly has been working with SQL Server for 15+ years and holds the MCSE: Data Platform certification. He is an avid runner, blogger, and a wannabe gourmet chef. Currently living the SQL Life on the Jersey Shore.
Ben Thul
Twitter: - @spartansql
Contact: http://www.spartansql.com
Born naked and defenseless, he overcame these obstacles to become a mender of broken things, seeker of magic rings, and occasional watcher of slow pings.
Jason Thomas
Twitter: - @SqlJason
LinkedIn: Jason Thomas
Contact: http://www.SqlJason.com
Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).
Jes Schultz
Twitter: - http://twitter.com/grrl_geek
LinkedIn: Jes Schultz
Contact: https://blogs.lessthandot.com/author/jes-borland
Jes Schultz is a Software Engineer with Microsoft who has experience with a wide range of SQL Server features from version 2005 through 2019, and is on the cutting edge with Azure technologies. Since graduating Fox Valley Technical College with an IT-Programmer/Analyst degree, Jes has worked as an SSRS developer, DBA, and consultant. Before joining Microsoft, Jes was a six-time Data Platform MVP, recognized for her community work. Jes tackles every project and problem with tenacity and her enthusiasm is unmatched in the SQL Server community. In her free time, Jes never stops moving, and counts fitness, coffee, cooking, and travel as essentials in life.
Merrill Aldrich
Twitter: - @onupdatecascade
LinkedIn: Merrill Aldrich
Contact: http://sqlblog.com/blogs/merrill_aldrich/
Merrill is a consultant with the national Digital and Technology Consultancy RBA. In past lives he was a SQL Server DBA for Financial Services and Real Estate Management organizations, a designer of buildings, an expert in three dimensional computer graphics and building information modeling, a speaker, teacher, and visiting lecturer.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
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.
Dan English
Twitter: - @denglishbi
LinkedIn: Dan English
Contact: http://denglishbi.wordpress.com
Dan is a Microsoft Data Platform MVP, author, technical editor, and community leader. He has been developing with Microsoft technologies for over 20 years, and over 15 years with Data Warehousing and Business Intelligence. He has been working with SQL Server since version 6.5 and now using 2017 and in Azure. Dan is the chapter leader for the PASS Business Analytics virtual group and on the executive leadership team for the MN Microsoft BI user group.
Sponsors
The following is a list of sponsors that helped fund the event: