SQLSaturday #165 - Lincoln 2012
Event Date: 10/06/2012 00:00:00
Event Location:
- University of Nebraska - Avery Hall
- Avery Hall , 256
- Lincoln, Nebraska
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: SQL Server Internals: It’s What’s for Dinner!
Abstract: Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a chef analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session’s end you should have a clear overview of what happens when a query hits your server.
Speaker(s):
- Christina Leo
Track and Room: Track 3 - N/A
Title: The Accidental Programmer
Abstract: Most people in the database world have heard of the term, “The Accidental DBA”, those programmers who have to work with databases. How about the other side of the coin? What about DBA’s an Dev’s who have to write code or have to work closely with programmers? This presentation is a best practices guide for working with SQL Server in a .Net environment. You will learn how to recognize when bad code is written that interacts with the database, how to track it down, and most importantly how to fix it. On top of that you will also receive an introduction to object oriented programming concepts such as data abstraction, encapsulation, tier architecture, and class objects so that you can better communicate with your programmers.
Speaker(s):
- Jason Kassay
Track and Room: Track 4 - N/A
Title: Disk IO Tuning for Microsoft SQL Server
Abstract: Tuning disk subsystems for optimal SQL Server performance is typically the domain of very experienced, enterprise DBAs. It normally requires years of experience the hard disk subsystem to learn exactly what configurations perform best, provide the greatest fault tolerance, and allow for the most scalability. This session removes the need for those years of experience by answering questions like:
How does RAID compare to SAN, hard disk to SSD? What is needed to properly monitor and tune the performance of my disk subsystem? How do I tune my SQL Server for improved IO performance?
Configuring hardware can be very intimidating, especially when the application needs to scale.
Speaker(s):
- Kevin Kline
Track and Room: Track 1 - N/A
Title: Securing the Cube; SSAS security framework
Abstract: Secure, Enable, Maintain, Sustain. In depth discussion on a SSAS security framework with SSIS maintenance toolkits. Create security roles in the cube that enable the business based on underlying data patterns. Presentation covers creation of roles in the cube, with a demo creating SSIS roles with a toolkit based on the adventureworks db model and cube. Using integrated security, service accounts and data sources in the presentation layers this we walk through a security model for end-to-end security as can be implemented in sharepoint integrated solutions and/or standalone reports. This presentation provides real world application and an SSIS toolkit to take away and implement in your solutions. Presented in English.
Speaker(s):
- Daniel Lewandowski
Track and Room: Track 2 - N/A
Title: Kama Sutra of SSIS: A guide to loving ETL
Abstract: Slow running packages? SSIS consuming all your resources? No idea what it’s doing? After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.
Speaker(s):
- Bill Fellows
Track and Room: Track 6 - N/A
Title: SSAS 2012 Tabular vs. Multidimensional
Abstract: The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths. In this session, BI Architect and MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios.
Speaker(s):
- William E Pearson III
Track and Room: Track 2 - N/A
Title: Real-time Data Warehouse and Reporting Solutions
Abstract: In this demo-rich session, we will explore database and ETL architectures that let you smoothly move data from your application databases across the enterprise in real-time to your data warehouse. You will see how to use SQL Server features such as replication, Change Data Capture, SSIS, and other techniques to extract, transform, and load data fast and dependably. We will develop an actual sample system during the session and discuss and walk through alternative real-time architectures, including the use of Data Vault methodologies. We will then see how to use Reporting Services and Power View to present data with a minimum amount of latency.
Speaker(s):
- Carlos Bossy
Track and Room: Track 3 - N/A
Title: Amazon RDS and SQL Azure - DB in the cloud
Abstract: Amazon’s AWS and Microsoft’s Azure both offer SQL Server instances as services (not necessarily as servers). What do they offer, why would one use them, how do they differ, what special considerations are there? What exactly does “Platform as a Service” (PaaS) mean with SQL?
Speaker(s):
- Tim Plas
Track and Room: Track 6 - N/A
Title: Backups Restores: You’re Not In Kansas Anymore!
Abstract: Have you ever been in Kansas and have a random house drop on you? Ok, probably not, but the moral of the question is that you never know when a house might fall out of the sky and you certainly don’t want to be caught under it when it does!. Not understanding database backups restores is just like having a house crash down on around your ears. Loud, noisy and sometimes hard to put the pieces back together. As a follower of the Yellow Database Road, You have to be ready for said event. Now how do you do that you ask? You come to this session about Backups Restores. We’ll talk about how to use them to help avoid having a house fall on your head!
Speaker(s):
- John Morehouse
Track and Room: Track 4 - N/A
Title: Take Control with SQL Server PowerShell
Abstract: In this session we will look at how the SQL Server PowerShell can assist us in managing instances of SQL Server. We will get to know the PowerShell command shell, learn how to issue commands and find out how to get help. Using common administration scenarios, we will see how the PowerShell SQL Server cmdlets can perform the tasks needed to get the job done.
Speaker(s):
- David Brockelsby
Track and Room: Track 6 - N/A
Title: How to be a DBA and retire Rich
Abstract: Yes, how to be a DBA and retire rich. This is a session in the ‘off the beaten path’ or the ‘miscellaneous track’. You will learn nothing SQL Server technical in this session, but will learn about the Modern Portfolio Management theory in Finance. I will conduct a practical discussion on how to structure your 401(K) portfolio or your general investment portfolio for the most optimal asset allocation and maximum return while minimizing taxes and expenses. You can use the practical tips in this session to consider options to streamline your portfolio to maximize returns. This session may serve as a wakeup call to do something about your portfolio. When it comes to retirement, clearly, luck is not a strategy.
Speaker(s):
- Sudhir Gajre
Track and Room: Track 5 - N/A
Title: Analysis Services for the DBA
Abstract: Many DBAs have heard the term Analysis Services, but don’t really know what it’s for or who would use it. In this session, Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution.
This session will be practical for SQL 2005 through 2008 R2, but he will also take the time to explain what changes in SQL 2012 and the new Tabular mode.
Speaker(s):
- Mark Stacey
Track and Room: Track 2 - N/A
Title: PowerPivot with NASA data
Abstract: Power Pivot is an amazing tool for mashing up data from a variety of sources ~ in this session, we will combine data from NASA, OpenGOV, and other publicly available sources, as well as from a prebuilt cube, to show the power of user driven analysis, and visualisation in Excel. Using DAX, you will see how to create filtered measures, and then dive into the new enhancements for the date table, relationshios, perspectives and KPIs. As an added bonus, you will see how to pull the model into Visual Studio, decorate it with new attributes, and show the visualisations in other tools such as Performance Point and Crescent (PowerView)
Speaker(s):
- Mark Stacey
Track and Room: Track 2 - N/A
Title: SSIS 2012: A Deep Dive into the SSIS Catalog
Abstract: New in SQL Server 2012, the SSIS catalog provides a rich set of built-in tools for capturing/reporting package logging, statistics, and other interesting things all within a few keystrokes or mouse clicks. This session will focus on the internals of this new catalog and how to use it. You will learn how to extend and query the metadata captured by the package execution process and how to navigate your way around the built-in reports.
Speaker(s):
- Phil Brammer
Track and Room: Track 6 - N/A
Title: Serene Velocity: Reporting Services and SSAS Data
Abstract: SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.
Speaker(s):
- William E Pearson III
Track and Room: Track 3 - N/A
Title: Exposing the Core: SQL 2012 on Server Core
Abstract: Everything that’s old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
Speaker(s):
- Michael Fal
Track and Room: Track 4 - N/A
Title: Social Networking Is Alive!
Abstract: Social Networking is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don’t have any fear as this session is for you! Social networking can be a very confusing place and when you don’t know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We’ll be covering Facebook, LinkedIn and Twitter.
Speaker(s):
- John Morehouse
Track and Room: Track 5 - N/A
Title: Database Health and Performance
Abstract: Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? This dynamic dialog session will present a solid process for checking your environment’s overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.
Speaker(s):
- David Klee
Track and Room: Track 3 - N/A
Title: Case study - Compression and Partitioning (BCBSNE)
Abstract: Discussion of the reasons Blue Cross Blue Shield of Nebraska decided to implement table partitioning and data compression, how we implemented it, what issues we encountered and some examples of how we resolved the issues.
Speaker(s):
- Dean Nicholson
Track and Room: Track 1 - N/A
Title: Heart to Heart with Business Users
Abstract: Now days the technician spends more and more of their time conversing with non-technical business users. The problem is, we speak different languages. This results in confusion, frustration and the impression that IT is difficult to work with. This discussion will focus on how to better communicate with business users to provide products and solutions that meet their needs, get them to understand the issues in providing those products and helping the business user to expand their thinking beyond the ordinary.
Speaker(s):
- Dave Pettengill
Track and Room: Track 5 - N/A
Title: Type more, click less: using EzAPI to build SSIS
Abstract: The EzAPI is a free .NET library produced by the SSIS team supporting 2008 and 2012. In this code-centric talk, we will start with a basic package and progressively work through the object model to build more complex packages. You will leave this talk with an understanding of how to spin up new packages that have variables, precedence constraints, dataflows, logging and configuration—all without abusing your poor mouse.
Speaker(s):
- Bill Fellows
Track and Room: Track 6 - N/A
Title: Virtualizing Business Critical SQL Servers
Abstract: Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and David Klee (@kleegeek) and Andy Galbraith (@DBA_ANDY) will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotcha’s will be discussed in this dynamic dialog session.
Speaker(s):
- David Klee
Track and Room: Track 1 - N/A
Title: A Database Perspective
Abstract: Too often we get wrapped up in the latest release of feature of database products. This presentation provides a broader perspective on databases, their life cycles and the life of a DBA. Based on 40 years in IT, we discuss why we do this and why it’s so hard for others to understand why we do what we do.
Speaker(s):
- Dave Pettengill
Track and Room: Track 5 - N/A
Title: Top 10 Admin Mistakes on SQL Server
Abstract: Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen?
Speaker(s):
- Kevin Kline
Track and Room: Track 1 - N/A
Title: Maintain Your DBs with Help from Ola Hallengren
Abstract: One of the most widely respected and recommended free tools for SQL Server is Ola Hallengren’s MaintenanceSolution.sql. It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases. Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.
Speaker(s):
- Andy Galbraith
Track and Room: Track 4 - N/A
Title: Reporting Services tips for the Stephen Few fan
Abstract: Do you opt for bullet charts over big, round gauges? Do 3-D pie charts make you sad? Have you ever redesigned a graph to get a better data-to-ink ratio? Whether you answered yes to all of these questions or you are unfamiliar with all of the above terms, come to this session to learn about design concepts as well as helpful features and tools available when using Reporting Services to visually represent data in an efficient and effective manner. We will also discuss common challenges faced in the workplace when trying to implement the ideals in real life.
Speaker(s):
- Meagan Longoria
Track and Room: Track 3 - N/A
Title: What’s Buried in the Plan Cache?
Abstract: Creating a query plan can be a time consuming and expensive process. To avoid repeating these costly steps unnecessarily, SQL Server stores its query plans, in the plan cache where they can be reused as needed.
In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation.
Speaker(s):
- Christina Leo
Track and Room: Track 1 - N/A
Title: SQL Server Monitoring Crash Course
Abstract: No one likes to be alone in the dark. Yet, often this is the case with our SQL Servers which usually suffer from a lack of monitoring. What’s important? Tracing slow queries? Collecting wait stats? Looking at perfmon counters? This session will show you the key elements to monitor in your database instances, how to track them automatically, and where to go after your foundatation is built.
Speaker(s):
- Michael Fal
Track and Room: Track 5 - N/A
Title: SQL Server 2012 High Availability and DR
Abstract: This is a deep dive session in the new HA/DR options for SQL Server 2012. Through interactive discussions and lively demos, get an in depth understanding of the AlwaysOn Failover Clustering and AlwaysOn Availability Groups. Experience how to set up active secondary’s and off load backups to the secondary servers. You will walk away with a thorough understanding of the pros and cons of each HA/DR option in SQL Server 2012 and can immediately apply it to practical use.
Speaker(s):
- Sudhir Gajre
Track and Room: Track 4 - N/A
Title: Data Modeling Best Practices for Tabular Models
Abstract: The new Tabular models in SQL Server 2012 give us a powerful analytic engine that is faster and easier to implement than traditional multi-dimensional cubes using Analysis Services. In this session, you’ll see how to develop analytic models using your existing data sources and learn best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, you’ll see how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience and how the model works with Excel and Power View.
Speaker(s):
- Carlos Bossy
Track and Room: Track 2 - 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.
Kevin Kline
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
Dean Nicholson
Dean Nicholson is currently a Database Administrator III for Blue Cross Blue Shield of Nebraska. I have over 14 years DBA experience, and I am an active member of the Omaha, NE SQL Server User Group. Extensive experience in both Operations and Development. I like to focus on performance issues.
Jason Kassay
Twitter: - @jasonkassay
LinkedIn: Jason Kassay
Contact: http://www.JasonKassay.com
Jason Kassay is a database administrator, software engineer amp; speaker from Colorado with over 12 years of experience. He is passionate about SQL Server, programming, release process, automation amp; performance tuning. Jason is an active member of the SQL Server community amp; volunteers/presents at events such as Colorado User Groups, SQLSaturday amp; Colorado GiveCamp. When not tuning databases or coding, Jason will most likely be found spending time with his family, playing hockey or running.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
Tim Plas
Twitter: - tjplas
LinkedIn: Tim Plas
Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.
Christina Leo
Twitter: - christinaleo
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.
Daniel Lewandowski
Daniel has been a college instructor and high school teacher, network engineer, and tour guide along the way to starting LewiCool Consulting. MicroSoft Business Intelligence Consultancy with BI experience in enterprise organizations spanning multi-million dollar corportations to government, telecom, banking, industrial and education. Striving to enable business with technology, with secure maintainable sustainable solutions that help the business attain success in whatever the endeavor.
John Morehouse
Contact: http://sqlrus.com
John Morehouse is currently a Database Architect/Engineer with Farm Credit Services of America in Omaha, Nebraska. He is one of the leaders of the Omaha SQL/BI User group and and a frequent speaker at SQLSaturday’s as well as other conferences. In his spare time, you can find John running after one of his two sons or working on his 113 year old house.
Mark Stacey
Twitter: - @MarkGStacey
Contact: http://MarkGStacey.net
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business/technical boundaries in Business Intelligence, working in both SharePoint and SQL. He has published two books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQLSaturday and SharePoint Saturday events. Mark is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
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
Christina Leo
Twitter: - christinaleo
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.
Phil Brammer
Twitter: - @PhilBrammer
LinkedIn: Phil Brammer
Contact: http://www.ssistalk.com
Phil Brammer, a sixth year Microsoft MVP in SQL Server and a Microsoft Certified Solutions Expert, has over 12 years’ data management experience in various technologies from reporting through ETL to database administration. He has worked with SSIS since 2007 and he continues to play an active role in the SSIS community via online resources as well as his technical blog site, SSISTalk.com. He has contributed to books, SQLSaturdays, SQL PASS Summits, and other online communities.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Sudhir Gajre
Twitter: - @SudhirGajre
LinkedIn: Sudhir Gajre
Contact: http://www.dbbest.com/blog/author/sudhir/
Sudhir has over 20 years of experience in the Data Management and the Analytics field. He spent the last 14 years at Microsoft where he was a Data Architect and later a Principal Technologist. He has authored SQL Server performance tuning whitepapers, designed VLDB and Highly Scalable SQL Server Architectures, and led technical teams. He is a frequent speaker at conferences and SQLSaturdays and is a recognized expert in the Data Management field. He is a Director with DB Best Technologies.
Meagan Longoria
Twitter: - mmarie
LinkedIn: Meagan Longoria
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
John Morehouse
Contact: http://sqlrus.com
John Morehouse is currently a Database Architect/Engineer with Farm Credit Services of America in Omaha, Nebraska. He is one of the leaders of the Omaha SQL/BI User group and and a frequent speaker at SQLSaturday’s as well as other conferences. In his spare time, you can find John running after one of his two sons or working on his 113 year old house.
Mark Stacey
Twitter: - @MarkGStacey
Contact: http://MarkGStacey.net
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business/technical boundaries in Business Intelligence, working in both SharePoint and SQL. He has published two books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQLSaturday and SharePoint Saturday events. Mark is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies
Andy Galbraith
Twitter: - https://twitter.com/DBA_ANDY
LinkedIn: Andy Galbraith
Contact: http://nebraskasql.blogspot.com/
I’m a forty-something Microsoft SQL Server DBA of 18+ years, a devoted husband, and a father of three young boys (all aged eight and under!) I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.
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
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Kevin Kline
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
David Brockelsby
Contact: http://www.1staff.com
David became a Microsoft Certified Instructor in 1996, but has been a technical instructor for over 20 years. The bulk of his experience comes from database administration, application development and web development. He currently teaches at 1Staff Training in Omaha, Nebraska. While his instruction is focused mainly on Microsoft technology, he also trains in other areas such as Java and Oracle.
Michael Fal
Twitter: - @Mike_Fal
LinkedIn: Michael Fal
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.
Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
Sudhir Gajre
Twitter: - @SudhirGajre
LinkedIn: Sudhir Gajre
Contact: http://www.dbbest.com/blog/author/sudhir/
Sudhir has over 20 years of experience in the Data Management and the Analytics field. He spent the last 14 years at Microsoft where he was a Data Architect and later a Principal Technologist. He has authored SQL Server performance tuning whitepapers, designed VLDB and Highly Scalable SQL Server Architectures, and led technical teams. He is a frequent speaker at conferences and SQLSaturdays and is a recognized expert in the Data Management field. He is a Director with DB Best Technologies.
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.
Dave Pettengill
Dave Pettengill has over 40 years’ experience in IT, mostly in Database support, design and modeling, data warehousing, BI and performance tuning. As a diversion he designs and engineers data centers, writes fiction and hikes in the mountains of Phoenix. Dave has also worked on mainframes, i-Series and various flavors of Unix. While he has supported over 12 different database management systems, he prefers SQL Server because it’s more fun.
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.
Michael Fal
Twitter: - @Mike_Fal
LinkedIn: Michael Fal
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.
Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
Dave Pettengill
Dave Pettengill has over 40 years’ experience in IT, mostly in Database support, design and modeling, data warehousing, BI and performance tuning. As a diversion he designs and engineers data centers, writes fiction and hikes in the mountains of Phoenix. Dave has also worked on mainframes, i-Series and various flavors of Unix. While he has supported over 12 different database management systems, he prefers SQL Server because it’s more fun.
Sponsors
The following is a list of sponsors that helped fund the event: