SQL Friday #11: Torsten Strauss on “Performance Tuning with Optimistic Concurrency (Level 300)”

Date:2020-08-14
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

Torsten Strauss on “Performance Tuning with Optimistic Concurrency (Level 300)”

The default transaction isolation level of SQL Server is set to read committed, which eliminates certain read phenomena, but can also affect concurrency and overall read performance.

SQL Server also offers two optimistic transaction isolation levels where a transaction does not acquire a lock when reading data, which reduces the probability of blocks and therefore leads to significantly better reading performance in a busy database.

In this session (level 300), you will learn how to increase the reading performance in a database simply by changing the transaction isolation level to snapshot isolation. You will also understand how SQL Server implements this function internally and what disadvantages it has.

About Torsten

Torsten Strauß (MCT, MCSE Data Platform, MCSE Data Management and Analytics) has been working with Microsoft SQL Server since the turn of the millennium.

He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as CEO of inside-sqlserver.

Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups and has been recognized as a Microsoft Data Platform MVP since July 2018.

SQL Friday #10: Tomaž Kaštrun on “Applied data analytics with Azure Databricks”

Date:2020-08-07
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

Applied data analytics with Azure Databricks

Azure Databricks is an Apache Spark–based analytics service for big data and data analytics on top. In this session we will create Databricks scenarios for useful business scenarios. Data engineers and business analysts (data scientists) can now work on RDD structured files using workbooks for collaborative projects, using ANSI SQL, R, Python or Scala, easily covering both analytical and machine learning solutions on one hand, and also giving the capabilities to use it as a data warehouse.

About Tomaž

Tomaž Kaštrun is a SQL Server developer and data scientist with more than 15 years of experience in the fields of business warehousing, development, ETL, database administration, and query tuning.

He holds over 15 years of experience in data analysis, data mining, statistical research, and machine learning.

He is a Microsoft SQL Server MVP for data platform and has been working with Microsoft SQL Server since version 2000.

He is a blogger, author of many articles, a frequent speaker at the community and Microsoft events.

He is an avid coffee drinker who is passionate about fixed gear bikes.

In 2018 he co-authored book “SQL Server 2017 Machine Learning Services with R”.

SQL Friday #9: Menaka Baskerpillai on “Modern Data Platform Azure Cosmo Db with .Net core”

Date:2020-07-31
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

Modern Data Platform Azure Cosmo Db with .Net core

This session will be about Azure Cosmo Db, which will include API’s like Graph, Table, Sql core.

Topics to be covered during the session:

  1. Let’s explore Cosmo db.
  2. API’s available in Cosmo Db’s and how to use them based on Requirements.
  3. How to create a simple .net core application using Cosmo db api.

About Menaka

I am Menaka Priyadharshini Baskar, working as an Associate software Engineer at Accenture. Former Microsoft Student Partner and Mozilla Firefox Student Ambassador.

Now currently working as a .Net Developer with Azure data platforms.

Microsoft Certified Professional in Programming C# and Azure.

I wrote about 40 articles of various technologies and also a active technical speaker .

You can find my article in the below website
https://www.csharpcorner.com/members/menaka-priyadharshini

My twitter profile
https://twitter.com/MenakaBasker

My Linkedin profile
https://www.linkedin.com/mwlite/in/menakapriyadharshini-basker-291600188

I am from India, located at Tamilnadu.

SQL Friday #8: Josef Richberg on “Building a complete API in Azure”

Date:2020-07-24
Time:12:00 CEST
How to attend:Already finished
Accompanying material:Download the presentation 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

Building a complete API in Azure

