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/

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