SQL FRIDAY #34 – Kevin Chant and Sander Stad on ‘Github Devops Duet – SQL Friday Edition’

Date:2021-02-05
Time:12:00 Central European Time (11:00AM UTC)
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 #34 – Kevin Chant and Sander Stad on ‘Github Devops Duet – SQL Friday Edition’

Welcome to GitHub DevOps Duet, a scenario where two teams (dev and ops) are going to start using GitHub Actions for Data Platform deployments.

They need to figure out how to implement their processes within GitHub and make it work for all parties.

We will discuss:

  • the challenges of implementing DevOps
  • setting up a database solution project
  • testing your database releases using tSQLt
  • setting up your GitHub Actions workflows
  • deploy database artifacts to multiple Data Platform solutions

As part of the session we will cover the GitHub services you get including:

  • Actions
  • Projects
  • Security

The session will cover how to setup projects for your tasks, set up workflows in Github Actions, security and so much more.

If you want to find out more about how Github can be implemented for your DevOps process than come to our session

About Kevin Chant

Senior Database Architect originally from the UK and now living in the Netherlands.

Many years experience in the IT sector, and has supported databases for companies in the top 10 of the fortune 500 list.

In addition to a lot of SQL Server experience also has a fair few Microsoft Certifications, and was probably the last ever person in the world to gain the MCSD Azure Architect certification.

Real life experience with SQL Server and Azure Devops. Currently SQL Server product Owner of around 1,900 instances. In addition, done various things for the Data Platform Community. With the last being one of the organizers of the online DataWeekender conference.

https://twitter.com/kevchant
https://linkedin.com/in/kevin-chant
https://kevinrchant.com

About Sander Stad

Sander is a SQL Server DBA with over 15 years of experience in IT. He has worked with SQL Server since version 2000 and is a Cloud and Datacenter Management (CDM) MVP.
He is a huge PowerShell enthusiast and will try to automate processes as much as he can.

https://twitter.com/SQLStad
https://linkedin.com/in/sanderstad
https://www.sqlstad.nl

SQL FRIDAY #33 – Geovanny Hernandez on ‘First Steps to Go Ahead with Sql Server on Linux’

Date:2021-01-29
Time:12:00 Central European Time (11:00AM UTC)
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 #33 – Geovanny Hernandez on ‘First Steps to Go Ahead with SQL Server on Linux’

The Every beginning is difficult, but adopting the right strategy can mark the difference. In this session, I am going to share some of the most valuable lessons learned in my journey through the use of Linux as a platform together with MS SQL Server.

In this session, I will be explaining some fundamentals about Linux and subjects ranging from permissions to basic bash shell scripting and how we can use to maximize some routines and tasks on MS SQL Server, including the installation and configuration and practical examples and good practices for own mental health.

About Geovanny Hernandez

Geovanny Hernandez is a Senior Database Engineer and Microsoft Certified Trainer (MCT) and MCSE with more than fourteen years of experience in software development, passionate for performance tuning in MS SQL Server, Unit Testing, Python and Databases technologies.

In addition, Geovanny collaborates with MS SQL Server community as a speaker on different sessions for PASS Malaga (Spain chapter) and virtual events for students and professionals in Universities from Nicaragua (Central America) and international events as SQLBits and SQLSaturdays.

https://www.linkedin.com/in/geovannyhernandez/
https://twitter.com/datawithgeo
https://geohernandez.net/

SQL FRIDAY #32 – Bob Duffy on ‘Financial Modelling with Power BI’

Date:2021-01-22
Time:12:00 Central European Time (11:00AM UTC)
Accompanying material:https://prodata.ie/2020/10/02/financial-modelling-in-powerbi-downloads/
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 #32 – Bob Duffy on ‘Financial Modelling with Power BI’

Bob has been involved in taking Financial Models from paper based to highly dynamic analytics models in Microsoft BI for many large enterprises in Ireland.

Building Successful Financial Models based of a Chart of Accounts and General Ledger can be difficult for a number of reasons:
– Dynamic/Growing Chart of Accounts
– Many to Many Structure
– Parent Child
– Ragged Hierarchies on financial reports
– Unary Operators such as running sums
– Entity Attribute Value structures
– Forecasting and Budgeting
– Overhead Allocation
– Modelling Profit Variations like EDBITA

Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.

About Bob Duffy

Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM and now Analysis Services “Maestro” certified.

Bob used to work for Microsoft Consulting Services a Senior Consult and subject matter expert for BI/data. He now works at the Prodata SQL Centre off Excellence in Dublin, Ireland where he helps enterprise customers with cloud architecture, design, performance tuning, benchmarking and pretty much anything to do with SQL Server or Business Intelligence.

https://twitter.com/bob_duffy
https://www.linkedin.com/in/duffybob
http://blogs.prodata.ie/

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

Date:2021-01-15
Time:12:00 Central European Time (11:00AM UTC)
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 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/