SQL FRIDAY #31 – Jovan Popovic on ‘Analyze Azure data using T-SQL and Synapse SQL serverless pool’

Featured

Date:2021-01-15
Time:12:00 Central European Time (11:00AM UTC)
Register to attend:https://www.meetup.com/en-AU/SQL-Friday/events/275338429/
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #31 – Jovan Popovic on ‘Analyze Azure data using T-SQL and Synapse SQL serverless pool’

Azure Synapse SQL serverless pool is a new pay-per-usage Transact-SQL query service that enables you to analyze large amount of data stored on Azure Blob Storage, Azure Data Lake, and Azure CosmosDB. Synapse SQL is connector to Azure data for the application and tools that can use T-SQL. It is a platform where you can create Logical DataWarehouse on top of your Azure data sources. If you ever wanted to use something like a fully-managed standalone Polybase service to query PARQUET, CSV, and JSON data in Azure using standard T-SQL without pre-provisioning resources, this might be the perfect solution for you. Learn about the service that might be a future of big data analytics in Azure cloud.

About Jovan Popovic

Jovan Popovic is Senior Program Manager working on Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics. He is working in Microsoft Development Center Serbia as Program Manager on several developer-facing SQL Server/Azure SQL features such as T-SQL language enhancements, JSON/temporal support, columnstore/in-memory technologies, and built-in intelligence. He has more than 15 years of experience in various Microsoft technologies with a focus on SQL Server, Azure, ASP.NET, C#, and JavaScript. He has been working in various Microsoft Data Platform teams since 2012. He is a former Microsoft MVP for ASP.NET and has a PhD degree in software engineering from the University of Belgrade. He is a public speaker at top Microsoft conferences, and is author of several books and open-source projects. He enjoys exploring technologies (especially SQL Server capabilities) and finding the best ways to implement the most efficient solutions using them.

https://www.linkedin.com/in/jovan-popovic/
https://twitter.com/JovanPop_MSFT

SQL FRIDAY #30 – M A Nakib on ‘Azure Synapse Analytics’

Date:2021-01-08
Time:12:00 Central European Time (11:00AM UTC)
Register to attend:https://www.meetup.com/SQL-Friday/events/275338413/
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL FRIDAY #30 – M A Nakib on ‘Azure Synapse Analytics’

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless or provisioned resources—at scale.

Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

About M A Nakib

Nakib is a smart and young IT professional, MCT, Cloud Architect working with Corporate Projukti limited as Cloud Solutions. He had 2 years’ experience in Microsoft Bangladesh. Being an adviser, he involves in building and enhance solutions & customer readiness on Microsoft Azure, O365 & other Cloud based service. He assists decision making audience in context of Microsoft product & services.

Nakib is renowned community person- From graduation time he had started his community contribution from university life being an MSP LEAD. He had engaged different technical workshop being a speaker as well as organized. He started his carrier as intern on Microsoft Bangladesh. He works on tech community development and trainer in of IT education workshop jointly with government.

https://twitter.com/nakib_juris https://www.linkedin.com/in/nakibjuris/

SQL Friday 2021 Schedule Announced

Finally, the schedule for SQL Friday 2021 is done. Speakers have created session abstracts, sessions were selected, speakers have confirmed their participation and sessions were scheduled. I’m happy to announce that we have 25 top notch sessions schedules for January – June 2021.

A big Thank You goes out to all speakers – selected and not selected – for your contributions to the Data Platform community!

Check out the schedule now

