Most Active Speaker

Gethyn Ellis

Gethyn Ellis

SQL Server Consultant and Trainer

Wolverhampton, United Kingdom

Actions

Gethyn is a Microsoft Data Platform MVP, SQL Server consultant and trainer specialising in the Microsoft Data Platform. Gethyn runs a small consultancy practice in the UK with clients across Europe and North America. The consultancy practice specialises in SQL Server upgrades, migrations to Azure, database security, architecture of highly available data platforms and database performance. Gethyn has published two books relating to SQL Server, one on SQL Server 2014 new features, and another on the Azure IaaS offering. He is also a Microsoft Certified Trainer for a number of years and has delivered approximately 200 training courses. He maintains a data platform themed blog on his website www.gethynellis.com

Awards

Area of Expertise

  • Information & Communications Technology

Topics

  • SQL Server
  • power bi
  • Azure
  • Data Strategy

Auditing Azure SQL Database with Log Analytics- How, where and what

If you have built an Azure SQL database you will have probably seen the Auditing option in the Portal.
But what exactly does this give us ?

In this presentation we will look at Auditing in Azure SQL database.
How to correctly configure auditing.
Setting up the necessary Diagnostics
Viewing the data in Azure Analytics.
Introduction to the Kusto Query Language
Azure SQL Analytics to monitor performance (still in Preview after 4 years)
Azure SQL Security Insights
Putting it all together with Azure Workbooks

Data Leadership: Navigating Security, Governance, and Ethical Decision-Making in the Digitial Skies

In today's intricate digital airspace, leaders and technicians alike are tasked with ensuring not just the security but the ethical management of data. This session seeks to empower participants with a comprehensive understanding of data protection across various platforms, effective data governance, and the leadership skills necessary for navigating these challenges. Dive deep into OneLake, Purview, and the latest in data security, all while harnessing proactive strategies for smooth and secure data operations.

Build a Business: Use your technical skills to build your own business

Have you have wanted to run your own business? Work for yourself? Set your own agenda? Select the projects and even the clients that you work on? Then this session might be for you.

In this session, we will discuss what it takes for a person with outstanding technical skills to build a product or service around those skills to become a marketable product you can sell to clients. You can build a business.

To build a business, let's say it's as an IT Contractor or consultant. You will need excellent technical skills; however, that's probably not half the battle you will need to

> Build and describe a product or service that solves a clients problem (Product Development)

> Build a brand around you and your product/service, so people are aware that it exists (Marketing)

> Talk to clients to understand what problems they are experiencing and how your product will help solve them. (Sales)

>Produce a sales document that evidences how the services and products you supply solve clients problems (Sales)

>Manage your time and resources to ensure that you deliver maximum value to your existing clients while continuing to find new clients (Business Management)

It can be a rewarding and fun way to work if you do it right, and in this session, we'll show how you can approach starting your own IT Contracting or Training business and hopefully help you build a successful business of your own.

Top Five Disasters we've dealt with in our time as DBAs

Gethyn and David have been DBAs for far too long. Between them, they have had to deal with their fair share of interesting times

Come and hear about our top five disasters and how we managed, or not, to dig ourselves or our team out of a hole.

This will be a fun session discussing some of the strange things that have happened to us in the combined 35 years we have been doing this.

Moneyball – Build a killer Fantasy Football Team with Power BI

Moneyball – Build a killer Fantasy Football Team with Power BI - PHIT Football

Berry Wand is fed up with having a mediocre Fantasy Premier League team, making mediocre decisions and generally not in contention of winning any of the Fantasy Premier League that she enters. She does OK, but she’s always short of points when the title is being dished out.

In this talk, we will look at how Berry can use the FPL APIs, PowerShell and Power BI to build an analytical solution allowing her to identify valuable players from a crowded field. Allowing her to answer the soccer equivalent of the famous Billy Beane question, “Do they get on base?”

If you’re new to Power BI or just curious, about what I am going to talk about then this session is for you. We will talk about

- Data sources
- Loading into Power BI
- Cleaning and transforming the data
- Modelling the data
- Adding some measures
- Creating great visuals to show which players should be in our team and those that shouldn’t

Come along and have some Power BI fun.

For the avoidance of doubt, we are talking about English Premier League football/soccer.

A Step-by-Step Guide to Building a Data-Driven Culture

Berry Wand has a new job. As the Chief Data Officer for a leading police force, she is in charge of creating a data-driven corporate culture and has all the tools she needs to make it happen. But she needed to figure out where to start; she had a vision, but it was the implementation and delivery that she needed help with.

