SQLSaturday #397 - Omaha 2015

Event Date: 08/15/2015 00:00:00

Event Location:

Mammel Hall, University of Nebraska-Omaha
6708 Pine Street
Omaha, Nebraska

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: Performing a SQL Server Health Check

Abstract: How often do you review your SQL Servers for basic security, maintenance, and performance issues? If you say never, I’m not surprised - many of the servers I “inherit” as a managed services provider have many gaping holes. It is not unusual to find databases that are never backed up, constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that have too much!)

Come learn how to use freely available tools to check your servers for basic issues like backups and CheckDB as well as for more advanced issues like page life expectancy and indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!

Speaker(s):

Andy Galbraith

Track and Room: DBA - 122

Title: Whatcha Doin’? Passive Security for Hostile Environments

Abstract: Ideal database security settings usually exist in books, but rarely in reality. Is your CIO a member of the sysadmin role because they demanded it? Or maybe some users have rights for purely political reasons? Just because you can’t enforce security through typical means doesn’t mean you’re powerless. Attend this session to learn about the features SQL Server provides that will allow you to keep track of what your users are up to at all times and sleep a little easier. Through various scenarios and demos, see how technologies such as event notifications, auditing, and extended events can help ensure nothing happens on your system without you knowing about it. Even in optimally secured environments these techniques can still come in handy. The best security is often that which cannot be seen.

Speaker(s):

Bob Pusateri

Track and Room: Security - 117

Title: What is causing my database to grow?

Abstract: Have you ever received a call that an application is throwing errors about the database being out of space? This session will help you learn how to proactively deal with those calls! Sometimes it isn’t practical to limit the growth of our databases. As DBAs, it is our responsibility to make sure that we know the disk space that is used and free, the size of our databases, when they grew, and why they grew so that we can prepare for it or reduce it. We can also track the size and growth over time to be able to predict future trends. In this beginner session, Jared Karney will show you how you can track the size of your disks, databases, and database files using DMVs. He will show you how to structure tables and indexes for storing this data, demonstrate the Extended Events to track when a data or log file grows and what caused the growth to occur, and how you can automate the whole process using SQL Agent.

Speaker(s):

Jared Karney

Track and Room: DBA - 119

Title: Getting Started with MDX

Abstract: In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, 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. This session applies equally to Analysis Services 2008, 2008R2 and 2012.

Speaker(s):

William E Pearson III

Track and Room: Data BI - 118

Title: Introducing Forensic Analytics with PowerPivot for Excel

Abstract: Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities. In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.

Speaker(s):

William E Pearson III

Track and Room: Security - 117

Title: Scary Things A Database Owner Can Do

Abstract: So you’ve setup your new SQL Server instance and it’s time to start adding databases to it. You followed security best practices at the instance level, but what about security within each database? Is that something you can control? Well, if like me, you work in a shop that mostly purchases software, then having users with database owner permissions is a reality, and likely not one you can change. But members of the db_owner role can only make changes that would adversely impact their own databases, right? Think again. During this session we’ll review some common database level settings and actions which can have a negative impact across the entire instance. We’ll discuss ways to mitigate these risks and monitor for their occurrence. Come learn how to not let poor choices made by a database owner impact your entire instance.

Speaker(s):

Paul Timmerman

Track and Room: Security - 121

Title: Tips for SQL Server Performance and Resiliency

Abstract: After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160; We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160; These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.

Speaker(s):

Chris Shaw

Track and Room: DBA - 122

Title: The Database: The Elephant in the ALM Room

Abstract: Many teams and individuals are still building their databases and maintaining them through old-fashioned manual processes. This, even as these same teams move towards an automated Application Lifecycle Management (ALM) through the adoption of DevOps best practices. These manual processes are hurting the ability of your database deployments to keep up with modern development. Is there a technical reason for this slow adoption of ALM best practices in the database world, or is there a cultural problem preventing a reassessment of these manual processes? Or, could it be both? This session will address these questions as it explores the challenges presented by ALM for databases. We will discuss the necessary first steps required to move from a manual database deployment process to a fully automated one. You will learn about tooling that can assist you in implementing these new processes. Your database deployments can take advantage of the same processes you use for application deployments.