SESSIONDATERegister to attendSpeaker and title
2021-01-08https://www.meetup.com/SQL-Friday/events/275338413/SQL FRIDAY #30 – M A Nakib on ‘Azure Synapse Analytics’
2021-01-15https://www.meetup.com/SQL-Friday/events/275338429/SQL FRIDAY #31 – Jovan Popovic on ‘Analyze Azure data using T-SQL and Synapse SQL serverless pool’
2021-01-22https://www.meetup.com/SQL-Friday/events/275338749/SQL FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’
2021-01-29https://www.meetup.com/SQL-Friday/events/275338804/SQL FRIDAY #33 – Geovanny Hernandez on ‘First steps to go ahead with MS SQL Server on Linux’
2021-02-05https://www.meetup.com/SQL-Friday/events/275338837/SQL FRIDAY #34 – Kevin Chant and Sander Stad on ‘GitHub DevOps Duet – SQL Friday Edition’
2021-02-12https://www.meetup.com/SQL-Friday/events/275338850/SQL FRIDAY #35 – Riccardo Zamana on ‘Redis on Cloud: red pill or blue pill?’
2021-02-19https://www.meetup.com/SQL-Friday/events/275338869/SQL FRIDAY #36 – Manish Kumar on ‘Secure your data with Azure SQL DB’
2021-02-26https://www.meetup.com/SQL-Friday/events/275338880/SQL FRIDAY #37 – Deepthi Goguri on ‘SQL Server Internals and Architecture’
2021-03-05https://www.meetup.com/SQL-Friday/events/275338894/SQL FRIDAY #38 – Ásgeir Gunnarsson on ‘Reel in the Power BI Wild West’
2021-03-12https://www.meetup.com/SQL-Friday/events/275338920/SQL FRIDAY #39 – Cédric Charlier on ‘Azure databricks: brick by brick for the data engineer’
2021-03-19https://www.meetup.com/SQL-Friday/events/275338937/SQL FRIDAY #40 – Gonzalo Bissio on ‘Azure SQL DB Serverless, a new autonomous database?’
2021-03-26https://www.meetup.com/SQL-Friday/events/275339143/SQL FRIDAY #41 – Dennes Torres on ‘Data Virtualization and Data Lake using SQL Big Data Cluster’
2021-04-02Registration link to comeSQL FRIDAY #42 – SANDEEP PAWAR on ‘Power Up Power BI with Jupyter Notebook – Use Cases’
2021-04-09SQL FRIDAY #43 – Ronen Ariely on ‘SQL Internals – Physical Table Structure under the hood, and implementation on real case scenarios’
2021-04-16SQL FRIDAY #44 – Damir Matešić on ‘Historical data with MS SQL System-Versioned (Temporal) Tables’
2021-04-23SQL FRIDAY #45 – Lou Segers on ‘🚂 Turn your slow steam locomotive into a streamlined high-speed train 🚄’
2021-04-30SQL FRIDAY #46 – Benjamin Kettner on ‘Straight from the Dojo: T-SQL string manipulations with the T-SQL Ninja’
2021-05-07SQL FRIDAY #47 – Thimantha Vidanagamage on ‘Power BI: Utilizing Large Scale Semantic Models in Service’
2021-05-14SQL FRIDAY #48 – Martin Guth on ‘Relaxed Releases with DB-Workload-Tests’
2021-05-21SQL FRIDAY #49 – Erland Sommarskog on ‘Error and Transaction Handling in SQL Server’
2021-05-28SQL FRIDAY #50 – Markus Ehrenmüller-Jensen on ‘From SQL to R – Leverage Your T-SQL Knowledge to Learn R’
2021-06-04SQL FRIDAY #51 – Mark Hayes on ‘Migrating a Data Capture solution with Event Hubs and Stream Analytics’
2021-06-11SQL FRIDAY #52 – Torsten Strauß on ‘Parallelism in Microsoft SQL Server’
2021-06-18SQL FRIDAY #53 – Jean-Pierre Voogt on ‘Data Migration to Azure SQL DB using Polybase’
2021-06-25SQL FRIDAY #54 – Manpreet Singh on ‘Let’s Develop Power Apps & Power Automate/Flows on Office 365 from scratch’

Thank you!

SQL Friday 2020 is done.

