SQLSaturday #256 - Kalamazoo 2013

Event Date: 11/02/2013 00:00:00

Event Location:

  • Kalamazoo Regional Educational Service Agency
  • 1819 East Milham Ave
  • Portage, Michigan

PDF of Schedule

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


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

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.


  • Ira Warren

Track and Room: Room D - N/A

Title: Disabling xp_CmdShell - Is it really a best practice?

Abstract: One of the most recommended “best practices” there is is to disable xp_CmdShell. Whether you’re pro, con, or just a casual user of xp_CmdShell, the first part of this “Black Arts” session will show you why disabling xp_CmdShell might actually be a bad idea depending on what else you do or don’t do. Then, for those folks that have made the extremely grave security mistake of giving users or apps the privs to run xp_CmdShell directly, you’ll learn how to use a very simple method to allow the users/apps to use stored procedures that run xp_CmdShell without them having the privs to run xp_CmdShell directly themselves in a much more secure manner and all without certificates!. If time allows, we’ll also learn a method to greatly simplify PowerShell inputs to a table from T-SQL using only a single extra connection instead of two.


  • Jeff Moden

Track and Room: Wile Auditorium - N/A

Title: Temporary Objects Without Permanent Consequences

Abstract: Temporary objects like Table Variables and Temporary Tables are not inherently bad, but they are overused and misunderstood by many. Increase your understanding and learn when you should favor a Temporary Table over a Table Variable. We will start with the basics, but also look at execution plans to get a better grasp on the cause of those performance differences. Table-Valued Parameters are implemented as read-only Temporary Tables under the covers, and have some solid use cases. Discover how Table-Valued Parameters can be used to: 1) avoid the dynamic sql used by application code (or t-sql string splitting functions) to allow multi-value selection and 2) dramatically reduce the number of round trips between an application and SQL Server.


  • Rick Krueger

Track and Room: Room D - N/A

Title: Maximizing the Data Exploration Capabilities of Power View

Abstract: Would business users in your organization love to get their hands on an interactive, visually-oriented, data exploration tool? If so, Power View may be a useful addition to your BI environment to handle certain types of self-service reporting requirements. In this session we will demonstrate the features and functionality of Power View including highlighting, cross-filtering, play axis, small multiples, tiles, cards, maps, filtering, and exporting.

We will identify which situations Power View is most suited for, as well as its strengths and limitations. Capabilities in SharePoint 2010/2013 vs. Excel 2013 will be reviewed, as well as restrictions on types of data sources allowed. We will also discuss how to prepare a dataset in order to maximize the usability and functionality of Power View.


  • Melissa Coates

Track and Room: Room B - N/A

Title: A World Where All Data Has a Place to Live: Centralizing Distributed Reference Data

Abstract: Have you ever started work on a project only to find that one of your key reference datasets is only available in a spreadsheet on somebody’s desktop? Even worse, you’ve probably run into situations where key data elements are ‘common knowledge’ amongst the business users, but don’t even exist in a spreadsheet.

Take heart. Using Master Data Services (MDS) we now have an effective solution to this problem that has plagued IT for years, without having to create a custom solution. In this session you will learn the basics of MDS, and how it can be used to easily create a home for the homeless data on your latest project. Also, learn how Data Quality Services integration can be used to detect duplicate records, and perform cleansing operations.

Don’t get hung up trying to build a custom solution to house homeless reference data during your next project. Join this session and learn how to use MDS so you can deliver your project on time and on budget.


  • Shane Risk

Track and Room: Room C - N/A

Title: T-SQL: Simple Changes That Go a Long Way

Abstract: Writing TSQL that performs well requires knowledge beyond proper syntax, sometimes it requires more than just knowing TSQL, and sometimes it takes a bit of rework and ingenuity. There are simple things that you will learn in this session that will improve the performance of your queries. Learn about indexing techniques and reading execution plans to see if the optimizer is using the index. Performance isn’t everything though. There are small things you can do to make your TSQL more maintainable too. We will dive into a few TSQL tricks with Common Table Expressions, Table-Valued Parameters, and COALESCE.


  • David Valentine

Track and Room: Room C - N/A

Title: Partitioning for Perf and Mgmt of Large Tables