Speaker(s):

Grant Fritchey

Track and Room: Developer - 118

Abstract: Social Networking and Media 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 or LinkedIn? Have no fear, this is the session for you! Social networking can be a very confusing and intimidating place. What makes it even worse, is when you have no clue even where to start. In this session, we will go over different facets of Social Networking and Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. For example, did you know you can get help from some of the top minds in the SQL Server profession by using the #SQLHELP hash tag for free? We will show you how! We’ll be covering that and more using Facebook, LinkedIn and Twitter.

Speaker(s):

John Morehouse

Track and Room: Soft Skills - 119

Title: SQL Server Benchmarking: The Powershell Speedometer

Abstract: How fast do you think you were going? The only way to be sure is to have a reliable way to measure your performance. The challenge with SQL Server is that there are many aspects of your stack that you need to measure and understand. Powershell, with its ability to access and report on all these different levels, can give you a robust tool to benchmark your SQL Server. This session will cover benchmarking methodologies, the tools Powershell offers for capturing performance information, and will demonstrate how you can use them to measure performance statistics. After attending this session, you will understand how to effectively use Powershell to measure your database speed.

Speaker(s):

Michael Fal

Track and Room: DBA - 122

Title: SQL Server 2016 Overview

Abstract: Come join Phil Brammer as he talks through the new features in SQL Server 2016. This session will touch on AlwaysOn, In-Memory, Query Store, and more!

Speaker(s):

Phil Brammer

Track and Room: DBA - 119

Title: Virtualize Clusters and AlwaysOn Availability Groups

Abstract: High availability can be different when in a virtual environment. Attendees will learn the pros and cons of running SQL server clusters or AlwaysOn Availability Groups in a virtual environment. Comparing all of the different high availability options between all of available technologies. How features of VMware and Hyper-V are impacted and how to work with the administrators of virtual environment. Walking through all of the storage options to determine which one is the best fit. Review key settings and configurations for the virtual platform, the virtual machine, and SQL server, and show which need to be set to ensure proper performance.

Speaker(s):

Shawn Meyers

Track and Room: DBA - 120

Title: Table Partitions for Archiving

Abstract: What is Table Partitioning? How can it be used to move large amounts of data quickly? How can it be used with a data archiving strategy to quickly and easily drop archived data from a table? We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you.

Speaker(s):

Eric Zierdt

Track and Room: Developer - 121

Title: Fun with Availability Groups

Abstract: Follow along as we adventure through the vastness that is Availability Groups in SQL Server. In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.

Speaker(s):

Christopher Wolff

Track and Room: Developer - 120

Title: What SQL DBAs need to know about SharePoint

Abstract: With the number of deployments of SharePoint exponentially growing every day, as a DBA, it is very likely you are going to have SharePoint databases on SQL Servers you support. This session reviews SharePoint strictly from the SQL Server perspective. You will learn how SharePoint is optimized for SQL, how to properly manage and maintain the SharePoint databases, how to optimize the SQL configuration for SharePoint, what settings in SharePoint need to be changed or not changed to maintain SQL Server performance, and supported methods for providing high availability and disaster recovery.

Speaker(s):

JD Wade

Track and Room: DBA - 117

Title: Become the DBA of the future! Everything you need to know about Azure

Abstract: In the world of Data Platform a variety of solutions are available going from on premises, hybrid to cloud solutions. Database Administrators play a crucial role in application design and architecture, providing mission critical and highly available solutions. In this session you will learn everything a DBA needs to know about Azure. You’ll learn about SQL Server running in Windows Azure virtual machines, Azure Storage and network configurations, SQL Database and how to manage and support workloads running in a traditional, hybrid and cloud based environment. Become the DBA of the future!

Speaker(s):

Dandy Weyn

Track and Room: Cloud Big Data - 120

Title: Power BI

Abstract: Come see Dandy do real-time analytics on #SQLSatOmaha tweets and see how Power BI pulls all of the data together in a way that tells a story for any audience!

Speaker(s):

Dandy Weyn

Track and Room: Data BI - 120

Title: Size: Blue Color: M Wait, What!?!

Abstract: How many times have you received data from a 3rd party or from within your own databases that has anomalies in it? What are the typical steps to clean up the data before it goes into the data warehouse or other systems? This session will demonstrate Data Quality Services, using both the client interface to define domains and rules, as well as the control included with Integration Services, allowing cleansing to occur within the data flow task.

Speaker(s):

Jason Dempster

Track and Room: Data BI - 121

Title: APPLY Yourself

Abstract: Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

Speaker(s):

Kevin Feasel

Track and Room: Developer - 122

Title: What is Biml and why are SSIS people talking about it?

Abstract: This session is designed for you, the experienced SSIS developer who’s been hearing about Biml but hasn’t taken the plunge. We will cover what Biml is and walk through some examples from Hello World equivalent to a fully baked truncate and reload pattern. You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.

Speaker(s):

Bill Fellows

Track and Room: Data BI - 121

Title: So You Want a Job in Big Data?

Abstract: Have you considered expanding your current skill set and seeking a long-term career in Big Data but don’t know what to learn or where to start? Do I have to learn Java, Scala, Python? Do I have to become a Unix guru or get a Ph.D in mathematics? This session will show you the different routes to a new Big Data career and provide you the resources and toolsets you’ll need to know to get yourself started.

Speaker(s):

Scott Shaw

Track and Room: Cloud Big Data - 122

Title: 10 Things Every DBA Should Know!

Abstract: Are you just starting out in the database world? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered ‘Yes’ to either of those questions, then this is the session for you! John will be talking about things from both an administrative and developmental aspect that every DBA should know and understand. We’ll look at things like Auto Shrink, SELECT *, Index Basics and 7 others!

Speaker(s):

John Morehouse

Track and Room: DBA - 121

Title: Much Ado About Hadoop

Abstract: Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.

Speaker(s):

Kevin Feasel

Track and Room: Cloud Big Data - 117

Title: Navigating the Hadoop Stack

Abstract: Hadoop distributions can be a complicated road to navigate. Application names such as Spark, Pig, Hive, Falcon, and Ranger are interesting but give no indication as to what purpose they server or how they can be helpful to your organization. We’ll take time in this session to work through the various components (Hortonworks HDP ships with 23 projects) and find which ones fit into your specific needs.

Speaker(s):

Scott Shaw

Track and Room: Cloud Big Data - 118

Title: Establishing a SLA

Abstract: Most DBA’s rarely establish Service Level Agreements (SLA) with the Management and if they do they sometimes just come up with some random numbers for availability. Then when at some point something goes really wrong everybody wonders why it takes so long to bring everything back online. #160; This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA.

Speaker(s):

Thomas Grohser

Track and Room: Soft Skills - 118

Title: Mission Critical Confidence – (SQL 2012/2014 AlwaysOn) and Availability Groups

Abstract: AlwaysOn is SQL Server 2012/2014’s High Availability solution. It provides a new standard for mission critical databases and end-to-end business intelligence at a lower total cost of ownership. It provides the required 9S of availability without the total cost and complexity. In this session, we’ll specifically explore high availability databases – Availability Groups. AG is a new feature that enhances and combines database mirroring and log shipping. We’ll demonstrate the setup and failover of multiple databases simultaneously.

Speaker(s):

Mark Skiles

Track and Room: DBA - 119

Title: Data Architecture 101

Abstract: This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

