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

Featured

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

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.