Abstract: Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.


  • Eddie Wuerch

Track and Room: Room B - N/A

Title: Windows Azure SQL Database Design: Silver Lining and Dark Side

Abstract: Data modelers and designers need to understand the logical, physical, and technical differences in designing for Windows Azure SQL Databases (WASDs) and traditional on-premise SQL Server databases. In this session, we’ll review the concepts that still work in both and the features that need to be tailored to each target environment.

You’ll see demonstrations of the database design processes and gain best practices for model-driven development for each environment, including tool support. We’ll finish up with 5 tips for designing databases for both WASD and SQL Server.


  • Karen Lopez

Track and Room: Room A - N/A

Title: T-SQL : Bad Habits Best Practices

Abstract: Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.


  • Aaron Bertrand

Track and Room: Wile Auditorium - N/A

Title: Manageable SSAS Deployment Strategies

Abstract: When it comes to making changes to your production Analysis Services databases, do you simply open the SSAS DB in SQL Server Data Tools (or BIDS) and click through creating the changes? Does this method lead to problems keeping everything in sync and the right changes deployed to the right environment at the right time? Have you, the BI developer, had to fight to get Production access to do your own deployments?

If you’ve answered “yes” to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.


  • Kerry Tyler

Track and Room: Room C - N/A

Title: SSIS Olympics

Abstract: Did you know that 38 hundredths of a second separated gold and silver in the 4-man bobsledding race at the Vancouver Winter Olympics? What did the right setup mean for the US bobsled team in Vancouver? Everything!!! Choosing the right components and settings can make all the difference in the world. The same holds true for the setup and performance of packages in SSIS. In this demo heavy session, we will glide through parts of SSIS that, when used correctly, will make your packages gold medal contenders.


  • Cory Stevenson

Track and Room: Room B - N/A

Title: Automate Your ETL Infrastructure with SSIS and PowerShell

Abstract: Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it’s easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we’ll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.


  • Allen White

Track and Room: Wile Auditorium - N/A

Title: Periodic Table of DMVs: Collecting Baselines

Abstract: Taking the periodic table of elements into consideration I’ve created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today’s SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In the first version of this presentation we discussed organization of the DMOs - this time around we’re going to get our hands dirty and see how we can use them to collect baselines and plan for consolidations or migrations.


  • Tim Ford

Track and Room: Wile Auditorium - N/A

Title: Five Easy Pieces

Abstract: It’s story time. I explore 5 unrelated recent production episodes I tackled. For each issue, I explain the troubleshooting methods I used, the data I collected, the plan I made and the actions I took. DBAs or DB Developers in attendance will learn about data gathering methods and quick troubleshooting tricks. You’ll learn the easy way some lessons I learned the hard way.


  • Michael Swart

Track and Room: Room A - N/A

Title: Going Spatial

Abstract: Introduction to the spatial features in SQL Server: how to create, procure and leverage spatial data. Learn how to add a spatial dimension to your existing data so you can perform spatial analysis and create engaging maps. You will also be introduced to the tools necessary to integrate spatial data from a variety of sources, such as the Census Bureau, National Weather Service, etc.


  • Frank Murphy

Track and Room: Room D - N/A

Title: Back(up) to Basics

Abstract: Are your databases being backed up? Are you sure? Are you sure they’re being backed up correctly? Maybe you’re an “accidental DBA” or a developer who’s not quite sure of the answers to those questions. In this session, you’ll learn what the different types of basic backups are, how to execute them, and (perhaps most importantly) how to restore from them if and when necessary.


  • Ben Thul

Track and Room: Room D - N/A

Title: Introduction to SQL Server Service Broker

Abstract: In this session, we’ll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We’ll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you’ve ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won’t want to miss this session.


  • Adam Belebczuk

Track and Room: Room C - N/A

Title: My SQL Server is Not Slow for Pete’s Sake! - Server Side Performance Analysis

Abstract: You got the “It’s Slow” call, yeah you know the one. There are many places to dig in and determine how true that is but we’ll focus on what the server thinks utilizing Performance Monitor. We’ll go a bit deep into those facts in the poster on the wall and tell you the what/where/whys of it all. We’ll make sure you understand those items selected and what they mean. We will also go through ways to quickly analyze that mountain of data collected.


  • Hope Foley

