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.

SQL Friday #17: Jeff Moden on “The ‘Secret’ to High Performance Code – High Performance Test Data”

Date:2020-09-25
Time:12:00 CEST
How to attend:Already finished
Accompanying material:Download zip-file from here.
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

Jeff Moden on “The ‘Secret’ to High Performance Code – High Performance Test Data”

“A Developer must not guess… a Developer must KNOW!” — Sergiy Floka – circa June 2007

The only way to know for sure if the code that we’ve written or the index that we’ve built will perform and scale well is to test it against large amounts of data. On new projects in particular, such quantities of data aren’t always available. One way to build such data is with commercial and freeware data generators.

But what if we don’t have such a tool, can’t afford it, or simply aren’t allowed to install such third party tools even on our Dev servers?

This presentation explains and demonstrates how to quickly and easily build millions of rows of either assigned or constrained random test data of various datatypes. And it’s all “nasty fast” because we won’t use even a lick of RBAR.

We’ll learn what a “Pseudo Cursor” is and how to use it (you actually use them every day and might not know it). We’ll learn some basic formulas that can be expanded upon in so many different ways. We’ll learn how to generate and control the domains of large quantities of random integers and floating point numbers (the foundations of many types of test data) in a very high speed fashion and then how to convert those to other types of test data such as dates, currency amounts, alphanumeric department numbers, and even random-length simulated names.

Interestingly enough, the techniques learned can be used for other things. For example, we’ll also solve the classic problem of having several tens of thousands of rows of start and end dates and needing to generate 1 row for every date defined by the start and end dates for every row.

Last but not least, we’ll learn a bit about some awesome tricks with minimal logging to make our repeat testing/retesting go even faster including doing what everyone says is impossible… having data follow the Fill Factor as we’re inserting it into a table with a clustered index already in place so that you don’t have to do it separately after the initial data is inserted.

We’ll also see the huge amount of trouble so many have gotten themselves into when they make “Grooved” test data.

About Jeff Moden

Jeff Moden is the fellow that coined the term “RBAR”, which is pronounced as “ree-bar” (like the steel rods stuck in cement and not going anywhere fast) and stands for “Row By Agonizing Row”.

Jeff is a retired SQL Server MVP veteran of 9 years, winner of the 2011 RedGate Exceptional DBA award, has written some very high impact articles on SQLServerCentral.com, and has presented at the PASS Summit and many PASS Chapters and SQLSaturdays.

His passions are the “Black Arts” of high performance SQL code and teaching about it.