SQLSaturday #118 - Madison 2012
Event Date: 04/21/2012 00:00:00
Event Location:
- Madison Area Technical College - Truax Campus
- 3550 Anderson St
- Madison, Wisconsin
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: You’re My Density: Making Sense of Statistics
Abstract: The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.
Speaker(s):
- Erin Stellato
Track and Room: Room 321 - N/A
Title: Devs are from Mars, Report Servers are from Venus
Abstract: Do you remember what it was like to fall in love? Wasn’t it wonderful?
Lately it hasn’t been the same. There’s no spark anymore. You’ve been stuck doing the same old charts and tables. Maybe Reporting Services won’t tell you what’s wrong, and you’re even thinking about seeing other reporting products.
In this session, Doug will re-ignite your passion for RS by reminding you how reports perform best, what RS has been trying to tell you (but you haven’t been listening), and show you some new – and easy – tricks you may not have known RS can do. You’ll leave knowing more about troubleshooting using the execution log, understanding how to design reports for high performance, how to deal with blank pages, and more.
Speaker(s):
- Doug Lane
Track and Room: Room 350 - N/A
Title: Administering the BI Stack
Abstract: More often than not, a SQL DBA will also be requested (or required) to administer other applications in the SQL universe. These applications are often the BI stack, SSIS, SSRS, and SSAS. In this session, you will learn not only what each of these applications does, but also some behind the scenes views into how they work. At the end of this session, you will have a better feeling of what to look for when something goes wrong, and have the knowledge to be proactive with your Business Intelligence implementations.
This session will focus on the SSIS, SSRS, and SSAS engines in this session. Not a session for developers, we will be focusing on the ADMINISTRATION of these applications/services only.
Speaker(s):
- Josh Fennessy
Track and Room: Room 142B - N/A
Title: Minimal Processing for Large Cubes
Abstract: Processing large cubes can consume vast amounts of IO, and create lengthy response times. This presentation will demo how to process dimensions and dynamically create, process, and delete measure group partitions to minimize IO. By taking control of cube processing through a SSIS package you are able to process only the bare minimum in order to bring a cube current while keeping response times acceptable. Additional areas to cover will include the support tables to control cubes, and a review of the XMLA for creating, processing, and deleting. This method is also helpful for processing many smaller cubes.
Speaker(s):
- Ross McNeely
Track and Room: Room 350 - 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: Room 142A - 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: Room 350 - N/A
Title: Upgrade Roadmap: Let’s delve into SQL Server 2012
Abstract: We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them
Speaker(s):
- Craig Purnell
Track and Room: Room 142B - N/A
Title: Data Visualization in Reporting Services
Abstract: Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what’s new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.
Speaker(s):
- Stacia Varga
Track and Room: Room 322 - N/A
Title: Holy Crap! Someone Put the Database in the Cloud
Abstract: The world of databases is constantly changing. It used to be that we kept all of our servers and data locked up in big, expensive server rooms in the back of the building. Now days, you hear about data existing in this cloud-thing. So what happens when you come in on Monday morning and the latest database was deployed in the cloud. In this session, we’ll look at what it means to be a DBA with SQL Azure and how the more things change the more they stay the same.
Speaker(s):
- Jason Strate
Track and Room: Room 321 - N/A
Title: (Way Too Much) Fun with Reporting Services
Abstract: Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch and cheer as SQL Server MVP Stacia Misner is challenged by her progeny and protégé Erika Bakse to an hour of word play, all wrapped up in SQL Server Reporting Services. They’ll push the limits with what can be built in SSRS and have a stupid amount of fun while doing it. Swag, trash talk, board games and SQL…who could ask for more?
Speaker(s):
- Stacia Varga
Track and Room: Room 321 - N/A
Title: The Skinny on Data Compression
Abstract: SQL Server’s data compression feature can be a great tool for both getting more bang out of your storage dollar and increasing query performance. In this session we’ll cover the different types of data compression, the nitty-gritty behind how they work, and how to make sure you’re getting the most out of them.
Speaker(s):
- Bob Pusateri
Track and Room: Room 142A - N/A
Title: Asynchronous programming with Service Broker
Abstract: In this session we will explore Service Broker, one of the lesser known features available since Microsoft SQL Server 2005. This technology provides a robust asynchronous programming model and can be reliably used to develop lightning fast applications that scale very well and can boost your application’s throughput. We will look at a few examples of real world service broker implementations in OLTP as well as batch processing modes. We will also discuss some of the commonly used tools for troubleshooting a service broker set up, as well as few common pitfalls to avoid .
Speaker(s):
- Sanil Mhatre
Track and Room: Room 336 - N/A
Title: Scriptable UI with PowerShell
Abstract: Sick and tired of typing at a command prompt or scrolling through buffers of text output? ShowUI (an open source PowerShell Module) is a great tool for quickly and easily creating great looking UI with all the power of PowerShell behind it.
Speaker(s):
- Steven Murawski
Track and Room: Room 142B - N/A
Title: SSIS: Figuring Out Configuring
Abstract: As with most things in the IT world there is more than one way to skin the SSIS configuration cat.* I’ll focus on SQL Server 2008 methods (being called Package Deployment method in SQL 2012) and show how to use 1)XML config files or 2)an environment variable or registry entry that points to a config database. I’ll also give a brief overview of the new project deployment method in SQL 2012.
*[No cats were skinned in the making of this presentation.]
Speaker(s):
- MIKE DONNELLY
Track and Room: Room 336 - N/A
Title: 10 Ways To Abuse T-SQL
Abstract: Learn 10 common T-SQL mistakes and how to avoid them. Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we’ll cover.
Speaker(s):
- Tracy McKibben
Track and Room: Room 142B - N/A
Title: DBCC Commands: The Quick and the Dangerous
Abstract: There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily.
Speaker(s):
- Erin Stellato
Track and Room: Room 321 - N/A
Title: Filegroups: Putting the Puzzle Together
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: Room 321 - N/A
Title: Performance Monitoring and Tuning in SSAS
Abstract: As SQL Server Analysis Services becomes commonly used in various business intelligence solutions, many administrators are looking for ways to monitor and tune performance on the platform. This session will cover various monitioring techniques and tools and how to use that information to tune Analysis Services.
Speaker(s):
- Steve Hughes
Track and Room: Room 142A - 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: Room 142A - 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: Room 142A - N/A
Title: Performance Enhancing Laziness
Abstract: Walk-up work. New database requests. Users running ad-hoc queries with 18 LEFT OUTER JOINS against heaps. Suprise SQL instances created by vendors without our knowledge crashing around us! It’s enough to drive a lesser DBA crazy-insane. That’s why it’s important to take as many steps as you can to simplify, automate, tweak, and tune the tasks you can manage so you have time to deal with those situations you can’t control. In this session Tim will go over many of performance-enhancing methods he’s developed over the last dozen years as a DBA for a major healthcare concern and show you how you can give yourself some breathing room to make the difficult seem easy.
Speaker(s):
- Tim Ford
Track and Room: Room 322 - N/A
Title: SSMS for Non-DBA Developers
Abstract: You’re a database application developer who’s using SQL Server now, but you’re no DBA. Sure you use SQL Server Management Studio (SSMS), and maybe you’re even pretty good at designing tables and executing queries. But there’s a whole lot more functionality in this seemingly simple program than you may realize. In this session we’ll share features in SSMS that you may have overlooked but will make your life as a developer a lot easier.
Speaker(s):
- Eric Selje
Track and Room: Room 142B - N/A
Title: 2012 TSQL Sweets
Abstract: The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you’ll have a taste for all the sweets they’ve packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.
Speaker(s):
- Bill Fellows
Track and Room: Room 321 - N/A
Title: TempDB Performance Troubleshooting and Optimizing
Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.
Speaker(s):
- Eddie Wuerch
Track and Room: Room 322 - 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: Room 336 - N/A
Title: SSIS 2012 New Features
Abstract: The new version of SQL Server is just around the corner, so let’s take a look at what’s coming to SSIS. We’ll cover the enhancements to deployment, reporting, development and performance. We’ll also cover what’s been removed. This will be based on the RC0 release of SQL Server 2012.
Speaker(s):
- Norman Kelm
Track and Room: Room 336 - N/A
Title: Database Development using SQL Server Data Tools
Abstract: SQL Server Data Tools (SSDT) formerly known as Project Juneau is the next iteration of Visual Studio for Database Professionals aka DataDude. Let’s chat about some of the great new features, and some of the features that aren’t so great.
Speaker(s):
- Aaron Lowe
Track and Room: Room 322 - N/A
Title: SQL 2012 AlwaysOn Configuration Deep Dive
Abstract: Brief overview of AlwaysOn features, then dive into what you need to consider when implementing these new features. This session will be interactive, with demos and systems refer to. Bring ideas and questions on how to make this work in the real world. We will discuss the entire infrastructure needed to support DR and HA, and why you need to have a very good understanding of AD to have a successful implementation. We may even break out a white board!
Speaker(s):
- Michael Steineke
Track and Room: Room 322 - N/A
Title: Setting up an ETL Framework with SSIS 2012
Abstract: In this session we will look at common elements of an ETL framework including logging, auditing and configuration. We’ll dive into the new features within SSIS 2012 and how they facilitate a solid ETL framework.
Speaker(s):
- Dave DuVarney
Track and Room: Room 350 - N/A
Title: Deep Dive in PowerPivot 2012
Abstract: A demo-rich presentation of PowerPivot 2012
Speaker(s):
- Farouq Abukhamireh
Track and Room: Room 336 - N/A
Title: Optimizing SQL Server I/O with Solid State Drives
Abstract: Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure
Speaker(s):
- Luke Jian
Track and Room: Room 336 - N/A
Title: Demystifying PowerPivot from the SharePoint Admin
Abstract: Demystifying PowerPivot from the SharePoint Admin Perspective. PowerPivot can be a maddening undertaking to the SharePoint Admin. We’ll walk through the basic architecture of PowerPivot within SharePoint. Then we’ll setup an actual working PowerPivot and store it in SharePoint. We’ll also walk through setting up the PowerPivot Refresh. Along the way David will share anecdotes, tips hints, SharePoint war stories, and the occasional movie quote.
Speaker(s):
- David Peterson
Track and Room: Room 350 - N/A
Title: Free SQL tools for your toolbox
Abstract: Every SQL developer or DBA should have a fully stocked toolbox that they can turn to in times of need. SQL Server enjoys a wide variety of support from 3rd party vendors that provide tools to help us peek under the hood and pinpoint issues. Sometimes we either don’t have the budget for everything we would like, or we need something for a one-off project. In this session we will examine some of the free tools published by members of the SQL community and 3rd party vendors.
Speaker(s):
- Kevin Bullen
Track and Room: Room 142B - 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: Room 350 - N/A
Title: A Window into Your Data:Using SQL Window Functions
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: Room 142A - N/A
Title: SQL 2012 – All About HA and DR
Abstract: Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don’t know where to start. In this presentation you’ll learn all about the new DR features in SQL Server 2012 and see them in practice.
Speaker(s):
- Joseph D’Antoni
Track and Room: Room 322 - 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.
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.
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”.
Josh Fennessy
Senior Business Intelligence Consultant at BlueGranite, Inc., Josh Fennessy has been working with the Microsoft BI stack exclusivley for the last 5 years. He has earned MCITP in both SQL 2005 and SQL 2008 versions of the tools. Josh is also the chapter leader of the West MI SQL Server Users Group.
When he’s not building BI solutions, he enjoys spending time with his 6 year old son, slinging lead at the range, and exercising (but never in his underwear. Promise!)
Tim Ford
Twitter: - @SQLAgentMan
LinkedIn: Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
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.
Stacia Varga
Twitter: - @StaciaV
LinkedIn: Stacia Varga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.
Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
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
Dave DuVarney
Contact: www.duvarneyconsulting.com
Dave DuVarney is an independent BI consultant and trainer. He has broad technical and functional BI knowledge. He has worked with organizations across the full BI lifecycle. He has helped clients establish their BI Program and run Agile development teams. Dave’s technical skills includes SSAS, SSIS, SSRS and .NET.
Norman Kelm
Contact: http://www.gerasus.com/
Norman Kelm is the owner of Gerasus Software, http://www.gerasus.com/, the maker of SSIS-DTS Package Search the only utility that can search SSIS and DTS packages. Norman has been working in IT for over 20 years. He worked as a FORTRAN and C developer for 8 years before making the jump to databases with Sybase. He then moved on to SQL Server working as a production and development DBA on SQL Server since version 6.5. He is also a founding member of the Tampa Bay SQL Server User Group.
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
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).
Stacia Varga
Twitter: - @StaciaV
LinkedIn: Stacia Varga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.
Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
Tracy McKibben
Twitter: - @RealSQLGuy
LinkedIn: Tracy McKibben
Contact: http://realsqlguy.com
Database background extending back to 1994, includes Clipper, FoxPro, dBase, all versions of SQL from 7.0 forward.
Currently managing a team of production DBAs for Pearson VUE, and serving as the Director Of Program Development for PASSMN.
David Peterson
Contact: http://www.sharepointrookie.com
I’m David Peterson and I am a SharePoint nerd.
David is the SharePoint Administrator for Trek Bicycles in Waterloo, WI. Prior to Trek, he was a consultant for TEKSystems inhouse at State Farm Mutual Insurance in Bloomington, IL from 2008-2011.
Doug Lane
Contact: http://www.douglane.net
Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years’ experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.
Erin Stellato
Twitter: - erinstellato
LinkedIn: Erin Stellato
Contact: http://www.sqlskills.com/blogs/erin
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
Eddie Wuerch
Twitter: - @EddieW
LinkedIn: Eddie Wuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
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
Kevin Bullen
Twitter: - sqlpadawan
LinkedIn: Kevin Bullen
Kevin has been working with SQL Server since 2006, as a application developer, SQL developer, and Database Administrator. He is currently a Premiere Field Engineer at Microsoft. When he’s not working, he’s usually hiding in his garage working on one of his jeeps.
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.
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.
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.
Bill Fellows
Twitter: - @billinkc
LinkedIn: Bill Fellows
Contact: http://blog.billfellows.net
Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City’s eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.
Eric Selje
Contact: http://www.geeksandgurus.com
Eric Selje is a consultant in Madison, WI who works on a wide variety of applications, from desktop to intranet to internet to web - all of them requiring databases. Eric has worked for government and private businesses, and is now consultant specializing in line-of-business data applications. He has been a user group leader since 1995, and other than coding he loves playing Ultimate and baseball, doing crosswords and reading.
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.
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.
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.
Ira Warren
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
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.
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.
Erin Stellato
Twitter: - erinstellato
LinkedIn: Erin Stellato
Contact: http://www.sqlskills.com/blogs/erin
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
Farouq Abukhamireh
Twitter: - @AskFarouq
LinkedIn: Farouq Abukhamireh
Contact: http://www.blogger.com
Farouq Abukhamireh is a Microsoft Business Intelligence Architect and a Microsoft Certified Trainer (MCT) who is focused on Microsoft’s Business Intelligence (BI) stack (Power BI, Azure, SSAS, SSIS, SSRS, MDX, DAX, Excel Services, PowerPivot, PowerView and SharePoint). Farouq is a seasoned Information Technology professional with 21 years of experience developing innovative solutions using Microsoft technologies. Farouq works as a consultant with Dicense LTD.
Bob Pusateri
Twitter: - @SQLBob
LinkedIn: Bob Pusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
Steven Murawski
Contact: http://blog.usepowershell.com
Steven is the Senior Windows System Engineer for Edgenet and a Microsoft MVP in PowerShell. In this role, he supports a dynamic infrastructure that pushes the boundaries of the Windows platform. Steven also leads two local user groups, the Greater Milwaukee IT Pro User Community and the Greater Milwaukee Script Club. He speaks regularly to local user groups and can be found at various conferences.
Michael Steineke
Twitter: - @MSteineke
LinkedIn: Michael Steineke
Contact: http://www.michaelsteineke.com
Michael Steineke is a Windows Server Platform expert with an industry-wide reputation as an innovator in the areas of Windows Server, storage and network architecture, disaster recovery, datacenter configuration, and SQL Server. He is a Cloud and Datacenter Management MVP specializing in High Availability and has spoken on subjects like Windows Server, clustering, Storage, Hyper-V, SQL Server, and multi-site clusters at user groups and conferences of all sizes, including SQLSaturdays, SQL PASS Summit, Microsoft TechEd, and the Microsoft MVP Summit.
Sanil Mhatre
Contact: http://sqltrekker.blogspot.com/
I started my Career in IT as a Java developer on a large web development project, when the proverbial “accidental DBA” curse was cast upon me. I spent the next 3 years playing the role of an Oracle DBA, before going back to school full time to purse a Masters Degree in Information Systems. I have been a Database Developer for the past 3 years, working mainly with Microsoft SQL Sever, with an occasional helping of Oracle DB2. I am an active member of the St.Louis SQL Server User Group.
Sponsors
The following is a list of sponsors that helped fund the event: