Event Location:
Eastern Washington University CEB
526 5th St, Cheney, WA
Spokane, Washington
Abstract:
Your database is running fine month after month with no problems. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error“, or something even scarier. Do you know what to do now? We will walk through 3 corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you can do to protect yourself when corruption strikes. Learn how to avoid making things worse, and how to protect your data if things do get worse. You will leave with a checklist of steps to use when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.
Speaker(s): Steve Stedman,
Abstract:
This session is based off research performed on objects, design and code built to be as similar as possible to see how Oracle and SQL Server compare in performance, usage and storage of indices. Based off trusted measurements in each platform, we’ll dig into how the use case was built, the similarities and the differences in each. What we can admire about how each product has matured in the way of managing index data, statistics and how the optimizer hinders and enhances index availability. Takeaways are: 1. Receive a strong education on platform differences between Oracle and SQL Server. 2. Discover hidden insight on index storage and costs. 3. Learn about great tips on maintaining index health and how one platform may perform better than the other and how. 4. Translation of common features in both platforms
Speaker(s): Kellyn Pot'Vin-Gorman,
Abstract:
In this presentation, we’ll review “What is ‘the Cloud’” and then describe the different methods you can use to migrate your on-premise SQLServer databases into this new environment. We’ll cover migrations to both infrastructure and database as a service. We’ll describe in detail how the use of a database replication tool can help you migrate your databases to the cloud with almost no downtime, and reduce the risk of data loss. We’ll also show you how you can use replication after migration to keep on-premise and cloud databases synchronized, which can help you migrate to the cloud in phases, rather than all at once.
Speaker(s): Clay Jackson,
Abstract:
You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you. In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery. Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments. Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery. Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Speaker(s): Hamish Watson,
Abstract:
It has been said that novices absorb knowledge like a sponge, intermediates hoard it for themselves, and masters just simply give it away. The community spirit of PASS is for like-minded professionals to interact and share knowledge. But how do you do this in your own workplace? What happens when Bob takes off with one day of notice? How do you manage when Jane unfortunately has to spend a month in the hospital? All joking aside, the only way to truly become a master at your craft is to share your precious knowledge with your peers and workmates. We will discuss past and current trends in knowledge transfer, the reasons why you should (and shouldn’t) pass on knowledge, and methods for making this happen in your workplace and in your life. Be prepared for an interactive and lively discussion and to walk away with some new concepts that are going to make you think about how you too can become a Master!
Speaker(s): Michael Wall,
Abstract:
Data is today’s currency. Azure Data Catalog (ADC) is a relatively unknown resource in the IT community. This is an unfortunate state since ADC is an incredibly useful tool that is easy to implement and use. Companies that are able to leverage their data have seen the greatest gains in growth and market capitalization. The reason for this is simple: We live in the information age. Being able to leverage the data you gather is the invitation you need just to compete in information age. ADC is an indispensable tool that helps companies organize and make sense of the mountains of data they collect every day. By walking participants through an implementation of ADC, I will introduce them to the product, and show how easy it is to use. By presenting concrete examples of how ADC is used, I will demonstrate its importance. Participants should leave this session determined to introduce ADC to their team and resolute in their intention to implement it within their company.
Speaker(s): Melody Zacharias,
Abstract:
OR, How In-Memory Objects Can Supercharge Your Data And Bring About World Peace OK, so you’ve been reading about, perhaps even testing out some of the ‘in-memory’ objects now available in SQL Server. Some of the claims are exciting, and some seem overly optimistic. And Yet, you want to know, experience more … Perhaps your situation doesn’t really call out for in-memory tables. But you should consider memory-optimized #Temp tables, memory-optimized table variables, and natively compiled stored procedures.It’s true. Using memory-optimized tables requires a little more fore-thought, a bit more care, even a few configuration tweaks. • But what are the real advantages of memory-optimized objects? • What are the memory-optimized objects you can use? • How can you best use memory-optimized objects? In this demo packed session, we will discuss the pros and cons of using memory-optimized objects in ways that will supercharge your SQL Server.
Speaker(s): Arnie Rowland,
Abstract:
If you are into Simulation Theory a lot and often struggle with finding the reality a lot, conceptually Master Data Services 2016 features will help you move towards the solution of Golden Record with least amount of struggle. Are you one of those organization who is still trying to find a single cheap solution to data management and have been ignoring Master Data Services 2016 features? Over the past 9 years history with MDS/MDM; with MDM products you don’t leverage your pathways; rather you set in stone in data governance field. Microsoft’s Master Data Services 2016 product has been feature enhancements is designed to find out what is master data record in various siloed structures. This EIM suit provides a single version of truth while maintaining dimensions at a step prior to EDW. SQL Server Master Data Services 2016 feature enhancements, tremendously helpful to the users can be grouped into: Business rules enhancements, Domain based attributes usages across Hierarchies, Import T
Speaker(s): Swagatika Sarangi,
Abstract:
Stop fretting about giving presentations -you CAN decide to become more confident, come across more polished, and actually present with authority. In this session, you will learn and pick up some great tips about how to better prepare, and then present, technical material. You WILL leave with an improved sense of possibility! Arnie will guide you with techniques to better understand and match the audience's expectations to your presentation goals. You will gain a better understanding of how to prepare your presentation, as well as how to get, and hold the audience's attention. And even how to be more relaxed with the inevitable critique from colleagues. Ramp up your career. Don't miss this session!
Speaker(s): Arnie Rowland,
Abstract:
Do you feel like you are repeating the same things over and over in SSIS? If so, then it’s time to learn how to create dynamic, reusable SSIS packages! This session will demonstrate how to leverage parameters, variables, and environment variables to get the most out of your packages.
Speaker(s): Elizabeth Hunt,
Abstract:
Power BI is a rapidly growing data presentation and analytics tool, capable of connecting directly to a variety of data sources. That doesn’t mean you don’t need a data warehouse. The good news is that the tools needed to build a modern data warehouse are readily available in the cloud. In this presentation, we’ll Use Azure services to extract, load, and transform transactional data using Azure Data Factory, Azure Functions, Azure SQL, and Azure Analysis Services to create an agile and scalable data warehouse consumable by Power BI.
Speaker(s): Philip Spokas,
Abstract:
A Production DBAs job is to protect the data, ensuring it is well cared for and secure. But what about disasters you can't prevent? Corruption, unintended modifications or deletes or hardware failures? It's important for DBAs and their end users be in agreement in how their data is handled in the event of a disaster (or even what constitutes a disaster). In this session we'll look at the two most important recovery metrics (RPO RTO) and how to handle the expectations of your end users in regards to their data.
Speaker(s): josh smith,
Abstract:
In today's fast-paced world, businesses require up to the minute information to support critical decisions. Traditional business intelligence solutions, however, are not able to keep up with this demand and a new approach is required. Azure Stream Analytics is a real-time event processing engine capable of analyzing millions of events every second. During this session, you will learn some of the key concepts needed to work with streaming data before stepping through an end-to-end streaming data solution.
Speaker(s): Michael Johnson,
Abstract:
In this interactive session we will discuss what and who to take into consideration when thinking about a data strategy
Speaker(s): Jody Roberts,
Abstract:
R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.
Speaker(s): Kevin Feasel,
Abstract:
In one small step, SQL Server 2016 has taken a giant leap...to JSON! In this session, we'll launch a probe into a JSON data file containing profiles of NASA astronauts using new JSON T-SQL functions in SQL Server. With each astronaut we meet, we'll learn to validate, read, and manipulate "unstructured" JSON data. We'll get The Right Stuff to start developing, no previous JSON experience required. Let's go where NoSQL has gone before! Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.
Speaker(s): Peter Kral,
Abstract:
A default SQL Server installation is reasonably secure, but quot;reasonably securequot; doesn't cut it in an era in which one bad line of code, one weak password, or one open port can result in your customer database ending up on Pastebin. In this talk, we will look at different methods of securing a SQL Server instance, from venerable (principle of least privilege, Transparent Data Encryption) to novel (Always Encrypted, row-level security). These tools and techniques will show us ways for developers, database administrators, and network specialists to work together to secure SQL Server instances.
Speaker(s): Kevin Feasel,
Abstract:
Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. 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,
Abstract:
No relational database experience? No problem! This session is targeting at the students of zero database experience. You will learn the concept of relational database in general. We will talk about how to represent information in a relational database and how to develop SQL queries to retrieve information from a database.
Speaker(s): Dan Li,
Abstract:
Most of us have heard that using the NOLOCK hint is not recommended. But why is this? What is it about NOLOCK that sends most DBAs into a tizzy? And how about other hints such as ROWLOCK and RECOMPILE - are they OK to use? Come hear a discussion on why exactly query hints cause problems when used excessively, and watch some demos of NOLOCK craziness in action.
Speaker(s): Rick Lowe,
Abstract:
Are you trying to understand what’s the fuzz around Machine Learning? Are you working with a lot of data analysis and wondered how SQL Server 2016 R Services might be able to help? This session will provide a gentle and fun introduction to SQL Server R Services for SQL Nerds. We will walk through pragmatic examples of using R through demos, to illustrate Machine Learning in boosting your Data Analysis capabilities. The goal of this session is to provide quick tips and tricks for attendees to get started on SQL Server R Services, either for fun or for work.
Speaker(s): Julie Koesmarno,
Abstract:
Confidence is the fuel for action. How often have you thought about wanting to do something and thought you may not be successful at it, so it then became too much work to try? The American Pastor Robert Shuler famously asked a very powerful question: “What would you do if you knew you could not fail?” Come explore this exciting topic with me, and we will see what we can accomplish together!
Speaker(s): Melody Zacharias,
Abstract:
In this session, I'll start with only Power BI installed. I will show how you can: - Get data from a public website - Prep the data - Model the data - Explore the data - Create reports
Speaker(s): Kyle Stevenson,
Abstract:
One of the most recurrent questions among DBAs tasked to move databases from on-premises to the cloud is "how do I automate tasks in Azure SQL Database", "Where is SQL Server Agent?". In this session full of demos we will see how to implement various kinds of SQL Server Agent jobs for Azure SQL Database.
Speaker(s): Armando Lacerda,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://ca.linkedin.com/in/melodyzacharias
Contact: http://sqlmelody.com
Melody is the Sr. Microsoft Solutions Manager at Pure and has been in love with data since 1991. She has been sharing her passion with the community in technical sessions and blogs since 2014. She has been a Microsoft MVP since 2016, including winning Rookie of the year for Canada that year. This last year, she was elected to the board of directors for PASS.org, the professional association for SQL Server and was awarded Regional Director by Microsoft. She has co-authored 3 books, including, SQL Server 2019 Administration inside out by Microsoft Press.
LinkedIn: https://www.linkedin.com/in/arnie
Contact: http://sqlblog.com/blogs/arnie_rowland/
Arnie long ago realized that most issues between Developer and DBA comes from incomplete communication and a misunderstanding of each other's objectives. He is a frequent Trainer and Mentor for Developers and DBAs, bringing both sets of skills to better communicate with teams to create a working solution. For over a decade, Arnie has been a SQL Server MVP, Certified Trainer, technical editor for several publishers, including MOC, and has served as University and Community College adjunct faculty. Clients include Fortune 500 and Multi-Nationals, Federal and State agencies, Foreign governments, and local enterprises –both public and private.
LinkedIn: https://www.linkedin.com/in/arnie
Contact: http://sqlblog.com/blogs/arnie_rowland/
Arnie long ago realized that most issues between Developer and DBA comes from incomplete communication and a misunderstanding of each other's objectives. He is a frequent Trainer and Mentor for Developers and DBAs, bringing both sets of skills to better communicate with teams to create a working solution. For over a decade, Arnie has been a SQL Server MVP, Certified Trainer, technical editor for several publishers, including MOC, and has served as University and Community College adjunct faculty. Clients include Fortune 500 and Multi-Nationals, Federal and State agencies, Foreign governments, and local enterprises –both public and private.
LinkedIn: https://www.linkedin.com/pub/mike-wall/b/110/9a
Contact: http://www.becomingamaster.com
Michael Wall has been an IT professional going back to when he had his own software store and worked with his customers with their “dose” problems. Originally hired by a small consulting firm to write web pages, he was thrust into the SysAdmin world when their lead consultant changed the passwords of all of the servers at a major pulp and paper company’s systems to 100%s$%t and walked out the door. He was sent down with a copy of UNIX for Dummies and 50 cents for the bus ride back. Fast forward a few years, he was asked if he wanted to be a DBA after successfully managing a fifty server Y2K upgrade. Since then, he’s never looked back and has survived a number of data and system challenges. When not wrangling cats at home, he currently
LinkedIn: http://www.linkedin.com/pub/rick-lowe/a/228/441/
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated... eventually specializing more on performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
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.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
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.
LinkedIn: https://www.linkedin.com/in/kellynpotvin
Contact: http://dbakevlar.com
Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design. Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.
LinkedIn: http://www.linkedin.com/in/kyle-stevenson-2572a613
I'm currently the Analytics and Master Data Manager at Clearwater Paper. My teams are responsible for the Enterprise Data Warehouse and Master Data. I've previously worked as a Software Development Manager, ETL Engineer, and Business Intelligence Architect. My hobbies outside of work include spending time with my wife and three boys, training for marathons and triathlons, and watching my favorite sports.
LinkedIn: http://www.linkedin.com/in/philspokas
Contact: http://intellitect.com/phil
Vice President of Professional Services for IntelliTect with extensive executive management and leadership experience. Accomplishments include strategy, architecture and design of several innovative data driven Software as a Service solutions, development of agile management practices, enterprise data architecture solutions, and the original design, architecture and development of the OnTrack Manufacturing Execution System. Holds Scrum, DevOps and Cloud Services industry certifications.
LinkedIn: http://www.linkedin.com/in/juliekoesmarno
Contact: http://www.mssqlgirl.com
Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.
LinkedIn: http://www.linkedin.com/pub/allen-white-sql-server-mvp/5/784/b08/
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.
Dr. Dan Li received her Ph.D. degree in Computer Science from University of Nebraska - Lincoln, in 2005. She is currently an Associate Professor in Computer Science Department at Eastern Washington University. Her current research interests include large-scale databases, data mining, information security, and computer science education.
Clay Jackson is a Database Sales Engineer for Quest, specializing in Database Performance Management and Replication Tools. Prior to joining Quest, Jackson was the DBA Manager at Darigold. He also spent over 10 years managing Oracle, SQLServer and DB2 databases and DBAs at Washington Mutual and was employee number 66 at Microsoft, spending time in Product Support, MIS and OS/2 Development. While at WaMu, Jackson was the Enterprise Database Compliance Officer, with responsibility for Database Security and Disaster Recovery. He also worked at Microsoft and Starbucks, is a CISM, and has a Masters in Software Engineering from Seattle University.
LinkedIn: http://za.linkedin.com/pub/michael-johnson/22/73/735
Contact: http://michaeladrianjohnson.com/
Michael Johnson is a Microsoft data platform MVP and leader of the Johannesburg SQL User Group and Business Analytics Virtual Group. He works as an Independent Business Intelligence Consultant and regularly presents at local user groups, SQL Saturdays and PASS Virtual Chapters.
LinkedIn: https://www.linkedin.com/in/sarangiswagatika/
Contact: https://www.jazzintelligence.com/
*** AWS - SA Informatica - MDM Certified, Solutions Architect *** I have had nearly a decade of experience in leading Data Governance, Master Data and Data Quality oriented efforts, strategizing business plan, implementing all phases of SDLC and Agile for clients/projects including Telecommunication, Oil Gas, Sporting goods, Logistics, Consulting, Insurance, Restaurant Education etc. domain. I have extensive experience with developing effective business roadmaps and business models across E-Commerce, B2C, B2B, B2B2C with a major focus in effectively evaluating/and aligning Business Intelligence Analytics Data Warehousing with the appropriate KPI's.
LinkedIn: https://nz.linkedin.com/in/hamishwatson8
Contact: http://www.sqlservercentral.com/blogs/the-hybrid-dbas-blog/
Hamish Watson is a Microsoft Data Platform MVP and VMware Expert with a passion for efficient database and application deployment using DevOps methodologies. He has 20+ years of IT experience in managing and deploying large scale databases on SQL Server technologies. He has been managing SQL Server since SQL Server 2000, and pragmatic approaches to delivering business value to clients is his career passion. Educating and helping others learn is a driver for Hamish. He is a Director-At-Large on the PASS Board, international speaker, and a repeat guest lecturer at a local university.
LinkedIn: https://www.linkedin.com/in/peterkral
Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.
LinkedIn: http://www.linkedin.com/in/stevestedman
Contact: http://SteveStedman.com
Steve Stedman is the Leader of a PASS Local Group in Bellingham WA USA. Steve runs his own SQL consulting firm Stedman Solutions, LLC. He has 29 years of programming and SQL experience. He has written the book on SQL Common Table Expressions. He teaches, speaks at conferences, writes, and has taught SQL server classes at Western Washington University. Steve has previously spoken at PASS Summit, TechEd, DevTeach Vancouver, many SQL Saturdays, and more.
Elizabeth has 11 years of programming experience, focusing mostly on SQL, C#, and the MS BI stack for the last 8 years. She also graduated from DeVry University in 2015 with a Bachelor of Science Degree in Database Management.
LinkedIn: http://za.linkedin.com/pub/jody-roberts/7/b29/193/Edit
Contact: http://JodyWP.wordpress.com
Jody Roberts is a Microsoft Data Platform MVP based in Cape Town, South Africa. He specializes in SQL Server architecture, disaster recovery (DR), and server optimization. Jody serves as a PASS Regional Mentor responsible for the Middle East amp; Africa, Chapter Lead of the SQLCape user group, and Co-Lead of the PASS Cloud Virtual Chapter. Jody is a Principal Consultant at Northern Data.
LinkedIn: http://www.linkedin.com/in/armando-lacerda
Over 30 years in the computing field as a developer and system integrator; over 20 years working with SQL Server since version 6; cross platform experience with Oracle and IBM SQL/DS and DB2; Microsoft Certified Trainer for over 20 years.
LinkedIn: https://www.linkedin.com/in/toosuto/
Contact: https://accitentionaldba.com
Josh Smith is the senior-most DBA at a mid-sized credit union and leader of the Spokane Area SQL Server Users Group. He is not the most fond of writing about himself in the third person but attempts to be good natured about it. He believes strongly in participating in and contributing to the SQL Server community as much as possible.
LinkedIn: http://ca.linkedin.com/in/melodyzacharias
Contact: http://sqlmelody.com
Melody is the Sr. Microsoft Solutions Manager at Pure and has been in love with data since 1991. She has been sharing her passion with the community in technical sessions and blogs since 2014. She has been a Microsoft MVP since 2016, including winning Rookie of the year for Canada that year. This last year, she was elected to the board of directors for PASS.org, the professional association for SQL Server and was awarded Regional Director by Microsoft. She has co-authored 3 books, including, SQL Server 2019 Administration inside out by Microsoft Press.
The following is a list of sponsors that helped fund the event.