Speaker(s):

Pat Phelan

Track and Room: Soft Skills - 120

Title: Protecting Your Data with Encryption

Abstract: We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data. In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption. We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.

Speaker(s):

Ed Leighton-Dick

Track and Room: Security - 119

Title: Microsoft APS - SMP vs. MPP

Abstract: Get to know more about the Microsoft Analytical Platform System and how a MPP system is different than a SMP system.

Learn about how the MPP architecture can benefit hundreds of business use-cases and scenarios while providing phenomenal performance gains over a traditional SMP architecture.

Speaker(s):

Chaitanya Khaladkar

Track and Room: Cloud Big Data - 117

Speakers

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

Shawn Meyers

Twitter: - 1dizzygoose

LinkedIn: Shawn Meyers

Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events. Current focus is on improving DBAs lives with better infrastructure.

Scott Shaw

Twitter: - @shawsql

LinkedIn: Scott Shaw

Contact: http://www.dbaexperience.com

Scott Shaw has over a decade of experience in data management. He is a frequent speaker at local and national community events and has co-authored two books on T-SQL. He teaches as well as implements Pig, Hive, Hadoop, as well as teaches courses on SQL Server, and Microsoft BI. He is currently working on a book titled quot;Practical Hive” to be published by Apress publishing. He lives in St. Louis and is a Sr. Solutions Engineer for Hortonworks.

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.com

John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

Scott Shaw

Twitter: - @shawsql

LinkedIn: Scott Shaw

Contact: http://www.dbaexperience.com

Chris Shaw

Twitter: - @SQLShaw

LinkedIn: Chris Shaw

Contact: http://chrisshaw.wordpress.com/

Chris Shaw started his database career in 1993. Following the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences. Chris received his 5th Microsoft MVP award.

Ed Leighton-Dick

Twitter: - eleightondick

LinkedIn: Ed Leighton-Dick

Contact: http://www.edleightondick.com

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.

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.

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

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.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

Pat Phelan

Twitter: - @YetAnotherSQL

LinkedIn: Pat Phelan

Pat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.

JD Wade

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

LinkedIn: JD Wade

Contact: http://wadingthrough.com

JD Wade has been providing solutions using various Microsoft products in the St. Louis area for over 18 years. J.D.’s expertise is the architecture, design, deployment, and troubleshooting of SharePoint and Microsoft Cloud solutions as well as interfacing with the surrounding technologies (directory services, e-mail, load balancers, DNS, SQL, WAN accelerators, etc.). J.D. has worked on the deployment of various corporate intranet, extranet, and public-facing web sites.

Jared Karney

Twitter: - jaredkarney

LinkedIn: Jared Karney

Jared Karney has been working with SQL Server since 2007. He currently works as a Premier Field Engineer for Microsoft. His specialties include performance tuning, big data, cloud, automation, internals, and overall architecture. He is an MCT and holds a number of Microsoft certifications. He is also a leader for the Chicago SQL Server Users Group.

Thomas Grohser

LinkedIn: Thomas Grohser

Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

Jason Dempster

I have been working with SQL Server for over 10 years, in both database developer and administrator roles. I have worked with SQL Server 2000 - 2012, with my current focus on the BI stack and MDM components in SQL Server 2012.

Paul Timmerman

Contact: http://blogs.lessthandot.com/index.php/author/mndba/

Paul is a Microsoft SQL Server MVP and the Lead SQL Server DBA at Hennepin County Medical Center in Minneapolis, Minnesota. Paul has fifteen years of experience in database administration and currently the Chapter Leader of the Minnesota SQL Server User Group, PASSMN. Paul is an active member of the PASS community and routinely speaks at user group meetings and SQLSaturday conferences.

Chaitanya Khaladkar

Contact: http://blog.gnetgroup.com

