SSW TV | Videos for developers, by developers
SSW TV | Videos for developers, by developers
  • 1 040
  • 4 596 527
How to visualise SQL indexes? | Bryden Oliver | SSW Rules
It's hard to understand what indexes are on SQL Databases. Find out how to visualise what's happening so you can easily follow what your database queries are doing.
The reason that indexes are called indexes is because they are very similar to how indexes in books work. As such, a good way to understand what indexes might work well is to think of the rows of data in your table as the pages in a book. Then based on the information think about what would be the best index you might find at the end of the book to allow you to quickly answer the query.
🔗 Links:
Watch the full User Group: czcams.com/video/l18ltcOVN4I/video.html
Rule: www.ssw.com.au/rules/sql-real-world-indexes
Need help? www.ssw.com.au/consulting
🌐 Follow us:
LinkedIn: linkedin.com/company/ssw
Twitter: ssw_tv
Facebook: SSW.page
Instagram: ssw_tv
Tiktok: www.tiktok.com/@ssw_tv
👋 Get in touch:
Bryden Oliver - Solution Architect
About: www.ssw.com.au/people/bryden-oliver
github.com/brydeno
For more information about SSW's consulting services, please visit ssw.com.au/
#database #sql #databaseperformance #data #tech #usergroup
V1 - Bahjat
zhlédnutí: 310

Video