Track and Room: Room A - N/A

Title: Designing Formatting Reports

Abstract: You spent 45 minutes making your first report, but now you want more. Of course you do; everyone wants to make things pretty. Using SSRS 2012 we will look into rendering types considerations, conditional formatting, properties you can’t live without, and why standards are good. Full of samples and demos, you can’t miss this one.


  • Tamera Clark

Track and Room: Room A - N/A

Title: Goodbye Next Next Next, Hello Automated Installs

Abstract: Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I’m doing something about it…I’m automating my installs! From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA’s and Developers, I’ll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project). We’ll cover many of the scenarios you may encounter and you’ll walk away with some pre-built install scripts to help get you started.


  • Brian Davis

Track and Room: Room D - N/A

Title: You’re THE DBA. Now What?

Abstract: Are you an accidental DBA trying to find your way through your new role? Are you an experienced DBA moving to a new position, team, or major application? This presentation is for you! In this presentation, we will review best practices for what to do when you’re a brand new DBA. You will learn what to look for when you walk into a new environment, as well as pitfalls to avoid.


  • Gill Rowley

Track and Room: Room B - N/A

Title: You Wouldn’t Let HR Manage Your DBs…

Abstract: So don’t let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel. Presented with Karen Lopez.


  • Joseph D’Antoni

Track and Room: Room C - N/A

Title: Data Flow Architectures in Software Development Life-Cycle

Abstract: The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach.


  • Virginia Mushkatbat

Track and Room: Room B - N/A

Title: Wrangling performance with Resource Governor

Abstract: In this introductory session we’ll delve into the basics of the resource governor feature in SQL Server. We’ll look at the types of issues this feature can help resolve. We’ll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we’ll bring all this together with an example implementation. From there, if time allows, we’ll look at best practices and questions to answer to ensure a successful implementation.


  • Brandon Leach

Track and Room: Room D - N/A

Title: Using Compression to Improve Database Performance

Abstract: Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.


  • Joseph D’Antoni

Track and Room: Room A - N/A

Title: A Big Data Primer

Abstract: The term “big data” dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.


  • Stacia Varga

Track and Room: Wile Auditorium - N/A

Title: Interrogating the Transaction Log

Abstract: Without the transaction log, SQL Server would have no way of maintaining a consistent and durable view of its data. It would be pandaemonium!!! Think of the Stay-Puft Marshmallow Man!

Thankfully the transaction log is there and we can all breathe easier. In this session, you will learn how SQL Server uses the transaction log to maintain the durability and consistency of its data, along with methods for reading the transaction log and identifying active transactions.


  • Frank Gill

Track and Room: Room C - N/A

Title: 45 min to build your first SSRS report

Abstract: Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you’re a DBA and could use a daily report. Either way, I’ve got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it’s all about the output.


  • Tamera Clark

Track and Room: Room A - N/A

Title: DBA 911 - Database Corruption

Abstract: Database corruption is simply a fact of a DBA’s life - if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.


  • David Maxwell

Track and Room: Room B - N/A


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

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

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.

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

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.

David Maxwell

Twitter: - https://twitter.com/dmmaxwell

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.

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.

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.

Adam Belebczuk

Twitter: - @SQLDiablo

LinkedIn: Adam Belebczuk

Contact: http://www.sqldiablo.com/

Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.

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

Karen Lopez

Twitter: - @datachick

LinkedIn: Karen Lopez

Contact: http://datamodel.com

Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.

Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”

Jeff Moden

With more than 51,000 posts and 39 mostly 5 star articles, Jeff Moden is a strong contributor on SQLServerCentral.com where he coined the term “RBAR” (Row By Agonizing Row) and helped make the “Tally Table” a household name. Jeff has more than 2 decades of experience with SQL Server and is mostly self-trained in what he calls the “Black Arts” of T-SQL. He’s known worldwide for his informative articles, high performance T-SQL coding methods, and methods of mentoring. His dedication to helping others earned him the MS SQL Server MVP award for nine years and the RedGate Exceptional DBA Award in 2011. His mantra is “Performance is in the code”.

Brian Davis