Chaitanya is a Solutions Architect with GNet Group, a Microsoft Gold Certified Data Analytics and Collaboration partner. He has over 10 years of in-depth experience leading and architecting solutions in areas of Data Analytics/BI, Data Governance amp; Master Data, and Collaborative Business Applications.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Eric Zierdt

Twitter: - @EricZierdt

LinkedIn: Eric Zierdt

Contact: http://ericemployed.blogspot.com

Eric is a level 70 Data Slayer, who has worked with SQL Server since 2000. Eric has worked with benefit systems, real estate data, marketing, game data, and medical device data. Eric enjoys performance tuning, T-SQL programming, and SQL Server Administration.

Dandy Weyn

Twitter: - ILIKESQL

LinkedIn: Dandy Weyn

Contact: http://WWW.ILIKESQL.COM

With over 20 years of experience in the database world, Dandy Weyn is very experienced on database platforms and business intelligence. As content developer for hands-on-labs, owner of technical events, and multiple years as international consultant and trainer Dandy offers the unique combination of deep technical and solid presentation skills. He is an MCM for SQL Server, Microsoft Certified Trainer and Global Technical Lead for Data Platform in the Enterprise Partner Group (EPG) at Microsoft.

Christopher Wolff

Twitter: - @tickytong

LinkedIn: Christopher Wolff

Contact: http://sqlred.blogspot.com/

Chris Wolff has been a developer, report writer, and an admin in Microsoft and SQL Server Space since SQL Server 2000 in industries such as telecommunications, green energy, money transfers, and online accounting. He has been an active member of the Denver SQL User Group since 2011 and enjoys learning new things about computers. His interests includes video games, movies, and enjoying time with his wife and 2 kids.

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.

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.

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.

Mark Skiles

LinkedIn: Mark Skiles

Mark Skiles is a (BI) Solutions Architect with Architect IT in Des Moines, IA. He and his wife live in Carlisle, IA. He is an international consultant and has worked for EDS in Taiwan and traveled extensively in China and Southeast Asia. He has over 28 years of technology experience and has worked with SQL server since 1995. His areas of interest are designing and integrating large scale databases and continual improvement in the presentation of data – ways to turn data into decisions.

Dandy Weyn

Twitter: - ILIKESQL

LinkedIn: Dandy Weyn

Contact: http://WWW.ILIKESQL.COM

Bob Pusateri

Twitter: - @SQLBob

LinkedIn: Bob Pusateri

Contact: http://www.BobPusateri.com

Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).

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.

SQLSaturday #397 - Omaha 2015

Sessions

Title: Performing a SQL Server Health Check

Title: Whatcha Doin’? Passive Security for Hostile Environments

Title: What is causing my database to grow?

Title: Getting Started with MDX

Title: Introducing Forensic Analytics with PowerPivot for Excel

Title: Scary Things A Database Owner Can Do

Title: Tips for SQL Server Performance and Resiliency

Title: The Database: The Elephant in the ALM Room

Title: Social Networking Is Alive!!!

Title: SQL Server Benchmarking: The Powershell Speedometer

Title: SQL Server 2016 Overview

Title: Virtualize Clusters and AlwaysOn Availability Groups

Title: Table Partitions for Archiving

Title: Fun with Availability Groups

Title: What SQL DBAs need to know about SharePoint

Title: Become the DBA of the future! Everything you need to know about Azure

Title: Power BI

Title: Size: Blue Color: M Wait, What!?!

Title: APPLY Yourself

Title: What is Biml and why are SSIS people talking about it?

Title: So You Want a Job in Big Data?

Title: 10 Things Every DBA Should Know!

Title: Much Ado About Hadoop

Title: Navigating the Hadoop Stack

Title: Establishing a SLA

Title: Mission Critical Confidence – (SQL 2012/2014 AlwaysOn) and Availability Groups

Title: Data Architecture 101

Title: Protecting Your Data with Encryption

Title: Microsoft APS - SMP vs. MPP

Speakers

Sponsors