• Azure SQL DB Serverless, a new autonomous database? - Gonzalo Bissio

    Meeting link: https://bit.ly/3eVjCmy

    In this session, we are going to cover Azure SQL DB Serverless compute tier... Introduction, best practices, demos, and some limitations!

    We will be raffling off a gift card at the end of this session.

    Speaker:

    Gonzalo Bissio - Customer Engineer @Microsoft. I am truly passionate about SQL Server on all of its editions (that include express as well (?)). I’m a speaker of the PASS Argentina chapter, father of Pedro, Fan of Club atletico Independiente from Argentina (Soccer or futbol fan 😛😛), and Rocky Balboa’s Soldier💪🏻💪🏻💪🏻👊🏻👊🏻👊🏻. I have the following certifications -> Microsoft certified trainer, Azure Database administrator, Azure data engineer, and Azure administrator but the most important one is that I LOVE AZURE SQL! On all of the versions.

    Sponsor:

    Sentry One - https://www.sentryone.com/sql-server/sql-server-monitoring - Ryan Mollien - [masked]

    1
  • Turn Runbooks into Notebooks: ADS for the On-Call DBA - Matt Gordon

    Meeting link: https://bit.ly/35JWfIn

    On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" We start scrambling to piece together various scripts to analyze the emergency, mitigate the issues, and kick off a failover or similar fix to make the database happy and healthy once again. Even scheduled maintenance likely requires us to download scripts from a ticket, run the scripts, and screenshot the results for documentation. What if I told you that Azure Data Studio's notebooks allow you to execute T-SQL and PowerShell together to handle these processes from a single document that documents its own results and can be stored directly in source control? Join me in this demo-heavy session to see how we can handle real-world on-call situations using Azure Data Studio notebooks.

    Speaker:

    Matt Gordon is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.

    Sponsor:

    TBA

    1
  • JSSUG Tech Discussion - Happy Hour & Gift Card Raffle

    Online event

    Join us tonight for a Tech Discussion of your choice, latest news, happy hour, and gift card raffle!

    Let us know what you'd like the group to be doing for you over the next half year!

    Don't forget to register here for the online meeting: https://attendee.gotowebinar.com/register/5220446432583757583

    Speaker:

    Open Forum

    Sponsor:

    TBA

  • Statistics and Query Plans - Speaker: Erin Stellato, MVP

    Online event

    Register here for session: https://attendee.gotowebinar.com/register/2370811358746641931

    If you want to tune queries, you have to look at query plans and you have to understand what they’re showing you. One thing people look for when tuning is “bad cardinality estimates”. If you’ve wondered what that means, and you want to understand how the optimizer uses statistics when creating a query plan, then join me for this session on statistics and query plans. We’ll set the stage with a review of what statistics are, then see how the optimizer uses them and where to find that “cardinality estimate” information in a plan. We’ll also cover the various ways statistics can be updated, explore what happens to plans when those updates occur, and ultimately you will see why understanding how it all works is critical when you’re troubleshooting performance issues. Expect lots of demos so you can truly understand what statistics are, how they're used and what to look for in a plan, and why their management is so essential for good performance.

    Speaker:

    Erin Stellato is a Data Platform MVP and lives in Cleveland, OH. She has over 19 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include Query Store, statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection, SQLBits, and the PASS Summit. Outside of time with family and friends, she enjoys running, baking, movies, and all things chocolate.

    Sponsor:

    JSSUG

    3
  • Infrastructure for Modern SQL Server Deployments - Speaker: Allan Hirt, MVP

    Register here for the session:

    https://attendee.gotowebinar.com/register/1842083704539592973

    While some are still deploying SQL Server on physical hardware, most are using virtualization or cloud-based solutions to deploy instances and databases. Core infrastructure topics such as CPU, disk, and networking still apply, but the paradigms have changed whether you are deploying on Windows Server or Linux, on-premises, or in the public cloud with Azure, AWS, or GCP. Without understanding the building blocks as they are implemented today, VMs and IaaS deployments will not scale, may underperform, and most likely will have poor availability. This session will give you the foundation to properly deploy SQL Server instances and databases on-premises or in the public cloud to go from SQL Server zero to SQL Server hero and be able to have better working relationships with the other administrators in your organization.

    After Allan's presentation, we will hold an online happy hour. Feel free to hang out and chat with everyone on video chat.

    Speaker:

    Allan Hirt - Consultant, trainer, author, business continuity expert, and SQLHA, LLC founder Allan Hirt has been working with both SQL Server since 1992 when it was still a Sybase product as well as clustering in Windows Server since the late 1990s when it was called Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan travels around the world to work with customers, deliver training, speak at events, and have a few laughs along the way.

    Sponsor:

    JSSUG

    2
  • PreCon: Power BI Deep Dive Precon - Ginger Grant

    University of North Florida

    $150.00
    1
  • Building Your First Power App Portal with Common Data Services - Brian Knight

    Click here to join the webinar: https://attendee.gotowebinar.com/register/178959117559964173

    Learn how to create a data model in Common Data Services (CDS) where you can then use across the entire Power Platform. For this session, we’ll create a quick application to show and allow your users to enter data directly into CDS and secure it with record-level security.

    Featured Speakers:

    Brian Knight is the owner and founder of Pragmatic Works and is a serial entrepreneur, starting up other companies. Brian is a contributing columnist at several technical magazines and does regular webcasts. He is the author of more than a fifteen technical books. Brian has spoken at dozens of technical and business conferences around the world. He has received a number of awards from the state, governor and press like the Business Ambassador Award (Governor) and Top CEO (Jacksonville Magazine). His blog can be found at http://www.pragmaticworks.com.

    Sponsor:

    JSSUG/PASS

    5
  • JSSUG Monthly Meeting - Topic TBA

    Keiser University

    2
  • [ONLINE] Interactive AI with Azure Cognitive Services - Matt Gordon

    Needs a location

    https://global.gotomeeting.com/join/845440077

    We will be having an online meeting thanks to PASS, GoToMeeting and our speaker Matt Gordon - @SQLAtSpeed - See link Below.

    Customers and users increasingly demand more personal and prompt communication from companies and brands with which they interact. How can data professionals help fill that need? The incredible power and instant accessibility of the Azure Cognitive Services Language and Speech APIs, combined with other Azure services, put the power in our hands. From translating between languages to make communication more efficient to analyzing support communications to ensure customers are happy, Azure Cognitive Services allows data professionals to enhance a brand's interaction with and impression in the customer community. This demo-heavy sessions walks through practical applications of these APIs that you can apply at home or at work immediately after the session.

    Speaker:

    Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.

    A Dialogue with your Data: Interactive AI with Azure Cognitive Services - Matt Gordon
    Wed, Mar 18,[masked]:45 PM - 8:15 PM (EDT)

    You can join from your computer, tablet or smartphone.

    https://global.gotomeeting.com/join/845440077

    You can also dial in using your phone.
    (For supported devices, tap a one-touch number below to join instantly.)

    United States (Toll Free):[masked]
    - One-touch: tel:[masked],,[masked]#

    Access Code:[masked]

    New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/845440077

    2