SysAdmin Appreciation Day ✨ Should you thank your SysAdmins? Matt Goldman
zhlédnutí 133Před 14 dny
When our tech breaks, who's there to fix it? Matt Goldman has a special message for the fixers that work tirelessly behind the scenes when the world is hit with a big Blue Screen 🖥️ Read more about SysAdmin day: sysadminday.com/ 🔗 Links: Rule: www.ssw.com.au/rules/rules-to-better-system-administrators/ Need help? www.ssw.com.au/consulting/ 🌐 Follow us: LinkedIn: linkedin.com/company/ssw/ Twitte...
SysAdmin Appreciation Day ✨ 4 easy ways to make a SysAdmin happy
zhlédnutí 162Před 14 dny
Have you ever stopped to think about where you'd be without a SysAdmin? Lets take today to focus on how we can show appreciation by making a SysAdmin's life easier. Also you should buy them something nice - a chocolate 🍫 or coffee ☕ would be a good start 🎉 Read more about SysAdmin day: sysadminday.com/ 🔗 Links: Rule: www.ssw.com.au/rules/rules-to-better-system-administrators/ Need help? www.ssw...
10 Surprising Lessons from Writing a Book | Matt Goldman | SSW User Group
zhlédnutí 108Před 21 dnem
Writing a book is no small feat, especially when it revolves around rapidly-evolving technology. In this intimate session, delve deep into the hidden intricacies, challenges, and personal revelations experienced on Matt Goldman’s journey of writing .NET MAUI in Action. 📖 00:00 | Introduction 01:31 | The unexpected path to authorship 02:21 | SSW Experience and Background 04:00 | Mobile Developme...
Exploding Intel CPUs and security breaches
zhlédnutí 1KPřed 21 dnem
Check out the latest news and tech innovations in SSW Tech News #40 00:00 | Intro 00:45 | .NET Migration Assistant 05:00 | Visual Studio Code Update 06:12 | Microsoft's Data Science Award 06:40 | Microsoft leaves OpenAI Board 08:26 | OpenSSH Vulnerability 09:04 | Anthropic's Developer Console 10:12 | Intel Chips 100% Failure 🔗 Links: Rule: www.ssw.com.au/rules/rules-to-better-net8-migrations Ne...
Backlog Refinement Meetings| Calum Simpson | Rules
zhlédnutí 212Před měsícem
🔗 Links: Rule: ssw.com.au/rules/backlog-refinement-meeting www.scrum.org/resources/product-backlog-refinement Need help? www.ssw.com.au/consulting 🌐 Follow us: LinkedIn: linkedin.com/company/ssw/ Twitter: ssw_tv Facebook: SSW.page Instagram: ssw_tv Tiktok: www.tiktok.com/@ssw_tv 👋 Get in touch: Calum Simpson - SSW Solution Architect About: www.ssw.com.au/p...
10 Surprising Lessons from Writing a Book | Matt Goldman | Join us July 17th 2024
zhlédnutí 63Před měsícem
Writing a book is no small feat, especially when it revolves around rapidly-evolving technology. In this intimate session, delve deep into the hidden intricacies, challenges, and personal revelations experienced on Matt Goldman’s journey of writing .NET MAUI in Action. 📖 Hope you can all make it, in-person or online at 6PM EST Join us on the live feed! ➡️ www.ssw.com.au/live/ 🔗 Links: .NET MAUI...
Red Point: a 3D Rock Climbing App Built with Unity & .NET MAUI | Matt Goldman & Matthew Robbins
zhlédnutí 243Před měsícem
Join us this MAUI UI July as we celebrate all things .NET MAUI. Matt Goldman from SSWTV interviews Matthew Robbins, the innovative mind behind Red Point, an app transforming rock climbing with technology. Discover how Red Point uses 3D scanning and Unity integration to turn traditional guidebooks digital, making climbing safer and more accessible. From its conception to its rapid user growth, l...
Understanding Enterprise Tier with Tina CMS | William Liebenberg
zhlédnutí 128Před měsícem
Welcome to our exploration of the Enterprise tier in Tina CMS! In this video, William walks you through the intricacies of enterprise-level content management and why it matters for large-scale organizations. From understanding the unique needs of enterprise clients to exploring custom features and robust support, this guide covers it all. 00:00 - Introduction to the Enterprise Tier 01:06 - Nee...
TinaCMS at /Serverless/DAYS ANZ 2024 in Sydney & Auckland highlights
zhlédnutí 56Před měsícem
TinaCMS at /Serverless/DAYS ANZ 2024 in Sydney & Auckland highlights
AI saves lives in Dermatology | Adam Cogan
zhlédnutí 471Před měsícem
AI saves lives in Dermatology | Adam Cogan
Kubernetes to revolutionize your app | Michael Smedley | SSW Consulting
zhlédnutí 133Před měsícem
Kubernetes to revolutionize your app | Michael Smedley | SSW Consulting
Newcastle Coders Group June | Mob Programming + AWS Project Development Kit
zhlédnutí 91Před měsícem
Newcastle Coders Group June | Mob Programming AWS Project Development Kit
From Demo Scene to Cutting-Edge Tech | Jean Thirion & Espen Sande-Larsen
zhlédnutí 78Před měsícem
From Demo Scene to Cutting-Edge Tech | Jean Thirion & Espen Sande-Larsen
/NEW Conference & Tina CMS After party
zhlédnutí 63Před měsícem
/NEW Conference & Tina CMS After party
Tech News #39 | Adam Cogan | GitHub Copilot Extensions
zhlédnutí 222Před měsícem
Tech News #39 | Adam Cogan | GitHub Copilot Extensions
Modern Websites - Why Everyone is Choosing Next.JS & the Best Headless UI Library
zhlédnutí 500Před měsícem
Modern Websites - Why Everyone is Choosing Next.JS & the Best Headless UI Library
Modern Websites - Why everyone is choosing Next.js & the best headless UI library | Jack Pettit
zhlédnutí 257Před 2 měsíci
Modern Websites - Why everyone is choosing Next.js & the best headless UI library | Jack Pettit
TinaCMS Announcement | Adam Cogan
zhlédnutí 342Před 2 měsíci
TinaCMS Announcement | Adam Cogan
Come meet TinaCMS at NDC Oslo | Adam Cogan
zhlédnutí 87Před 2 měsíci
Come meet TinaCMS at NDC Oslo | Adam Cogan
Troy Hunt: A private journey in the public eye | NDC Sydney
zhlédnutí 430Před 2 měsíci
Troy Hunt: A private journey in the public eye | NDC Sydney
Getting started with Tina CMS | Matt Wicks
zhlédnutí 545Před 2 měsíci
Getting started with Tina CMS | Matt Wicks
AI Powered Navigation for French Payroll Expert | Thomas Bidou
zhlédnutí 174Před 2 měsíci
AI Powered Navigation for French Payroll Expert | Thomas Bidou
Efficient Task Management with Microsoft Loop Tutorial | Tanya Leahy | SSW Rules
zhlédnutí 253Před 2 měsíci
Efficient Task Management with Microsoft Loop Tutorial | Tanya Leahy | SSW Rules
The importance of annual reviews for developers | Adam Cogan & Ulysses Maclaren | SSW Rules
zhlédnutí 262Před 2 měsíci
The importance of annual reviews for developers | Adam Cogan & Ulysses Maclaren | SSW Rules
Meet us at /serverless/DAYS ANZ 2024 in Sydney & Auckland | Adam Cogan
zhlédnutí 87Před 2 měsíci
Meet us at /serverless/DAYS ANZ 2024 in Sydney & Auckland | Adam Cogan
Data Deletion | Adam Cogan & Matt Wicks
zhlédnutí 167Před 3 měsíci
Data Deletion | Adam Cogan & Matt Wicks
Special SSW Announcement coming by Adam Cogan (at /NEW_24 Tech Conference in Newcastle)
zhlédnutí 149Před 3 měsíci
Special SSW Announcement coming by Adam Cogan (at /NEW_24 Tech Conference in Newcastle)
SSW FireBootCamp Journey to become a .NET developer (Story 1) | Ella Smith & Josh Berman
zhlédnutí 189Před 3 měsíci
SSW FireBootCamp Journey to become a .NET developer (Story 1) | Ella Smith & Josh Berman
Talk before emailing - are you gold or silver? | Adam Cogan & Andrew Harris | SSW Rules
zhlédnutí 241Před 3 měsíci
Talk before emailing - are you gold or silver? | Adam Cogan & Andrew Harris | SSW Rules

