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

Date:2020-11-27
Time:12:00 CEST
How to attend:Register on Meetup: https://www.meetup.com/SQL-Friday/events/274853666
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/

SQL Friday #23: Gonzalo Bissio on “Azure Sql DB Managed instance, a different sql server?”

Date:2020-11-06
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 #23: Gonzalo Bissio on “Azure Sql DB Managed instance, a different sql server?”

On this session we are going to cover Azure sql db managed instance service. Introduction, how to Migrate, Configure settings, audits among other things.. We will be doing a quick travel inside this service!

About Gonzalo

A truly passionate about SQL Server on all of its editions (that include express as well). Also an Azure SQL DB/Azure SQL DB managed enthusiastic.

Gonzalo is a speaker of the PASS Argentina chapter since 4 years. He also I presented in different events from Peru, Guatemala or US (sqltrail event) or recently the lightup event.

Actually working as DBA specialist on E&Y in database global engineering team (formerly DBA in Accenture and JP Morgan bank).

Gonzalo shares some experiences on the blog https://sqlserverrules.wordpress.com/

SQL Friday #22: Javier Villegas on “New Features in SQL Server 2019”

Date:2020-10-30
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

Javier Villegas on “New Features in SQL Server 2019”

SQL Server 2019 is a modern data platform designed to meet the current challenges of data professionals. We will review the new functionalities related to Performance, Security and High Availability

We will work on the pillars of Performance, Security and High Availability covering topics such as Query Store, Adaptive Query Processing, Intelligent Query Processing, Accelerated Database Recovery, improvements in TempDB and many more.

About Javier

Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. Javier has more than 20 years working with SQL Server on every version from 6.5 to SQL Server 2019, Including SQL Azure Database and SQL Azure Managed Instance. His specialization is Administration, Performance Tuning and High Availability.

He is a Microsoft MVP in Data Platform.

Javier is a frequent speaker in conferences and events such as SQL Saturday , PASS Virtual Groups, 24 Hours SQL PASS , PASS Marathon, Microsoft AI+ Tour, vOpen (NetConf), GroupBy and DataPlatformGeeks.

Twitter: https://twitter.com/javier_vill

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

SQL Friday #21: Mikey Bronowski on “Multi-server agent jobs administration with happy faces and pigeons”

Date:2020-10-23
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

Mikey Bronowski on “Multi-Server Agent Jobs Administration with Happy Faces and Pigeons

This talk will be about multi-server administration using MSX and TSX servers. Built-in feature you may have seen, but was too scared to play with. Will show you how to configure multi-server environment and how to manage it with least possible resources.

What SQL Server and pigeons have in common? Not much, besides that you do not want to be a pigeon – pigeon post to be specific.
I have been a DBA pigeon in my past. Managing hundreds of SQL Servers and visiting every single SQL Agent to setup the maintenance jobs, backup jobs or any jobs that would help me to keep the servers up and running. Sometimes using SQL scripts, other times Powershell scripts to deploy or update new jobs, but it was still the same ol’ way. Flying between instances like a bird. Until, one day, I found out about MSX and TSX! And now my life is full of happy faces! I want your face to be happy too.

In this session you will learn how easy is to setup this hidden and forgotten feature of SQL Server. Will show you how quick is to make a master server and add some new target servers. If you discover an urge to go back to your shop and make a revolution – you can leave before the end – to save the world! Your world!

The pigeon says: “coo roo-c’too-coo”

About Mikey

Dad. Data enthusiast with mathematics background. Dealing with SQL Server for over 10 years. Works as a database administrator (Microsoft SQL Server) responsible for environments upgrades and migrations. Holds certificates MCP, MCSE Data Platform and. Microsoft Certified Trainer.

Not long ago Poland Data Community member then Leeds, now proud Southampton Data Platform User Group active member.

When not working or teaching learns new things or attends various data/technical conferences and meetups.

Italian calcio fan and traveller.

Twitter: @mikeybronowski

Blog: https://bronowski.it/blog

SQL Friday #20: Data Weekender organisers on “#DataWeekender #TheSQL Schedule”

Date:2020-10-16
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
Kevin Chant walks us through “the DevOps track” for #DataWeekender #TheSql – Track number 1.
Track 2, presented by Magnus Ahlkvist
Track 3, hosted and presented by Asgeir Gunnarsson
Presentation of Track 4, a video in which Magnus Ahlkvist renames the track host Mark Hayes
Damir Matesic presents the sessions on Track 5
Despite Man Flue of the year, Gethyn Ellis manages to give us an interesting overview of Track 6.

Data Weekender Organisers on #DataWeekender #TheSQL Schdule

This SQL Friday will be different to the previous ones. The Organisers of Data Weekender will come to SQL Friday and present the schedule for Data Weekender.

#DataWeekender #TheSQL happens on October 17, the day after this SQL Friday. If you’re planning to attend #DataWeekender #TheSQL, you should come to this SQL Friday, because it will make your scheduling of sessions a lot easier.

About Data Weekender

Data Wekender had its first run in May, organised in less than 30 days from opening Call for Speakers to hosting the event.

For the October edition, called #DataWekender #TheSQL, the organisers have given themselves a wee bit more time to get things sorted. Call for Speakers was open a couple weeks longer and there has been some more time to spread the word.

The organising team for Data Weekender is:

  • Asgeir Gunnarsson
  • Damir Matesic
  • Gethyn Ellis
  • Kevin Chant
  • Magnus Ahlkvist
  • Mark Hayes

SQL Friday #19: Gianluca Sartori on “Benchmarking in the Cloud”

Date:2020-10-09
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

Gianluca Sartori on “Benchmarking in the Cloud”

Lifting and shifting your application to the cloud is extremely easy, on paper. The hard truth is that the only way to know for sure how it is going to perform is to test it. Benchmarking on premises is hard enough, but benchmarking in the cloud can get really hairy because of the restrictions in PaaS environments and the lack of tooling.

Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.

About Gianluca Sartori

Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences around Europe. He is currently working as lead DBA at a famous Formula 1 team.

Twitter: https://twitter.com/spaghettidba

SQL Friday #18: Gail Shaw on “Transactions and Atomic Operations”

Date:2020-10-02
Time:12:00 CEST
How to attend:Already finished
Accompanying material:Slides
Blog post about Sequential column
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

Gail Shaw on “Transactions and Atomic Operations”

If there’s one thing that we, as SQL developers don’t do, it’s use transactions as often as we should.

Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code

In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.

  1. Understand what transactions are and what they do.
  2. Learn how to use transactions in combination with error handling to roll back changes on errors
  3. Learn how transactions affect logging and locking.

About Gail Shaw

Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully.

Gail is a Data Platform MVP, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQL Saturdays locally and internationally, SQL Bits and at the PASS Community Summit.

Gail has been responsible for extending the lifespan of many an application by performance-tuning their databases as well as providing technical guidance on all things SQL Server related.

She lives in Johannesburg, South Africa.