That was until she heard about a splendid conference talk focused on building a data culture and how Power BI could support that process.

Now, she had the chance to dig into the topic and learn how to make the most out of her data. She was excited to start, so she arrived at the talk with a sense of anticipation.

During the session, Berry was immersed in a world full of potential. She picked up techniques and strategies she could apply to her job and tips and tricks she could teach her team.

She learned about

> Establish leadership support
> Strategies for Overcoming resistance to change
> Identify key data stakeholders
> Build a data-driven mindset
> Implement data governance
> Invest in data infrastructure
> Provide training
> Encourage experimentation
> How Power BI can help build that data culture

The whole experience had been a revelation for her, leaving her feeling as if she had finally cracked the code of creating a data-driven culture in her organisation.

As she left the conference venue, Berry felt energised and inspired. She had the blueprint and strategy for taking her data to the next level; all she had to do was put her newfound knowledge into action. It would not be easy, but it would be worth it.

People interested in this session may have the following job titles. Please note this is not an exclusive list. Not having this job title does not preclude you from attending.

Data Analyst
IT Director
IT Manager
Finance Director
Chief Data Officer

From Zero to Hero: Accidental SQL Server DBAs Survival Guide

This conference session will provide a comprehensive survival guide for individuals who are new or accidental SQL Server Database Administrators (DBAs). The presentation will cover key concepts and best practices to effectively manage SQL Server instances and databases, including installation, configuration, security, backup and recovery, monitoring, performance tuning, and troubleshooting.
Attendees will learn practical tips and tricks for
• Managing security
• Backup and restore strategies
• Regular maintenance
Whether you are a developer, IT professional, or accidental DBA, this session will equip you with the essential knowledge and skills to confidently manage SQL Server environments and ensure optimal performance and uptime. By following the guidance provided in this survival guide, you will be able to quickly move from being a novice to a hero in SQL Server administration.

Mastering Impactful Presentations: Captivate, Inspire, Succeed

Join us as we take a deep dive into Berry Wand's incredible journey from a self-doubting DBA to a sought-after speaker at numerous tech events. Discover how Berry overcame her fear of public speaking with the help of renowned speaker and mentor, Gethyn Ellis. Learn how they crafted an impactful abstract, selected the right conference, and refined her material to perfection. Be inspired by Berry's story of determination and perseverance, and learn how you too can overcome your fears and achieve your dreams with the right guidance and support.

Goals of the session:
> Understand why the title is vital
> Writing a compelling abstract
> Dealing with nerves and stage freight

Prerequisites

To attend this session, you should be either new or inexperienced in delivering presentations and public speaking and want to improve and learn new skills. If that describes you, then this session will be for you.

SQL Konferenz 2024 Sessionize Event

September 2024 Hanau am Main, Germany

Data Saturday Croatia 2024 Sessionize Event

June 2024 Zagreb, Croatia

Data Saturday Stockholm 2024 Sessionize Event

May 2024 Solna, Sweden

SQLDay 2024 Sessionize Event

May 2024 Wrocław, Poland

SQLBits 2024 - General Sessions Sessionize Event

March 2024 Farnborough, United Kingdom

SQL Saturday Boston 2023 Sessionize Event

October 2023 Burlington, Massachusetts, United States

SQLSaturday MN 2023 Sessionize Event

September 2023

DATA:Scotland 2023 Sessionize Event

September 2023 Edinburgh, United Kingdom

Data Saturday Oslo 2023 Sessionize Event

September 2023 Oslo, Norway

Data Saturday Croatia 2023 Sessionize Event

June 2023 Zagreb, Croatia

SQL Saturday New York City 2023 Sessionize Event

May 2023 New York City, New York, United States

SQLBits 2023 - General Sessions Sessionize Event

March 2023 Newport, United Kingdom

SQLSaturday Orlando 2022 Sessionize Event

October 2022 Sanford, Florida, United States

DATA:Scotland 2022 Sessionize Event

September 2022 Glasgow, United Kingdom

DataSaturday Croatia 2022 Sessionize Event

June 2022 Zagreb, Croatia

SQLBits 2022 Sessionize Event

March 2022 London, United Kingdom

DataMinutes #2 Sessionize Event

January 2022

Power BI Fest Sessionize Event

November 2021

DataSaturdays #13 - Minnesota - Oct 16 2021 Sessionize Event

October 2021

datasaturdays.com Pordenone 2021 #0001 Sessionize Event

February 2021

Data Saturday Guatemala 2021 Sessionize Event

January 2021

Gethyn Ellis

SQL Server Consultant and Trainer

Wolverhampton, United Kingdom

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top