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 Morera is driven by one passion: taking on the challenge of understanding complex topics and sharing that knowledge with others. He’s currently focused on the transformative fields of AI, machine learning, generative AI, search, and big data. As an entrepreneur, project manager, technical author, and trainer, Xavier brings a diverse set of skills and deep expertise to every project he takes on. He holds multiple certifications with Cloudera, Microsoft, and the Scrum Alliance and has been... more recognized as a Microsoft MVP for his contributions to the tech community. With a career filled with cutting-edge projects, Xavier has developed a knack for managing complex enterprise software solutions, partnering with companies ranging from startups to tech giants like Microsoft. Currently, Xavier is the co-founder of Lupo.ai, an AI-driven SaaS platform dedicated to video creation, which he considers his Ikigai – his purpose and passion. If you want to connect or swap stories, reach out to Xavier on LinkedIn. He’s always up for a chat and has countless stories to share.

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.