What we're about
Upcoming events (4+)
Azure Data Factory - ADF - is a cloud data engineering solution. While the ADF GUI and properties surface lots of cool and useful functionality, some functionality is encapsulated in the ADF REST API. In this session, I demonstrate using the ADF REST API to save money when using Azure-SSIS integration runtimes and stopping a Foreach activity on a failure (not native functionality).
Andy Leonard is a husband, dad, and grandfather; creator of – and Data Philosopher at – DILM (Data Integration Lifecycle Management) Suite; a blogger, founder and Chief Data Engineer at Enterprise Data & Analytics; an SSIS and Azure Data Factory trainer, consultant, and developer; a SQL Server database and data warehouse developer; an author, mentor, engineer, and farmer.
Have you ever wondered how to use variables and parameters in your SSIS packages? Would you like to take the automation of your SSIS packages to the fullest extent possible? Have you ever upgraded a server or your database and went through countless hours of updates to your suite of SSIS packages? If so, then this session is for you. Topics discussed in this session will include the SSIS Catalog, Environment Variables in SSMS as well as variables and parameters within SSIS packages. In addition, you will learn how to access variables and parameters outside of your SSIS package in SSMS.
Robbie Staples has over 15 years of experience writing SQL queries and 5 years working with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). He is a Microsoft Certified Systems Engineer (MCSE) in Data Management & Analytics as well as a Microsoft Certified Solutions Associate (MCSA) in SQL 2016 Database Development. He has worked in the power, banking, transportation, healthcare, and semiconductor industries with most of his experience being in the power industry. He has his Electrical Engineering degree from Virginia Commonwealth University and is a licensed Professional Engineer in Virginia and Texas. He is currently employed by Old Dominion Electric Cooperative as a Software Developer focused on automating manual processes and bringing data to the forefront of the company.
Transact-SQL (T-SQL) is a powerful language for querying data but it can be a challenge for application developers and business analysts who are not already deeply familiar with the language to solve business problems. In this session, we will use a variety of T-SQL techniques to generate Key Performance Indicators (KPIs) for a common business scenario. We will see how to calculate measures like revenue, cost, profit, lifetime value, days between orders, and much more using techniques like common table expressions, date math, window functions, percentiles, and the APPLY operator. Come learn techniques to transform your business needs into SQL answers.
Kevin Feasel is a Microsoft Data Platform MVP and CTO at FareGame Inc, 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.
This highly interactive, demo-focused session is for folks who are curious about Docker and love SQL Server. You’ll learn how to pull a SQL image from the repository, instantiate a container, and restore databases. Once we have the perfectly configured database container that we can query successfully, we’ll learn how to convert it into a golden image and save it back to a private repo where it can be used on any Docker compatible platform. During Q&A, we can touch on topics like networking, performance, compatibility, storage, and licensing.
Kevin Hazzard is the cloud strategist for Altria, based in central Virginia. He was a long-time C# MVP but he loves SQL Server and related database technologies more than anything else. When Kevin isn't playing with his grandkids, he likes to work outdoors and in the garden growing veggies.