I want to thank everyone that has been involved since I started SQL Friday in the beginning of the pandemic. Huge thank you to all the speakers. Without you, SQL Friday wouldn’t have been much. Thank you to everyone that attended presentations at SQL Friday. There are hundreds of you and the SQL Friday community is growing.

Did you miss a presentation? Just head on over to the Past Sessions page. All 29 SQL Friday presentations from 2020 are there for you to watch.

You may or may not have seen that the Call for Speakers for SQL Friday 2021 was open (and then closed). I have spent the days after the last SQL Friday 2020 finalising session seletion and scheduling. And I’m happy to say that the schedule for January – June 2021 is filled with another 25 great presentations by truly awesome speakers. Check out the Schedule page or head straight over to the SQL Friday Meetup group to check out the sessions and register to attend next year’s fun! (Schedule will be updated as soon as I get confirmation from last few speakers and immediately after that I will create the Meetup events).

Again, thanks for all the Friday fun you’ll let me have in 2020 and I’m really looking forward to 2021. See you!

SQL Friday #29: Uwe Ricken on “Simplify Data Management with Partitioning”

Date:2020-12-18
Time:12:00 CEST
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL Friday #29: Uwe Ricken on “Simplify Data Management with Partitioning”

The days of small database systems are now over. Even “small” systems already provide databases with a data volume of several 100 GB. It can be a real challenge for the DBA to do the daily maintenance tasks, data backup, consistency checks, … within a reasonable time frame.

With the help of partitioning (also a feature of the Standard Edition since SQL 2016), considerable advantages can be achieved in ETL processes, maintenance and backup / recovery.

The main area of application for partitioning is the optimization of loading paths for complex DWH solutions and the maintenance of large databases (statistics, indices, backups, restores). The very strongly demo-based session shows partitioning scenarios that allow the DBA to do alternative things again and encourage ETL developers to dance with joy.

About Uwe

Uwe Ricken is working with IT systems since the 90’s. The start of experiences with Microsoft SQL Server came with the assignment for development of membership administration software for the American Chamber of Commerce in Germany. The software has been distributed to five additional European countries.

The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification.

The year 2013 finished with the first MVP award for his support to the Microsoft SQL Server community in Germany and Europe.

Twitter: @dbberater

LinkedIn: https://www.linkedin.com/in/uwericken

SQL Friday #28: Jayakumar Balasubramaniam on “Implement Security in Azure SQL with Azure Key Vault and AlwaysEncrypted”

Date:2020-12-11
Time:12:00 CEST
How to attend:Already finished
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL Friday #28: Jayakumar Balasubramaniam on “Implement Security in Azure SQL with Azure Key Vault and AlwaysEncrypted”

n this session let’s learn how always Encrypted technology allows client applications to encrypt sensitive data and never reveal the data or the encryption keys to SQL Server or Azure SQL Database.

About Jayakumar

(MCT) Microsoft Certified Trainer | (MCSD) Microsoft Certified Professional in Azure and Dot Net.

A technology evangelist working on Microsoft 365, SharePoint & Azure.

Gets my hands dirty with latest and greatest of SharePoint, Azure & front-end frameworks.

Currently working with “Hubfly – A unified digital workplace” as a Product Engineer.

Getting in to the depth of the domain & technology, with my eyes for perfection, ensures that the product releases go right every time.

Recognized as C# Corner MVP.

SQL Friday #27: Matt Gordon on “Dialogue with Your Data – Interactive AI with Cognitive Services”

Date:2020-12-04
Time:12:00 CEST
How to attend:Already finished
Accompanying material:Download at https://www.sqlatspeed.com
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL Friday #27: Matt Gordon on “Dialogue with Your Data – Interactive AI with Cognitive Services”

Customers and users increasingly demand 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, alongside other Azure services, put the power in our hands. From translating between languages for better communication to analyzing the quality of customer support communications,

Azure Cognitive Services allows data professionals to enhance a company’s ability to communicate and understand. This demo-heavy session walks through practical applications of these APIs that you can apply anywhere immediately after the session.