Twitter: - @Brian78

LinkedIn: Brian Davis

Contact: http://blogs.sqlsentry.com

Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.

Aaron Bertrand

Twitter: - @AaronBertrand

Contact: https://blogs.sentryone.com/author/AaronBertrand

Aaron, Product Manager at SentryOne, produces performance and optimization tools for the entire Microsoft data platform, as well as Plan Explorer, a free tool for SQL Server execution plan analysis. In his spare time, he is either playing volleyball, curling, blogging at sqlperformance.com and blogs.sentryone.com, or contributing to SQL Server conversations on Twitter and dba.stackexchange.com. He has worked with SQL Server since 6.5 and has been an MVP since 1997.

Tamera Clark

Twitter: - https://twitter.com/tameraclark

LinkedIn: Tamera Clark

Contact: http://tameraclark.com

Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.

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.

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

Tamera Clark

Twitter: - https://twitter.com/tameraclark

LinkedIn: Tamera Clark

Contact: http://tameraclark.com

Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.

Rick Krueger

Twitter: - https://twitter.com/dataogre

LinkedIn: Rick Krueger

Contact: http://www.dataogre.com

Rick Krueger has been working with SQL Server as either a Developer or a Development DBA for over 20 years. He is a veteran Independent Consultant, Lead Development DBA and BI Developer based in the Twin Cities. Rick is giving back to the SQL Community by being an active member and presenting at PASSMN, blogging at DataOgre.com, and presenting at SQLSaturdays in the MidWest.

Melissa Coates

Twitter: - https://twitter.com/SQLChick

LinkedIn: Melissa Coates

Contact: https://www.CoatesDataStrategies/blog

Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa’s website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

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

Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.

Cory Stevenson

Twitter: - @CoryGStevenson

LinkedIn: Cory Stevenson

Cory Stevenson, a Business Intelligence Consultant for BlueGranite, Inc., has worked with technology for over 10 years. He has specifically worked with SQL Server 2000 on up; in addition, his interests include SSIS, SSAS, SSRS, DQS, and MDS. Cory is an active member of the Ohio North SQL Server User Group. You can find him on Twitter at @CoryGStevenson.

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.

Shane Risk

Contact: http://www.blue-granite.com/

Shane is a veteran business intelligence consultant specializing in the Microsoft BI stack. Over the past 6 years he has helped numerous companies implement industry leading business intelligence solutions to empower individuals at all levels of the organization. Shane’s passion is to help clients use their data to gain a competitive advantage in an information driven world.

Ira Warren

 Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.

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.

Virginia Mushkatbat

Contact: http://mask-me.net

Virginia Mushkatblat is currently a founder of Hush-Hush, a data masking company. She wrote her first computer program at the age of 14 and has been in technology ever since, progressively rising through the ranks and trying on different hats including database architecture, development, security and operations. She has worked for Startups and Fortune 100 companies in finance, entertainment, e-commerce, internet advertisement, manufacturing, and communications industries and dealt with both heavily transactional and BI applications.She holds B.S. and Masters Degrees in Engineering and in Computer Science, originated a couple of patents, and currently teaches databases and multimedia to graduating seniors in CSUN, her Alma Mater.

Michael Swart

Contact: http://michaeljswart.com

Michael J Swart is an active blogger and SQL Server MVP since 2012. He works as a database developer in Kitchener, Ontario, Canada.

Frank Murphy

Twitter: - https://twitter.com/dfmurphy20

LinkedIn: Frank Murphy

Contact: http://www.baldmanrunning.com

Brotherhood Mutual is a nation-wide property/casualty insurer that focuses on churches and related organizations. Frank works in the Enterprise Risk Management department as a Geospatial Analyst, where a large portion of his duties involves manipulating spatial data.

Gill Rowley

Twitter: - @BadgerBully

LinkedIn: Gill Rowley

Contact: http://gillrowley.wordpress.com

I#39;m a SQL Server DBA and Business Intelligence Consultant with over 10 years experience working with all versions of SQL Server dating back to SQL Server 7.0. When not playing with SQL Server I spend my time hunting, fishing, weightlifting, relaxing on my boat, playing men#39;s fast pitch softball, and playing with my rescued bull terrier Lola.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page