Komentáře

  • @ulyssesmaclaren
    @ulyssesmaclaren Před 8 dny

    Well done Byrdyen... super clear explanaton!

  • @pennywalker4976
    @pennywalker4976 Před 9 dny

    Great explanation Bryden, it was so easy to follow!

  • @aatali2001
    @aatali2001 Před 11 dny

    There are many projects where solutions may not be possible or things gone beyond repair and you just have spend time until it gets over but still blame come your way. I am facing same situation now days

  • @bradystroud
    @bradystroud Před 12 dny

    Indexes seem simpler than expected. Interested in learning the code first approach to indexing. I wonder if the concept is applicable to storing content in markdown.

  • @bahjatalaadelssw1933
    @bahjatalaadelssw1933 Před 12 dny

    Bryden is a great storyteller, it was a pleasure putting this video together.

  • @jernejkavkajkssw6662
    @jernejkavkajkssw6662 Před 12 dny

    As an EF Core developer, I must say it's never been easier to add indexes in EF Core configurations. 😊 #NoExcuse #EFCore #EFCoreLovesIndexes #WorkSmarterNotHarder

  • @similityjoe
    @similityjoe Před 12 dny

    Now I understand the power of indexing - thanks for a well-explained video Bryden :)

  • @kaiquebiancatti3794
    @kaiquebiancatti3794 Před 12 dny

    Beautiful analogy - comparing it to a book index was very easy to understand. Sometimes is important to go back to the meaning and first creation of a concept and we'll understand then and there what they are :)

  • @jimmychenssw8062
    @jimmychenssw8062 Před 12 dny

    Thank you Bryden. I believe a great index could also improve the response time when I am looking for something in the system. That could be a big help.

  • @eddiekranz
    @eddiekranz Před 12 dny

    indexes are super useful as we are normally storage rich and time poor. Good video

  • @IsaacLombard
    @IsaacLombard Před 12 dny

    Clear about what the indexes actually are 👍

  • @tanyaleahy
    @tanyaleahy Před 12 dny

    Great explanation, Bryden!

  • @ricksu7286
    @ricksu7286 Před 12 dny

    I like the analogy of a book index, it helps a lot in understanding what an index is

  • @warwickleahyssw4163
    @warwickleahyssw4163 Před 13 dny

    That was a great simple way of understanding indexes. Thanks Bryden. :)

  • @d3xou
    @d3xou Před 16 dny

    So true !

  • @bahjatalaadelssw1933
    @bahjatalaadelssw1933 Před 16 dny

    I needed to test and label ports in the patch panels in the Sydney Chapel. On the same day Kiki and Ash came up with tools to trace and label so I could save on cabling and use existing connections. And one of these days Chris S will get the tools he needs to get the Sydney TV's behaving themselves.

  • @techtransformers7464
    @techtransformers7464 Před 17 dny

    But how did we got DB context in application in clean architecture, so are we adding project reference of Infrastructure in Application ?

  • @ankyche5835
    @ankyche5835 Před 19 dny

    Thanks so much for the super-fast response and fixing the problem right away. Happy SAD!!!

  • @themichaelsmedley
    @themichaelsmedley Před 19 dny

    They are everyone's best friends when the internet google machine breaks

  • @themichaelsmedley
    @themichaelsmedley Před 19 dny

    Great sentiment Adam :-)

  • @jimzhengssw2317
    @jimzhengssw2317 Před 19 dny

    9 out of 10 times I can get instant answer from one of the SysAdmins when I scratch my head looking for help, which is such a soothing experience that I can't appreciate more

  • @gertcmarx
    @gertcmarx Před 19 dny

    Legends!

  • @gertcmarx
    @gertcmarx Před 19 dny

    Happy SAD!!! We have awesome SysAdmins indeed!

  • @stjepkofako8631
    @stjepkofako8631 Před 19 dny

    Thanks to our SysAdmins! You're doing an amazing job, and we are very appreciative of your support and hard work 🙂

  • @stjepkofako8631
    @stjepkofako8631 Před 19 dny

    Thanks to our SysAdmins! You're doing an amazing job, and we are very appreciative of your support and hard work 🙂

  • @sethdaily9051
    @sethdaily9051 Před 19 dny

    Love the gratitude 🙏🏻

  • @sethdaily9051
    @sethdaily9051 Před 19 dny

    Love the gratitude 🙏🏻

  • @jernejkavkajkssw6662
    @jernejkavkajkssw6662 Před 19 dny

    Happy SysAdmin appreciation day, you deserve a long holiday! 😊 Disclaimer: Please don't go to holidays all at once, the society would collapse without you. 😂😅

  • @dhruvmathur5315
    @dhruvmathur5315 Před 19 dny

    Just as I thought that I don't even know what SysAdmin are really doing, Matt said if you don't know that, it means they are awesome, haha love it

  • @dhruvmathur5315
    @dhruvmathur5315 Před 19 dny

    Sys Admins at SSW are awesome, and they just accomodate all our weird request with complain, go go SysAdmins!!

  • @chrisschultzssw8537
    @chrisschultzssw8537 Před 19 dny

    Thanks Adam! I do feel appreciated here at SSW (and not just today 😊)

  • @chrisschultzssw8537
    @chrisschultzssw8537 Před 19 dny

    Thanks Goldie! You're my favourite non-SysAdmin SysAdmin.

  • @bettybondoc
    @bettybondoc Před 19 dny

    Happy SAD to our awesome SysAdmins! Always cruising smoothly thanks to these behind-the-scenes heroes. ✨

  • @ManuGulatiSSW
    @ManuGulatiSSW Před 19 dny

    I love the SSW SysAdmins. Recently, Chris S helped organize Keeper for the CRM team such that any passwords that are used in our Power BI reports are easy to access. Part of this was made tricky as some passwords existed in other shared folders. We needed a way to have keep them in the existing folders while also making them available in a new Power BI folder. Chris figured out that Shortcuts in Keeper allow this. Thanks Chris!

  • @pennywalker9456
    @pennywalker9456 Před 19 dny

    Great video Matt! It really reminded me that when everything is quiet, that's a good thing! It's all ruining smoothly while the SysAdmins are busy working hard. Thank you team!! <3

  • @pennywalker9456
    @pennywalker9456 Před 19 dny

    Thank you for making our lives easier and for always helping me so quickly when I'm stuck! I appreciate you! <3

  • @eddiekranz
    @eddiekranz Před 19 dny

    Brb thanking my sysadmins

  • @eddiekranz
    @eddiekranz Před 19 dny

    Sysadmins are often overlooked as they're only noticed when something goes wrong - and when nothing is going wrong it means they're doing a great job. Happy sysadmins day, thank you sysadmins.

  • @bettybondoc
    @bettybondoc Před 19 dny

    Huh, I never thought of it that way, but you're right. If I don't see my SysAdmins often, it means everything's running smoothly in the background. Great work, team! Happy SAD! ✨

  • @CalebWilliamsSSW
    @CalebWilliamsSSW Před 19 dny

    I don't have a point of comparison because this is the first job I've had regular interactions with SysAdmins, but I think our Sysadmins do a great job of marking sure you can only access systems when you need to (to avoid accidental mistakes) and fixing things in a timely manner.

  • @kaiquebiancatti3794
    @kaiquebiancatti3794 Před 19 dny

    Thank you! If the SysAdmins are very quiet and all is working, that's definitely a good thing!

  • @kaiquebiancatti3794
    @kaiquebiancatti3794 Před 19 dny

    Thank you! This warms my heart and it's good to be appreciated, it's not an easy job but it is definitely rewarding :)

  • @arigrynberg8296
    @arigrynberg8296 Před 19 dny

    Was nice to feel secure when the world was melting last week.

  • @ulyssesmaclaren
    @ulyssesmaclaren Před 20 dny

    Lol I'm pretty sure SAD stands for SysAdmin "Appreciation" Day. Love it though... too right, our SysAdmins rock!!

  • @warwickleahyssw4163
    @warwickleahyssw4163 Před 20 dny

    Thanks Adam

  • @warwickleahyssw4163
    @warwickleahyssw4163 Před 20 dny

    Thanks Goldie

  • @ulyssesmaclaren
    @ulyssesmaclaren Před 20 dny

    Can I thank Chris but not Kiki? He knows why!!!!😂

  • @IsaacLombard
    @IsaacLombard Před 22 dny

    I remember this one from William's talk in the dotnet superpowers, nice to get a review of the tool

  • @therealhona
    @therealhona Před 22 dny

    Awesome video Matt! The book and journey is very inspirational + insightful! I love hearing the developer’s perspective

  • @megleyd
    @megleyd Před 23 dny

    this is the greatest thing i have ever discovered wow