How to Plan for Database Performance | Bryden Oliver

Are your applications running at a snail’s pace? 🐌
Have you been wracking your brain trying to identify the source of the bottleneck? 🔍
A database developer can improve the performance by more than a factor of 10 by adding the right index. SSW Solution Architect Bryden Oliver helps with all things performance!

00:00 | Intro
00:37 | Personal Bio
02:42 | SQL Server Intro
08:31 | SQL Server Query Execution
10:58 | Execution Plans
16:43 | Simple Monitoring
24:17 | Selecting Appropriate Indexes
52:50 | Summary
1:01:05 | Q and A

In this session, he’ll take you on a journey of discovery to unearth the root cause of your database performance issues. From understanding the underlying SQL queries to pinpointing the problem areas, he’ll show you the tips, tricks and techniques to get your application moving at the speed of light. Developers of all levels are welcome to join in this exciting adventure – no prior database experience needed.
So, put on your detective hats and get ready to solve the mysteries of database performance! 🕵️ 🔗

Links: Need help?: https://ssw.com.au/ssw/Consulting

🌐 Follow us:
LinkedIn: https://linkedin.com/company/ssw
Twitter: https://twitter.com/ssw_tv
Facebook: https://facebook.com/SSW.page
Instagram: https://instagram.com/ssw_tv
Tiktok: https://www.tiktok.com/@ssw_tv

👋 Get in touch:

Bryden Oliver – Solution Architect
About: https://www.ssw.com.au/people/bryden-…
https://github.com/brydeno

For more information about SSW’s consulting services, please visit https://ssw.com.au/
#database #sql #databaseperformance #data #tech #usergroup

V1 – Bahjat

About the speakers

Bryden Oliver

Bryden is a Solution Architect with over 30 years of professional experience, working with customers from small businesses to the world's largest companies. He has a wealth of knowledge from a diverse range of areas, particularly focused on databases, web services, Microsoft Azure, and SaaS solutions. Bryden has a strong understanding of how software will deliver business value.

Unleashing the Power of Microservices | William Liebenberg | User Group

Join our Azure and microservices expert William Liebenberg as he presents a game-changing approach to building microservices using Dapr and Azure Container Apps. 🤯

Discover how Dapr enhances the scalability, resiliency, and maintainability of your microservices while reducing complexity.

SSW Solution Architect William will give a hands-on demonstration of how to extend your microservices with Dapr and how to run GitHub-to-Azure deployments leaving you inspired to elevate your microservices game. 👨‍💻

Tech News #28 | Prompt Engineering, GitHub Check-ins & Microsoft Teams Sparkles

Discover the fascinating world of prompt engineering and its impact on AI development.

May the 4th Be With You | Home & Office Automation

A long time ago in a galaxy far, far away, technology has advanced to a point where even our homes and offices can be smart. With the power of automation systems from SSW, controlling our lights, climate, entertainment, and security has become as easy as pressing a button on our Control4 remotes or smartphones. Imagine walking into your home or office and the doors unlock, the lights turn on, the air conditioner adjusts to your preferred temperature, and your favorite Star Wars soundtrack plays in the background. With SSW’s smart solutions, the force will be with you, always.

Exploring the Capabilities of ChatGPT | Calum Simpson | User Group

Discover how GPT-4 can revolutionize your workflow, and increase your productivity and efficiency. This is your chance to gain insight into the future of AI and software development. Get ready to learn and explore the exciting possibilities of GPT-4! 🤘

Keep “Plug Predators” away with best desk setup hardware | Brady Stroud | SSW Rules

In today’s fast-paced work environment, it’s crucial to have an efficient and organized workspace.

The only ChatGPT cheatsheet you’ll ever need (Developer Edition) | Luke Cook | SSW Rules

As ChatGPT becomes increasingly popular, users are discovering the most effective ways to prompt the AI for different scenarios.

How and when to offer unsolicited feedback | Matt Goldman & Ulysses Maclaren | SSW Rules

With empathy and the right approach, you can provide meaningful support and help others reach their goals. Join us for tips on how to offer feedback with care, so you can empower your team to be their best selves.

The best way to handle requests from your boss | Jonty Gardner | SSW Rules

Managing deadlines can be tricky, let’s find out how to deal with unexpected changes to project priorities.