This session will take an in-depth look at using SQL Server to back a fully functional enterprise level API built in Azure. I will go over best practice designs for tables, views, stored procedures, Azure Functions (c#), Azure App Services, and finally Azure API Management.

About Josef

I have over 29 years in the world of RDBMS. I have in-depth knowledge of Microsoft SQL Server and the Azure platform (Data Factories, Logic Apps, Functions,Event Grids…) . I am fiercely passionate about my work.

I am currently developing a new Azure ecosystem for Penguin Random House. This includes moving load processes to Azure Logic Apps and Data Factory pipelines, leveraging Azure Functions, and pushing the new SQL Services to the limit.

I am the creator of the Enhanced Threading Framework (ETF) for SSIS. I presented at PASS 2013 on advanced SSIS techniques: http://www.sqlpass.org/summit/2013/Sessions/SessionDetails.aspx?sid=4845 and was awarded ‘2009 Exceptional DBA of the Year’, by RedGate and my peers.

SQL Friday #7: Ben Weissman on “Data Analysis using GitHub, Azure Data Studio and Big Data Clusters”

Date:2020-07-17
Time:12:00 CEST
How to attend:Already finished
Accompanying material:At Ben’s GitHub
More on Big Data Clusters:Pluralsight course Building Your First Microsoft SQL Server Big Data Cluster
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

Data Analysis using GitHub, Azure Data Studio and Big Data Clusters

In this Session, Ben Weissman is first going to give an overview about what Big Data Clusters are followed by a practical demonstration on how you can use it to integrate and analyze external data coming from GitHub..

About Ben

Ben has been working with SQL Server since SQL Server 6.5, mainly in the BI/Datawarehousing field.

He is a co-author of “SQL Server Big Data Clusters” and “The Biml Book”, regular blogger and speaker on national and international events.

Ben has been involved in about 150 BI Projects and is always looking for ways to become more productive and make SQL Server even more fun!

Together with his team at Solisyon, Ben provides training, implementation and consultancy for SQL/BI developers and data analysts in (upper-) mid-market companies around the globe.

SQL Friday #6: Mike Byrd on “A Self-Tuning Fill Factor Technique for SQL Server”

Date:2020-07-10
Time:12:00 CEST
How to attend:Already finished
Accompanying material:Download from GitHub
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

A Self-Tuning Fill Factor Technique for SQL Server

Have you ever created an index and wondered what to specify for your fill factor? Usually most of us never ever give it a worry and just leave it at the default value = 0 (actually this is a synonym for 100).

Recently I’ve discovered a technique that establishes a “near” optimum fill factor value for every index in a database. I say “near” because it may not always derive the perfect fill factor, but will get you close.

We will look closely at the T-SQL for this technique to see how the proof of concept was developed for a very active OLTP database. The code “tunes” on both index fragmentation and bad page splits. A decrease in overall database wait times of 30% was achieved within 60 days after the tuning was initiated. The tuning is continuous and allows for changes in data skew as well as evolving application interactions with the database.

This is a real breakthrough for making your indexes and queries perform even better. All code will be available for download.

Level: Advanced

Prerequisites: Some knowledge of index fragmentation, page splits, and T-SQL.

About Mike

Former rocket scientist and USAF Fighter Pilot — now a SQL Server geek. Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and IT Director for Texas Windstorm Insurance Association (9 years), Currently senior database consultant for several companies. Presenter at many SQL Saturdays in US, Europe, and Australia.

Specialties

SQL Server performance tuning; database (OLTP & OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

SQL Friday #5: Markus Ehrenmüller-Jensen on “Introduction to Numeric Calculations in DAX”

Date:2020-07-03
Time:12:00 CEST
How to attend:Already finished
Accompanying material:Download 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

Introduction to Numeric Calculations in DAX

DAX (Dynamic Analysis Expressions) is a formula language to enrich imported data with calculated columns, calculated tables and measures in Power BI, Excel and Analysis Services. While the syntax of the language is derived from Excel’s formula language and easy to learn, some of the functions are hiding a complex semantic.

This talk starts on a zero DAX knowledge level but will introduce advanced concepts. We will concentrate solely on numeric calculations. You will learn the difference between calculated columns and measures and between row context and filter context. We will discuss how CALCULATE operates.

Markus will gently walk you through different examples of increasing complexity which will pick your brain – don’t forget to bring your favorite hot beverage to stay focused during this 60min!

About Markus

Markus Ehrenmüller-Jensen is the founder of Savory Data and works as a project leader, trainer & consultant for data engineering, business intelligence, and data science since 1994.

He is an educated software-engineer, graduated business educator and professor for databases and project engineering at HTL Leonding (technical college) and certified as MCSE Data Platform, MCSE Business Intelligence, and MCT.

Markus speaks regularly on international conferences (eg. PASS Summit, SQLBits, SQL Saturdays, SQL Days, Power BI World Tour, …) and writes articles for well-known journals.

In 2013 he co-founded SQL PASS Austria and in 2015 Austria PUG and organizes SQL Saturdays in Austria since 2014. For his technical leadership in the community he was awarded as a Microsoft Data Platform MVP since 2017.

SQL Friday #4: Gethyn Ellis on “Top 5 Skills a DBA will need in 2020”

Date:2020-06-19
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

TOP 5 Skills a DBA will need in 2020

It’s the year 2020 about ten years ago many people were writing about the demise of the DBA and how they won’t be around in ten years time. As we move into a new decade, and those ten years have passed the DBA role is still alive and kicking. Albeit, it has evolved in the last ten years and it has changed considerably since I started my career in the early 2000s.

In this session we will look at what skills you would expect a DBA to have in 2010 and compare it to what they will need in 2020. No doubt we will be covering:

  • New versions of SQL Server
  • Automation and PowerShell
  • Containers
  • Cloud technology
  • Data Analytics
  • Maybe some non-technical skills too

About Gethyn

Gethyn is the lead consultant for gethynellis.com, which is a small IT Consulting and Training company.

We believe in putting the human back into technology. Your people will be at the heart of the solutions we provide to you.

We Specialise in the Microsoft data platform, both on-premises SQL Server and the Azure cloud.

Our team of talented consultants, associates and trainees, offer a range of services including platform upgrades and modernisation, performance tuning, and security hardening to help you and your people manage and learn about Microsoft Data Platform.

SQL Friday #3: Mark Hayes on “Rebooting your Data Strategy with the Power Platform”

Date:2020-06-12
Time:12:00 CEST
How to attend:Already finished
Accompanying material:
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

Rebooting your Data Strategy with the Data Platform

For many businesses setting up a data analysis platform can be expensive. If you have relatively small numbers of users, the costs can appear prohibitive. This is no longer the case with the Power Platform.

This session is based on real-life customer implementations where they migrated from their Excel and custom line of business based reporting solutions towards the Power Platform. We show how we started with Power BI and evolved into a comprehensive solution that combines SharePoint Online, Team and Power Automate with PowerBI to provide an end to end reporting solution.

Format – PowerPoint with plenty of demonstrations of how this system was built and how you can start approaching this type of project.

Technologies covered

  • Power BI
  • Power Automate
  • Teams
  • Sharepoint Online
  • Excel

About Mark

Mark (Certified Business Intelligence Professional (CBIP), MPP – Data Science, MPP – Big Data) is a Microsoft Data Platform consultant and has worked with Microsoft data technologies since 2000. He has worked on hundreds of projects working with the MS SQL DB Engine, Analysis Services, SSIS, SSRS, PowerBI. Tabular, Flow and more. He is a regular speaker on Microsoft Data Platform topics and co-leader of the Cork SQL User Group, Cork PowerBI User Group, the Cork SQL Saturday and Data Céilí 2020.

SQL Friday #2: Kevin Chant and Sander Stad on “Azure Devops duet”

Date2020-06-05
Time12:00 CEST
How to attendAlready finished
Accompanying materialOn Sander’s github page
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

Azure Devops duet

Welcome to Azure DevOps Duet, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for SQL Server related deployments.

Kevin Chant

Senior 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://www.kevinrchant.com/

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://www.sqlstad.nl/