Top Techniques for Database Performance | Bryden Oliver

Discover the secrets to unlocking lightning-fast database performance! In this engaging presentation, Bryden will guide you through a range of tried-and-true techniques that will revolutionize the way you approach database optimization.

00:00 | 00- Intro
04:16 | 01- Reduce Table Size
10:55 | 02- Use SELECT fields FROM
14:36 | 03- Create Indexes
17:16 | 04- Verfy Indexes
21:14 | 05- Avoid Implicit Conversions
23:42 | 06- Avoid Looping
26:50 | 07- Use AND instead of OR
30:00 | 08- Minimize Large Writes
32:29 | 09- Avoid Wildcards LIKE ‘%fred”
36:04 | 10- Create Joins with Inner Joins
38:20 | 11- Use Exist() instead of count()
40:51 | 12- Avoid SELECT DISTINCT
42:48 | 13- Avoid too many joins
44:48 | 14- Use TOP for sampling
46:51 | 15- Use WHERE instead of HAVING
49:16 | Summary
56:06 | Q and A

With plenty of live demos along the way, you’ll gain a deep understanding of each technique and learn how to apply them to your own databases. From the simplest tips to more advanced techniques, this session has something for everyone.

Get ready to take your database performance to the next level! This session is aimed at making databases more accessible to developers. Aimed squarely at SQL Server, it contains lots of little tips and tricks along the way to help quickly and easily identify problem queries.

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

Follow us:
LinkedIn:   / ssw
Twitter:   / ssw_tv
Facebook:   / ssw.page
Instagram:   / ssw_tv
Tiktok:   / ssw_tv

Get in touch:
Bryden Oliver – SSW Solution Architect
About: https://www.ssw.com.au/people/bryden-oliver
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.

Microsoft Teams Etiquette: Simple Habits That Make Meetings Better | Adam Cogan

Whether you’re working remotely or in the office, small habits can make a huge difference in Microsoft Teams meetings. In this video, Adam Cogan shares practical etiquette tips to help meetings run more smoothly—from introducing people who join the room, to announcing yourself when joining a call, using screen sharing respectfully, and ending meetings with a recorded summary that can automatically create a Product Backlog Item (PBI).

These simple communication habits improve collaboration, reduce confusion, and make hybrid meetings more inclusive and productive.

Treat Your Code Like Uranium | Adam Cogan

Adam Cogan shares a striking story comparing two World War II factories—one ordinary, one handling uranium—and the surprising lesson that the uranium workers lived longer because they followed disciplined, risk-aware practices. He connects that idea to software teams: the best outcomes come from careful habits like automated tests, telemetry, pull requests, retrospectives, shared rules, and good tools. The message is simple: treat software delivery with the same respect as dangerous work, and you’ll reduce stress, avoid chaos, and get better results.

3 Tips for Better Video Recordings | Adam Cogan

Great coaching can dramatically improve how you present, communicate, and learn. In this video, Adam Cogan shares 3 practical coaching tips that SSW uses every day—from onboarding and role plays to improving video delivery. He explains why having a coach matters, why immediate interruption beats delayed feedback, and how repeating corrections helps lock in better habits.

TinaCMS + Fumadocs: Bring Visual Editing to Your Docs | Hark Singh

Discover how to connect Playwright with AI agents and unlock powerful workflows.

Stop Using 👍 Wrong in Teams | Adam Cogan

A quick communication tip from Adam Cogan: don’t use 👍 as a catch-all response when someone assigns you a task in Teams, Slack, or Google Chat. In the example Adam gives, if a task will take about five minutes, a thumbs up is too ambiguous because it does not clearly say whether you’ve read it, agree with it, are doing it now, or will do it later. Instead, use 👍 for agreement, 👀 to show you’ve seen the task and are actively working on it, and then replace 👀 with ✅ once the task is done. It is a small change, but it removes ambiguity and cuts down unnecessary follow-up messages.

How to record a done video in SSW | Sylvia Huang | SSW Rules

Sylvia Huang from SSW shares her SSW Cultural Exchange experience from Hangzhou, China to Australia

4 Essential Sales Tips for Engineers | Adam Cogan

Not a salesman? No problem. Adam Cogan shares 4 practical tips to help engineers navigate sales meetings with confidence. Learn how to stop “selling” and start solving, how to talk numbers without the awkwardness, and why being transparent about your process wins more clients.

Do you explain why you’ve deleted or updated an appointment? | Adam Cogan | SSW Rules

Ever wonder why a meeting was moved or cancelled? Adam Cogan explains the “Secret Ingredient” to professional scheduling: always include a version history and reason for change at the top of your appointments. Improve clarity, keep a record of changes, and hold participants accountable with this simple SSW Rule.

Chat first before changing others’ code | Adam Cogan

Changing someone else’s code? Don’t just dive in! Adam explains why it’s important to check the source history and talk to the original developer before making changes. A quick chat can save headaches and keep everyone on the same page. Perfect advice for devs working in teams!