Querying Data with T-SQL from SQL Server

Ami has been teaching, consulting, and mentoring data professionals for over 20 years. Ami's broad theoretical knowledge in data management is complemented by extensive hands-on experience working as a data tier architect, performance tuning expert, and a SQL developer, while at the same time directing and teaching others how to get the most value from their data. Ami owns a US patent for an automatic solution for optimizing database performance. Ami has been highly involved in the SQL communit... morey, leading the Silicon Valley Microsoft Data Platform User Group, speaking at user groups, conferences, online events, and is a contributor to online forums. He was honored by the Microsoft MVP award for 11 years. In his free time, Ami likes to take care of his 4 rescue cats, listen to music on his audiophile stereo system, and volunteer at animal shelters. Naturally, Ami is also a strict vegetarian. He loves riding his motorcycle on long trips across the country.

Tamara Pattinson is a software developer, business consultant, and instructor with over 20 years of experience in Information Technology She has a passion for teaching and is the former Dean of Computer Science at a private college where she taught the full gamut of software development languages, SQL, database administration and design, and project management. In 2007, Tamara founded JET Technical located in beautiful Cache Valley Utah. While initially started to provide graduate students a... more way to gain real-world experience under the tutelage of seasoned professionals, today, JET Technical is a global software development group comprised of professional software engineers and project management professionals. Tamara has focused on back-end development using tools such as Microsoft .NET technologies, C#, Visual Basic, PHP, database administration, and data science. She is currently a Technical Curriculum Manager at Pluralsight.

Xavier is very passionate about teaching, helping others understand search and Big Data. He is also an entrepreneur, project manager, technical author, trainer, and holds a few certifications with Cloudera, Microsoft, and the Scrum Alliance, along with being a Microsoft MVP. He has spent a great deal of his career working on cutting-edge projects with a primary focus on .NET, Solr, and Hadoop among a few other interesting technologies. Throughout multiple projects, he has acquired skills to deal... more with complex enterprise software solutions, working with companies that range from startups to Microsoft. Xavier also worked as a worldwide v-trainer/evangelist for Microsoft.

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data giv... morees Jared a chance to combine his passions for technology and creativity. Tracking data, whether steps taken or money spent, has become an obsession. He loves spending time with his wonderful wife Amanda and three children in his spare time. Jared enjoys lifting weights, along with a good Netflix binge.

Passionate about Business Intelligence and delivering knowledge and insight to support better decisions. An advocate of Self-Service Reporting and Analytics and a Data Visualisation evangelist. Andi has delivered face to face Business Intelligence training to many industries, covering topics such as Report Design, Semantic Layer, Dimensional modeling and Data Visualisation. Andi has led many Data Warehouse and Business Intelligence development projects and is well versed in taking complex an... mored chaotic data and turning it into something simple and easy to understand. Andi is a keen cyclist and amateur cook and lives with his wife in Southern Spain.