About Matt

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.

Matt can be found on Twitter @sqlatspeed.

SQL Friday #26: Will Velida on “Machine Learning in C#? Introduction to ML.NET”

Date:2020-11-27
Time:12:00 CEST
How to attend:Already finished
Accompanying material:https://github.com/willvelida/serverless-price-predictor
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL Friday #26: Will Velida on “Machine Learning in C#? Introduction to ML.NET”

If you’re a .NET developer, you may be forgiven for thinking that in order to build awesome machine learning applications, you’ll need to brush up on your Python skills in order to use ML libraries, or even worse, buy food for that data scientist in your team until they’ve built an ML model for you.

With the release of ML.NET, this is no longer the case!

In this session, I’ll cover what ML.NET is and how you can use it to add machine learning capabilities to your .NET applications. I’ll cover the capabilities that the API offers in terms of preparing our data and evaluating our models. I’ll also talk about the capabilities that the ML.NET Model builder and how that can simplify how we choose what type of model we want to build and I’ll also talk about how we can deploy our models into production.

So ditch that data scientist (in a nice way of course) and come and see how you can leverage your existing .NET skills to use ML.NET to build some interesting machine learning applications!

About Will

Will is a Software Engineer for ASB Bank and a Microsoft Data Platform MVP based in New Zealand. He spends most of his time using .NET and Azure, but he also enjoys hacking on projects using a variety of technologies.

Outside from work, Will loves to kayak and hike when he gets the chance.

Twitter: @willvelida
LinkedIn: https://www.linkedin.com/in/willvelida/

SQL Friday #25: Kathi Kellenberger on “Modern T-SQL”

Date:2020-11-20
Time:12:00 CEST
How to attend:Already finished
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL Friday #25: Kathi Kellenberger on “Modern T-SQL”

Once you learn how to write queries, it’s easy to fall back on the same old patterns. You need to get the job done, and using old techniques is often quicker than learning something new. Over the past decade, Microsoft has released several versions of SQL Server with T-SQL enhancements, and many of these enhancements not only let you write queries easier, the queries also run faster.

Join this session to learn how this “new” T-SQL functionality can save you time when writing queries that also perform great.

About Kathi

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP.

She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books.

Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode.

When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings.

@auntkathi on Twitter

SQL Friday #24: Ferenc Csonka on “Power BI Paginated Reports – MORE than just SSRS vNext”

Date:2020-11-13
Time:12:00 CEST
How to attend:Already finished
If you can’t attend this one but want to attend future sessions, join the Meetup group and be the first to know when registration comes online: https://www.meetup.com/SQL-Friday

SQL Friday #24: Ferenc Csonka on “Power BI Paginated Reports – MORE than just SSRS vNext”

Companies often have to produce multi-page, static reports that can be printed pixel-perfectly on paper or automatically generated regularly at a predefined time in PDF / Excel format and can be sent to the appropriate target audience. Power BI Paginated Reports based on SQL Server Reporting Services technologies can now be created using Power BI Report Builder tool and can be published to Power BI Service. In this session, we present some practical examples of Power BI Paginated Reports, focusing mostly on how to integrate Paginated Reports with our existing Power BI reports.

About Ferenc

Ph.D. in Computer Science, 20 years experience in software development, 10+ years experience in Microsoft BI stack, day-by-day usage of Power BI since its very first release, teaching lots of Power BI trainings in Hungarian and English, co-organizer of Hungarian Power BI Meetup. Last year I was a speaker at Microsoft Tech Summit 2019 conference in Budapest and also at Power Platform World Tour in Vienna. Recently, I had a presentation at Budapest Artificial Intelligence Meetup and Community Summit Europe 2020.

Twitter: https://twitter.com/ferenc_csonka
LinkedIn: https://www.linkedin.com/in/ferenccsonka
Website: https://www.fizzcode.hu/