SQLSaturday #60 - Cleveland 2011
Event Date: 02/05/2011 00:00:00
Event Location:
- Midpoint Campus Center
- 50 Pearl Road
- Cleveland, Ohio
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: (SSIS, TSQL and MDS) - Record Linkage(Fuzzy Match)
Abstract: We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms.The steps are as follows: 1. Cleansing and standardization 2. Group records 3. Split records 4. Compare records and determine scores 5. Split into separate match categories 6. Analyze results of matches 7. Evaluate using match tools to determine if best algorithms have been combined.
Speaker(s):
- Ira Warren
Track and Room: Room 315 - N/A
Title: Drive SQL Server Performance: I/O For Developers
Abstract: An often-overlooked aspect to data optimization is what is happens under the covers – how does SQL Server store and access data? There are plenty of common rules covering tuning, but this session looks at data access from the physical layer, detailing how table access and indexes work, showing why some designs perform poorly, and why adding more indexes may not help. This will not be a discussion of normal forms or design rules. Instead, it will be a technical session providing the foundation for you to choose which concepts to apply to your designs. The session starts with the notion that SQL Server is not a magic box – most of what happens is well-documented and must be taken into consideration when designing or tuning databases.
Speaker(s):
- Eddie Wuerch
Track and Room: Room 325 - N/A
Title: PowerPivot: BI Massive Data Analysis for Humans
Abstract: The paradox of Business Intelligence: it’s one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow?
In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience ( range of applications). The only prereqs: curiosity, and fondness for numbers :)
I will explain how PowerPivot impacts benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q’s as you can muster :)
Speaker(s):
- Rob Collie
Track and Room: Room 329 - N/A
Title: Gathering and Interpreting Performance Metrics
Abstract: To begin tuning your system and the queries that run on it, you must begin from a position of knowledge. The knowledge I’m talking about is knowing what is occurring on your systems. What kind of load is the server under? How many times is that stored procedure called? This session will present the basics of gathering and interpreting knowledge about your server and the queries running on it. We’ll cover a variety of topics from performance monitor, to server-side traces, to dynamic management objects. We’ll go over how to set these things up to monitor your system and how to interpret the data returned from them. This session is part of a full day of training which will be presented in May at SQL Rally in Florida.
Speaker(s):
- Grant Fritchey
Track and Room: Room 330 - N/A
Title: As a DBA, Where Do I Start?!
Abstract: You’ve always wanted to get promoted into the DBA position. The good news is you got it - the bad news is you have no idea what to do first. What’s important, what’s not a big deal, and what can get you fired if you’re not careful? If your answer wasn’t, “update my resume”, then this session is a good start. We’ll chat about a natural priority for the overwhelming flood waiting in our offices. By focusing on a few words ending in “ity” we’ll realize what is most important. Through the interaction, stories and examples you’ll leave feeling ready to attack your environment. Be warned – along the way to knowing where to start, you may get that feeling in your stomach that makes you log on to the VPN to check a few things out.
Speaker(s):
- Mike Walsh
Track and Room: Room 330 - N/A
Title: Who’s responsible? The vendor or the DBA?
Abstract: Database administrators - you don’t really trust your third party software vendors, do you? Software vendors - you think most of the DBAs out there are hiding things, don’t you? Well guess what, you’re both right! Join Erin Stellato (representing vendors) and Mike Walsh (representing customers) for an interactive session where they will tackle some of the toughest challenges that DBAs and vendors face. Attendees will walk out with a better understanding of what both parties can do to contribute to a successful relationship, as well as a set of fair questions to ask to set the right expectations from the start.
Speaker(s):
- Erin Stellato
Track and Room: Room 313 - N/A
Title: Using SQL Azure in an SSMS Addin
Abstract: The Cloud is fast becoming the latest hot topic in the technology arena. We need to understand how we as SQL Developers and Administrators can utilize SQL Azure, Microsoft’s platform for relational data storage in the Cloud, to meet our needs. It doesn’t always have to be full sites deployed to the Cloud, it could also be “hybrid solutions”, with a Client tool accessing a Cloud database. That is what will be demonstrated in this talk: A step-by-step demo of how to obtain an Azure subscription, create and administer a SQL Azure database, and work with it from your own SQL Server Management Studio Addin. The end result is an Addin in SSMS that uses the SQL Azure Cloud as a common script repository.
Speaker(s):
- Jeff Mlakar
Track and Room: Room 314 - N/A
Title: Build Your Own Search Engine With SQL Server
Abstract: SQL Server 2008 once again improves on the classic built-in SQL Server full-text search (FTS) functionality by making FTS more efficient and transparent. In this course attendees will learn both the basics of the new Integrated FTS (iFTS) and how to build user-friendly Google-style search interfaces on top of SQL Server for the benefit of their end users.
Speaker(s):
- Michael Coles
Track and Room: Room 314 - N/A
Title: The “Tally” Table High Speed “Pseudo Cursors”
Abstract: There are dozens of things we do in T-SQL which require some type of iteration. “Iteration” means “counters”, “loops” and recursion to most people. To those well versed in the “Black Arts” of high performance “Set-based” programming, it means a “Numbers” or “Tally” Table, instead. This “Developer-to-Developer” session starts with the basics of how SQL Server can be tricked into counting faster than you can imagine, how that simple act of counting replaces slothful loops and other forms of “RBAR”, and provides a substantial introduction to “set based thinking. The session also includes tips on using Pseudo Cursors, CROSS APPLY, and INLINE TABLE VALUED FUNCTIONS (iTVFs) to make your code that much faster .
Speaker(s):
- Jeff Moden
Track and Room: Room 314 - N/A
Title: Introduction to SQL Server Spatial Data
Abstract: SQL Server 2008 introduced support for new spatial data features – providing powerful visualization capabilities to your users. In this course attendees will learn the basics of the Geography and Geometry data types, spatial indexing, and spatial calculations. We will also explore more advanced uses for spatial data: loading spatial data into SQL Server from other formats, the new Map control in SSRS, and using online mapping software like Bing Maps to visualize SQL Server spatial data.
Speaker(s):
- Michael Coles
Track and Room: Room 325 - N/A
Title: Baselines first, troubleshooting second
Abstract: “The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Tools covered include: PerfMon, PAL, Profiler, ClearTrace, RMLUtils, who_is_active and SQL Server DMVs
Speaker(s):
- Erin Stellato
Track and Room: Room 313 - N/A
Title: T-SQL : Bad Habits to Kick
Abstract: The session will cover a collection of minor bad habits that can occasionally lead to major problems.
Speaker(s):
- Aaron Bertrand
Track and Room: Room 314 - N/A
Title: The Modern Resume - Building Your Brand
Abstract: Learn practical ways that you can build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral and longtime DBA shares some of the ways in which he has successfully grown his career over the years. Learn some tips and tricks for social networking, blogging, volunteering, leadership, and resume hints to help you find a great job.
Speaker(s):
- Steve Jones
Track and Room: Room 315 - N/A
Title: Excel 2010: everyman’s OLAP client just got better
Abstract: Starting with Excel 2000, pivot tables have been able to use OLAP cubes as data sources. Since then, Excel has become the most widely adopted OLAP BI client tool for Analysis Services cubes. And new OLAP functionality has been introduced with each successive version of Excel. In this session we’ll review Excel OLAP client functionality, survey what’s new in Excel 2010 - and see how it all works with Analysis Services 2008 R2.
Speaker(s):
- Deepak Puri
Track and Room: Room 329 - N/A
Title: Table Partitioning: Evaluation, Planning, Options
Abstract: Does SQL Server’s table partitioning feature offer performance improvements, manageability benefits, or both? Table partitioning is a significant investment: it’s important to understand many aspects of the feature to evaluate where it will be useful. This session will cover basic concepts of table partitioning. We’ll discuss where the feature can be applied, its benefits, and changes that partitioning may require to existing database schema. Special considerations for management of partitioned tables will be discussed, as well as potential changes to query optimization and plans. SQL Server 2008 R2 features for partitioning will be included in the discussion.
Speaker(s):
- Kendra Little
Track and Room: Room 330 - N/A
Title: Database Mirroring in the Real World
Abstract: A review of Database Mirroring in the context of operations in the real world. A high level review of the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a ultra fast upgrades or to move large databases to a different location.
Speaker(s):
- Craig Purnell
Track and Room: Room 330 - N/A
Title: Part 2- Integrating CDC with SSIS
Abstract: Working together, Change Data Capture (CDC) and SSIS can identify changed data and move changes to your Data Warehouse. This session will focus on using SSIS package to pull daily, hourly, or near real-time Type I and Type II dimension changes from SQL Server running CDC.
Speaker(s):
- Chris Skorlinski
Track and Room: Room 315 - N/A
Title: Database Design Contentious Issues
Abstract: A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? …and others. Bring your votes, your debates, and your opinions.
Speaker(s):
- Karen Lopez
Track and Room: Room 325 - N/A
Title: Encryption in SQL Server
Abstract: Learn to protect data in your application by leveraging the built in encryption functionality in SQL Server 2005/2008 by taking a brownfield application and bringing it up to modern standards. Topics covered will include column level data encryption, providing lookups of encrypted data, basics of key management and the transparent data encryption capabilities of SQL Server 2008.
Speaker(s):
- Joe Kuemerle
Track and Room: Room 314 - N/A
Title: Writing faster queries
Abstract: Poor database performance is Achilles’ heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we’ll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.
Speaker(s):
- Tim Chapman
Track and Room: Room 314 - N/A
Title: Modeling Muddy Data
Abstract: Unfortunately, the real world isn’t always as cut and dry as third normal form; sometimes things get muddy. What do you do then? This talk will examine the use of NULLs, sparse columns, XML data types, and other ways of storing data with a murky format. This presentation will introduce techniques for common data modeling problems and examine potential patterns and practices for working with flexible data modeling that can be immediately useful in real-world scenarios.
Speaker(s):
- Jeremiah Peschka
Track and Room: Room 325 - N/A
Title: Technical Professionals….Are We Just a Commodity?
Abstract: The economy is still tight. Companies continue to reduce costs across the board. With outsourcing and off-shoring achieving success, how can today’s in-house DBA or developer prove his value to the business? Technical expertise is valuable to product and technical management. However, it’s the professionals understanding of the business and his role in generating revenue that’s invaluable. This presentation explains various techniques technical professionals can use to increase their business savvy, proving they are providing value and not just an expense.
Speaker(s):
- Joe Kuemerle
Track and Room: Room 313 - N/A
Title: Developing Date and Role-Playing Dimensions
Abstract: Every data warehouse needs a date dimension to help users slice and dice data. What should be included in the dimension, what is enough and what is too much? Should you use the wizard to generate the dimension for you; what are the advantages and disadvantages? We will explore a generic date dimension load script, loading a custom table and configuring SSAS to use the table as the time dimension. Finally we will address the advantages of role-playing dimensions to make an Order Date, Ship Date, Received Date exposed to users as opposed to multiple date dimensions.
Speaker(s):
- Sandra Mueller
Track and Room: Room 329 - N/A
Title: Getting Started with MDX
Abstract: In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
Speaker(s):
- William E Pearson III
Track and Room: Room 315 - N/A
Title: Part 1 - Introduction to Change Data Capture
Abstract: Change Data Capture (CDC) is used by data warehouse applications to retrieve Type I and Type II dimension updates. This sessions provides a walk through of Microsoft’s newest SQL Replication feature called CDC. Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of Type I and Type II data changes.
Speaker(s):
- Chris Skorlinski
Track and Room: Room 315 - N/A
Title: What’s new in SQL Server 2011 (“Denali”)?
Abstract: This presentation will cover all of the new features coming our way in the next major version of SQL Server. From contained databases to high availability to T-SQL enhancements, we will cover the good, the bad, the missing and the ugly. Lots of demos and no marketing.
Speaker(s):
- Aaron Bertrand
Track and Room: Room 330 - N/A
Title: Troubleshooting SSRS Performance Issues
Abstract: Evan will discuss and demonstrate how to troubleshoot Reporting Services performance issues. This will cover both tools included in the product plus some real-world scenarios he has dealt with in the past.
Speaker(s):
- Evan Basalik
Track and Room: Room 315 - N/A
Title: (NOLOCK) FOR YESFUN: Games with Isolation Levels
Abstract: Understanding transaction isolation levels is critical for developing concurrent software as well as administering databases. Unfortunately most of us learn about transaction isolation early in our careers and don’t maintain an in-depth knowledge of different isolation levels. This talk will help! We’ll cover all isolation levels and discuss problems and benefits. A broadsheet handout will keep your knowledge fresh later on. This is suitable for developers and DBAs at all levels.
Speaker(s):
- Kendra Little
Track and Room: Room 325 - N/A
Title: Service Broker…What’s That How Do I Use It?
Abstract: Have you heard of Service Broker? Do you know what it is? How about how to use it? This session will answer these questions and more. Service Broker is arguably one of the least known and used features of SQL Server. We’ll explore Service Broker and learn what it is and how it works. We’ll walk through the setup and configuration along with demonstrating its use. You’ll leave this session with a better understanding of Service Broker, its use and implementation, along with ideas of how you can implement it in your own environments.
Speaker(s):
- Brian Davis
Track and Room: Room 325 - N/A
Title: Analysis Services Troubleshooting and Optimization
Abstract: You’ve got SSAS cubes and they work. Now people are using them and everyone’s queries are slow. I’ll cover how to see who’s using the cubes, what query they’re running. Also, what can we do to make the queries run faster and how to stop bad queries that are hogging system resources. Specifically I’ll cover the SSAS DMVs, the SSAS Activity Viewer available from CodePlex that uses theses DMVs. Also the aggregation designer that is available as part of the BIDS project and how it can be used to speed up queries against the cube database.
Speaker(s):
- Joe Fedak
Track and Room: Room 329 - N/A
Title: BI Development
Abstract: SQL Server 2008 provides a great platform for producing Business Intelligence reports. With the ability to create SSIS packages and SSRS reports, BI can be utilized to provide vital information for running any business. Learning these skills will help any developer to maximize the full potential of any database application. In addition, many of the new features in Reporting Services make it easier to provide a rich BI report with little effort.
Speaker(s):
- Sam Nasr
Track and Room: Room 329 - N/A
Title: Programming with FileStreams
Abstract: SQL Server 2008 introduced the FileStream object. This allowed developers to resolve an age long dilemma of storing large binary files in the database or accessing them on the file system. SS08 provides the best of both worlds while allowing applications to access the data readily through the FileStream object via Transact SQL or File I/O.
Speaker(s):
- Sam Nasr
Track and Room: Room 329 - N/A
Title: Gather SQL Server Performance Data with PowerShell
Abstract: We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don’t always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker(s):
- Allen White
Track and Room: Room 313 - N/A
Title: Fundamentals of SQL Server Internals
Abstract: Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
Speaker(s):
- Jeremiah Peschka
Track and Room: Room 313 - N/A
Title: Waits and Queues and YOU!
Abstract: Many database professional have little to no understanding about how to use wait events as part of an overall performance tuning process. And yet wait events are the secret sauce that many leading experts have been using for years. Attend this talk and you will gain an understanding of the SQLOS execution model, an understanding of how to use DMVs to find out what your queries are waiting for, and why using wait events could be the best thing to happen for your career as a DBA.
Speaker(s):
- Thomas LaRock
Track and Room: Room 330 - N/A
Title: Take Your Automation Script to the Next Level
Abstract: How can PowerShell take SQL Server Automation to the next level? PowerShell with the help of the SMO (Server Management Objects) allows a script to interact with the operation system and SQL Server at the same time. In this session we will cover the basics of PowerShell and the SMO object model. Then review a number of scripts that demonstrate the power of PowerShell when automating SQL Server tasks and can be used as building blocks for further automation.
Speaker(s):
- Paul Hiles
Track and Room: Room 313 - 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.
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.
Jeff Mlakar
Contact: http://www.jeffmlakar.com
Jeff Mlakar is an Enterprise Architect on the Business Intelligence team at Bennett Adelson Consulting. He has spent the last decade working in database technologies, ranging from SQL Server, SSIS, and the whole Microsoft BI stack, to Oracle and Elasticsearch. He has spoken at the local .NET User group, the Modern Excel User group, SQLSaturdays, the SQL Server User Group, and the Dog Food Conference.
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.
Mike Walsh
Contact: http://www.straightpathsql.com
Mike is an experienced SQL Server professional and has worked with SQL Server for over 10 years. He has performed the duties of DBA, Developer, Architect and Performance Lead but always leans on his DBA experience. Mike is working for a Microsoft Solutions Provider in Portland Maine, Winxnet as their SQL Server Practice Lead. He is the president and co-founder of the Seacoast SQL Server Users Group in Portsmouth, NH; he blogs at www.straightpathsql.com.
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
Michael Coles
Michael Coles is a prolific writer on SQL Server topics. He has authored or coauthored several SQL Server developer titles including Expert SQL Server 2008 Encryption, Pro T-SQL 2008 Programmer’s Guide and Pro Full-Text Search in SQL Server 2008. He has also written dozens of technical articles that have been published online and in print magazines. Michael is a Microsoft MVP (SQL) and holds MCST:SQL Server 2008 (database development), MCDBA and MCP+I certifications, with a Bachelors degree in Information Technology. Michael has over 15 years SQL Server experience and he is currently Chief ETL Architect for a BI consulting firm in New York.
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.
Jeremiah Peschka
Contact: http://brentozar.com
Jeremiah sees the magic in technology. He knows how to do things now, and he also knows how to think about possibilities. Jeremiah likes to imagine new kinds of indexes, new kinds of teams, new kinds of applications — this means when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Tim Chapman
Tim Chapman is a Microsoft Certified Master (MCM) and works as a dedicated field engineer (PFE) at Microsoft specializing in performance tuning and high availability. Tim is from Louisville, KY and has over 12 years of database architecture, programming, and administration experience.
Paul Hiles
Paul has over 20 years of experience in the IT field which includes: programmer, system administrator, technical manger and both an operational and application DBA. He has been working with SQL Server since 2000 starting with version 7.0. He is currently a Data Architect where he specializes in SSIS, SSRS and database design and performance tuning.
Michael Coles
Michael Coles is a prolific writer on SQL Server topics. He has authored or coauthored several SQL Server developer titles including Expert SQL Server 2008 Encryption, Pro T-SQL 2008 Programmer’s Guide and Pro Full-Text Search in SQL Server 2008. He has also written dozens of technical articles that have been published online and in print magazines. Michael is a Microsoft MVP (SQL) and holds MCST:SQL Server 2008 (database development), MCDBA and MCP+I certifications, with a Bachelors degree in Information Technology. Michael has over 15 years SQL Server experience and he is currently Chief ETL Architect for a BI consulting firm in New York.
Joe Kuemerle
Twitter: - @jkuemerle
Contact: http://www.kuemerle.com
Joe Kuemerle is a developer and speaker in the Cleveland, OH area specializing in .NET development, security, database and application lifecycle topics. He is currently a Lead Developer at PreEmptive Solutions, LLC . PreEmptive is the maker of Dotfuscator, the premier obfuscator for .NET; DashO, the top Java obfuscator; and Runtime Intelligence, a solution to inject application usage tracking into .NET and Java applications.
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”.
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.
Rob Collie
Contact: http://powerpivotpro.com
Rob Collie is founder of PowerPivotPro, the 1st fully agile BI consulting firm that empowers companies to spur smarter business decisions in a fraction of the time and cost. A BI and analytics engineering leader during his 14-year career at Microsoft, Rob knows how to give companies a competitive advantage, and is a firm believer in creating solutions that can be replicated long after the partnership ends. Collie’s passion is to replace the methodologies of the traditional BI industry with business-empowered, immediate-impact tactics made possible by the recent breakthroughs in software, like Power BI. Author of 3 books, including the world’s No. 1-selling Power BI book, over 600 articles and whitepapers. https://powerpivotpro.com/
Jeremiah Peschka
Contact: http://brentozar.com
Jeremiah sees the magic in technology. He knows how to do things now, and he also knows how to think about possibilities. Jeremiah likes to imagine new kinds of indexes, new kinds of teams, new kinds of applications — this means when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
Chris Skorlinski
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
Sandra Mueller
Sandra A. Mueller started with Administration (via a programming job) in 1997 and moved into Database Design and performance optimization. She has always had a passion for sharing knowledge and trying to help others avoid the hard lessons she learnt. To this end she has been an MCT for 16 years, writing course ware, providing training and follow-on project consultation. In 2004 after an activation with the military her focus turned to SQL Server 2005 and its Business Intelligence (BI) capabilities. She is currently working as a BI Architect with SQL Server 2008R2 OLAP solutions.
Sandra blogs on http://www.SandraAMueller.com. She recently started the Raleigh NC SQL Server BI User Group (http://www.tripassBI.org). She consistency speaks at SQLSaturday events and supports her local community by speaking, volunteering and attending regional chapters.
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.
Deepak Puri
Deepak is a SQL Server MVP and a Business Intelligence Consultant who has been working with SQL Server Analysis Services since 2000. He’s an active contributor to the MSDN Analysis Services Forum and a regular presenter at Ohio North SQL Server User Group meetings.
Kendra Little
Twitter: - Kendra_Little
LinkedIn: Kendra Little
Contact: http://littlekendra.com
Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.
Joe Kuemerle
Twitter: - @jkuemerle
Contact: http://www.kuemerle.com
Joe Kuemerle is a developer and speaker in the Cleveland, OH area specializing in .NET development, security, database and application lifecycle topics. He is currently a Lead Developer at PreEmptive Solutions, LLC . PreEmptive is the maker of Dotfuscator, the premier obfuscator for .NET; DashO, the top Java obfuscator; and Runtime Intelligence, a solution to inject application usage tracking into .NET and Java applications.
Ira Warren
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
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
Kendra Little
Twitter: - Kendra_Little
LinkedIn: Kendra Little
Contact: http://littlekendra.com
Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.
Sam Nasr
Twitter: - SamNasr
LinkedIn: Sam Nasr
Contact: http://samnasr.blogspot.com/
Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. He’s a Sr. Software Engineer with NIS Technologies where he consults and teaches clients about the latest .Net technologies. Sam has achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, MCT), and is the leader of the Cleveland C#/VB.Net User Group since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
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.
Sam Nasr
Twitter: - SamNasr
LinkedIn: Sam Nasr
Contact: http://samnasr.blogspot.com/
Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. He’s a Sr. Software Engineer with NIS Technologies where he consults and teaches clients about the latest .Net technologies. Sam has achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, MCT), and is the leader of the Cleveland C#/VB.Net User Group since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.
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.
Joe Fedak
I worked for 3 years at InfoCision Management corporation creating business intelligence projects using SQL2000 - 2005. in 2008 I took a position with the Client Strategy Group as a Business Intelligence consultant where I help businesses create and maintain BI solutions. I work mostly with analysis services cubes and reporting services. I’m a certified SQL Server 2005 developer (MCITP). I’m currently studying for the SQL 2008 Business Intelligence exams.
Chris Skorlinski
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
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!”
Evan Basalik
Contact: http://blogs.msdn.com/psssql
Evan spent 10 years doing RD for a major textile manufacturer. He joined Microsoft 4.5 years ago and is currently a Support Escalation Engineer on the SQL Server team. He specializes in connectivity, database client code, and Reporting Services. He has been working on SQL Azure since before it was even called SQL Azure.
Sponsors
The following is a list of sponsors that helped fund the event: