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 #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/