November 2023 MeetUp (In-person Only)

Agenda
18:00 - 18:15 - Welcome
18:15 - 19:00 - Old Name - New CLI - why you should take a look at sqlcmd - Rob Sewell
Introduced with SQL Server 2005 and replacing osql, sqlcmd has been a part of SQL Server professionals toolbox for a long time now.
Many people only know it from the sqlcmd mode switch in SSMS, while others use it within automation as a lightweight easily available query runner. I have long recommended that DBAs are familiar with using it as it may be the only option to query an instance in severe emergencies.
Times they are a changing.
There is a new sqlcmd available and it has some awesome new capabilities.
Let me introduce you to the new sqlcmd in a fun filled demo session and show you the new things it can do and why they will be of benefit to all Data Professionals
We will cover deploying a database into a container from a backup with one command.
Querying it, Opening it in Azure Data Studio, all from the command line and much more.

Rob Sewell
Be-Whiskered Automator of Things
Rob was a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people make things. He is a Cloud and Data Center MVP and a Data Platform MVP, SQLBits committee member, PSConf EU organiser, and co-leader of Data South West UK User Group. H has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and PowerShell communities.
He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, he is often out riding his bike as his eyes are not good enough to play cricket any more.
He has a fabulous beard

17:30 - Pizza and networking

19:30 - 20:45 - Realtime streaming data with Microsoft Fabric - James Dales
Realtime streaming data is now possible within Microsoft’s new SaaS environment, Microsoft Fabric, without any Azure resources required.
In this session we’ll stream data from aircraft transponder data and other sensors directly into Microsoft Fabric via EventStream into KQL DB and OneLake, and analyse the results, both live and historic in Power BI.
The session will be back to back demos as we build the whole solution from scratch – what could go wrong!?

James Dales
James Dales is the Global Capability Lead for Microsoft Fabric and Power BI at Avanade and is a Microsoft FastTrack Recognised Solution Architect.
As a Microsoft Data Platform MVP he is the co-leader of the London Power BI user group.
In 2019 he became the first member of the Power BI Contributors Program, working alongside the Microsoft engineering team to build new functionality into the Power BI product itself.
He has a keen interest in spatial analytics and is the author of the Icon Map custom visual.