SQL Friday #16: Eitan Blumin on “How to HADR Your SQL Jobs”

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

Eitan Blumin on “How to HADR Your SQL Jobs”

You have a couple or more SQL Servers with some sort of High Availability solution between them (AlwaysOn Availability Groups, Database Mirroring, etc.). You also have a bunch of scheduled jobs which you need to be run on the Primary server.

But wait…. How would you make these jobs run only on the Primary server? After all, if they try to run on the Secondary, they might fail (whether because the database is inaccessible or because it’s read-only). Additionally, you would need to consider a failover where the Primary and Secondary servers would switch roles.

This means that you would have to create these jobs on both servers, and then implement some sort of mechanism that would detect, for each job, whether the instance it’s being executed at is currently the Primary.

There are a few ways to go about doing this. During this session we will cover possible solutions, downfalls, tricks, and much more.

About Eitan

Eitan Blumin is a SQL Server Generalist consultant with decades of experience in all fields relating to Microsoft SQL Server databases (since the year 2005).

Eitan is currently working as a Senior SQL Server Consultant and Team Leader at Madeira Data Solutions. Other than his day-to-day consultant work, he also co-hosts the popular “SQL Server Radio” podcast with Guy Glantser, writes professional materials for the SQL Server community, delivers professional presentations and courses, and serves as a pivotal source of expert knowledge for the Madeira team.

Twitter: https://twitter.com/EitanBlumin
LinkedIn: https://www.linkedin.com/in/eitanblumin

SQL Friday #15: Nikola Ilic on “Magnificent 7 – Simple tricks to boost your Power BI Development”

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

Nikola Ilic on “Magnificent 7 – Simple tricks to boost your Power BI Development”

Simple tricks are almost always the most effective. Impress your Power BI report users with some cool visualizations, using these 7 neat techniques: from taking buttons to the next level, through creating animated tooltips, turning traditional into “custom-like” visuals, or using basic DAX calculations to enhance regular Power BI experience, this session full of demos will walk you through solutions to different use-case scenarios which can be applied in your day-to-day Power BI development.

About Nikola

Nikola is a Data Geek, interested in everything related to data, and always eager to extract valuable information from the raw data. He has multiple years of experience working with (predominantly) Microsoft Data Platform – SQL Server, SSAS Multidimensional, SSRS, SSIS, and most recently Power BI – which he is a big fan of.

He is a self-proclaimed Data Mozart: Data…well, because of everything specified above…and Mozart…because he lives in the wonderful city of Salzburg, which is famously known as a birthplace of one of the all-time greatest composers (and artists). That’s why his motto is: Make music from your data!

Nikola is also an MCSA Data Analyst and true football (and Barca) fan. He is regularly blogging at https://data-mozart.com and is quite active on LinkedIn and Twitter.

SQL Friday #14: Neil Hambly on “Azure Notebooks – Data Science Fundamentals”

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

Neil Hambly on “Azure Notebooks – Data Science Fundamentals”

Azure Notebooks is a hosted service for Jupyter Notebooks. Getting started quickly on prototyping, data science or learning Python or R using Azure Notebooks.

About Neil

Neil Hambly is an MCT, Consultant & founder @ Beacon Intelligence a Microsoft Partner Data & Analytics Consulting company, previously roles at Northdoor PLC, ABN AMRO, Accenture, ASOS, BBC, Confio Software.

Neil has 20+ years in a variety of SQL Server roles

Presented at 400+ events, at numerous usergroup and PASS events, PASS Summits & SQL Saturdays & many UK events (SQLBits, SQLRelay), Leader of PASS Data Platform London (UK), SQL Cruise Technical Lead who likes Guinness, Loves whisky and dancing.

SQL Friday #13: Guy Glantser on “The Most Important Performance Factor in SQL Server”

Date:2020-08-28
Time:12:00 CEST
How to attend:Already finished
Accompanying material:https://www.madeiradata.com/post/the-most-important-performance-factor-in-sql-server-1
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

Guy Glantser on “The Most Important Performance Factor in SQL Server”

The most important factor in SQL Server that affects query performance is statistics. When you execute a query, the optimizer needs to come up with the best possible execution plan for it, and it needs good and accurate statistics for that. Without them, the optimizer is blind, and your query performance will suffer.

In this session, we will get to know statistics, as well as the cardinality estimator – the SQL Server component that is responsible for estimating row counts based on statistics. We will cover all types of statistics, such as column vs. index statistics, single-column vs. multi-column, filtered statistics, incremental statistics, and more. We will look at scan vs. seek operations, and we will examine how execution plans are made.

If you care about SQL Server performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.

About Guy

Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS local group and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for more than 20 years, performing various database roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.

Guy on Twitter
Guy on LinkedIn

SQL Friday #12: Alex Yates on “Zero Downtime Database Deployments”

Date:2020-08-21
Time:12:00 CEST
How to attend:Already finished
Accompanying material:https://github.com/Alex-Yates/ZeroDowntime
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

Alex Yates on “Zero Downtime Database Deployments”

You understand that big bang deployments are painful, but each deploy may disrupt users, so you are restricted to tight deployment windows for your database. The consequences of missing your windows aren’t worth thinking about – but it gets more difficult each time.

In order to move to smaller, more frequent and more reliable deployments you need to demonstrate that you can safely deploy during business hours – without disrupting users.

In this session we’ll discuss the most popular strategies: Blue/Green and Canary deploys, Cluster Immune Systems and Feature Toggles. Then we’ll discuss the fundamental changes that we need to make to the way we think about database “deployments” and “releases” in order to support these strategies.

We will finish with an SSDT, Azure DevOps and Azure SQL Database demo that simulates the Facebook Chat case study from The DevOps Handbook. The principles will be applicable to any relational database deployment, regardless of tooling.

About Alex

Alex Yates has been helping organisations to apply DevOps principles to their data since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins.

A keen community member, he co-organises Data Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.

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.