SQLBits
SQLBits
  • Видео 1 030
  • Просмотров 965 860
Maximizing Database Performance With Isolation Levels
How does a database handle multiple processes all trying to read and write at the same time? The answer is transaction isolation levels, and Azure SQL Database and SQL Server offer several to choose from depending on your workload's needs. Attend this session to understand how they work, why they matter, and how proper concurrency settings can result in great performance improvements!
Speaker: Bob Pusateri SQLBits.com/speakers/Bob_PusateriSpeaker Blog: bobpusateri.com/
Speaker BIO: Bob Pusateri is a Microsoft Certified Master and Microsoft Data Platform MVP who has been working with SQL Server for over 15 years. His interests involve performance tuning, Very Large Databases, and cloud archi...
Просмотров: 600

Видео

SQLBits 2024 Build
Просмотров 147Месяц назад
The build of SQLBits is always an impressive sight - enjoy the timelapse of the build of SQLBits 2024 at Farnborough International where we sported an Aviation theme!
Why Come to SQL Bits?
Просмотров 132Месяц назад
Wondering if SQLBits is for you? Let our 2024 delegates, speakers and sponsors tell you more about why you should attend the no 1 data platform conference in the industry.
This Was SQLBits 2024
Просмотров 1,1 тыс.Месяц назад
Step into the 2024 running of the world's best data platform conference, at Farnborough International Conference Centre. 200 world class speakers, unparallelled networking opportunities, insight, innovation and inspiration; this was SQLBits 2024. Music - “Chasing Sun” licensed via Music Vine: CWIKNYE74UGOXJAW
One dataset and three use cases with Microsoft Fabric
Просмотров 388Месяц назад
Are you curious about how to leverage Open Data with Fabric? In this demo filled session, I will show you how I import World Bank Open Data into Fabric using different methods: Pipelines, Data factory Gen-II, Notebooks and a mix of all three. Then I will demonstrate how I do modelling using Warehouse, Power BI Dataset model and Notebooks. Finally, I will create stunning reports using Power BI. ...
The Fundamentals of DAX Contexts
Просмотров 308Месяц назад
Explore the heart of DAX with this unique session, as I take you on an African Safari-themed adventure, where stunning wildlife photography serves as the backdrop for understanding the intricacies of DAX contexts. We'll encounter row and filter contexts, just like wild creatures in their natural habitat. Through captivating visuals, you'll uncover how these contexts shape DAX calculations and m...
Streamlining Power BI with PowerShell
Просмотров 280Месяц назад
Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone. This session explores how PowerShell automation simplifies and streamlines these tasks. Speaker: Linda Torrång SQLBits.com/speakers/Linda_Torr_ng Speaker: Sander Stad SQLBits.com/speakers/Sander_StadSpeaker Blog: sqlstad.nl SQLBits.com/Sessions/Streamlining...
How to get started with MLOps in Azure Databricks
Просмотров 300Месяц назад
This entry-level session will introduce you to the machine learning life cycle, including data preparation, model training, selection, and how to operationalize your model with Databricks Machine Learning, and gain a deeper understanding of how to scale deployments using MLOps across your company. Speaker: Doug Leal SQLBits.com/speakers/Doug_Leal SQLBits.com/Sessions/How_to_get_started_with_MLO...
Data Modelling Showdown: Unravelling the Mysteries of Different Data Modelling Approaches
Просмотров 357Месяц назад
In the realm of data management and analytics, choosing the right data modelling approach can be a daunting challenge. Some have a preferred path, while others are navigating uncharted territory. "Data Modelling Showdown: Unravelling the Mysteries of Different Data Modelling Approaches" is your ticket to exploring this diverse landscape. Join us as we embark on an adventure through various meth...
What to look out for when migrating your data to the cloud; is it REALLY the right choice?
Просмотров 204Месяц назад
Do you want to migrate your data in the cloud? Are you sure? I'll make you think about what to consider for a successful move Speaker: Emanuele Meazzo SQLBits.com/speakers/Emanuele_MeazzoSpeaker Blog: tsql.tech/ SQLBits.com/Sessions/What_to_look_out_for_when_migrating_your_data_to_the_cloud_is_it_REALLY_the_right_choice Tags:
Generative AI: Concepts, Tools, and Applications for Data Professionals
Просмотров 162Месяц назад
In this session, you will learn how generative AI works, its limitations, the main tools and processes you can use, and where you can use it to enhance your data estate and data projects. Speaker: Buck Woody SQLBits.com/speakers/Buck_Woody2Speaker Blog: buckwoody.wordpress.com/ SQLBits.com/Sessions/Generative_AI_Concepts_Tools_and_Applications_for_Data_Professionals Tags:
Data Quality Revolution : The Fabric-OpenAI Approach
Просмотров 453Месяц назад
In this session, we'll walk you through practical techniques for handling various data issues, such as formatting problems, conversion, and more. Whether you're a seasoned data professional or just starting your data journey, this session will equip you with the skills and knowledge needed to turn chaotic datasets into valuable insights. Don't miss this opportunity to master the art of data cle...
Exploratory vs explanatory, when do you build which dashboard and how?
Просмотров 92Месяц назад
When designing a dashboard, you need to make many choices. One of the first questions you should ask yourself is whether it will be an exploratory or explanatory dashboard. Both variants have their benefits, but the design ultimately depends on your choice. In this interactive session, we will delve into the difference between an exploratory and explanatory dashboard and how to set them up effe...
Let me show you why data types still matter
Просмотров 135Месяц назад
Selecting the right data types is still important. Let's see some examples of why! Speaker: Cláudio Silva SQLBits.com/speakers/Claudio_SilvaSpeaker Blog: claudioessilva.eu Speaker BIO: SQL Server DBA and PowerShell lover to automate any process that needs to be done more than a couple of times. SQLBits.com/Sessions/Let_me_show_you_why_data_types_still_matter Tags:
How To Actually Make Decisions When Architecting a Data Platform
Просмотров 208Месяц назад
Are you drowning in a sea of architectural options for your new data platform? Are there people in your organisation with strong opinions on which tools should be used, and for what? Are you unsure how to prove/evidence your gut feeling as to how things should be built? Well - this session's for you! If you're in charge of architecting a new data platform, it can be difficult to make concrete d...
DAX Visual Calculations: What You Need to Know
Просмотров 119Месяц назад
DAX Visual Calculations: What You Need to Know
Here’s the execution plan … now what?
Просмотров 160Месяц назад
Here’s the execution plan … now what?
DevOps Discovery: Navigating the Database Landscape
Просмотров 32Месяц назад
DevOps Discovery: Navigating the Database Landscape
Find your PII reports and make your data safer
Просмотров 56Месяц назад
Find your PII reports and make your data safer
Your Performance Tuning Check List
Просмотров 374Месяц назад
Your Performance Tuning Check List
Harnessing Data Science and AI in Fabric
Просмотров 70Месяц назад
Harnessing Data Science and AI in Fabric
Building AI ready applications
Просмотров 31Месяц назад
Building AI ready applications
What's new in Power Query in Power BI, Fabric and Excel?
Просмотров 616Месяц назад
What's new in Power Query in Power BI, Fabric and Excel?
Fly at Mach-speed with Azure SQL Managed Instance
Просмотров 35Месяц назад
Fly at Mach-speed with Azure SQL Managed Instance
Empowering Women in Data: Navigating Challenges, Seizing Opportunities
Просмотров 58Месяц назад
Empowering Women in Data: Navigating Challenges, Seizing Opportunities
Defending the Cloud: Securing Your Microsoft Data Workloads
Просмотров 24Месяц назад
Defending the Cloud: Securing Your Microsoft Data Workloads
Accelerate your Oracle & Mainframe Modernization journey to Azure SQL
Просмотров 36Месяц назад
Accelerate your Oracle & Mainframe Modernization journey to Azure SQL
Automating Power BI Governance: How dynamic security groups can solve 95% of your sharing needs
Просмотров 163Месяц назад
Automating Power BI Governance: How dynamic security groups can solve 95% of your sharing needs
How I Deal with Depression
Просмотров 620Месяц назад
How I Deal with Depression
Data Testing with HEDDA.IO
Просмотров 66Месяц назад
Data Testing with HEDDA.IO

Комментарии

  • @SAURABHKUMAR-uk5gg
    @SAURABHKUMAR-uk5gg 2 дня назад

    @30:03, if you're defining the schema while creating the table, then why again selecting map(inferschema = True) ?

  • @Thinker1511
    @Thinker1511 2 дня назад

    Ouch - the end is missing! no solution is provided :(

  • @SharatKrish
    @SharatKrish 4 дня назад

    Thanks for the walkthrough!

  • @Viral_Meme3499
    @Viral_Meme3499 7 дней назад

    Well explained ❤

  • @komismo
    @komismo 8 дней назад

    My god you just save my ass. TY for this.

  • @MultiGogo78
    @MultiGogo78 9 дней назад

    This was great Isi! I am going to feature it in my Linkedin Group that empowers neurodivergent women and non-binary folks in leadership positions.

  • @ishankhobare22
    @ishankhobare22 10 дней назад

    Cheers Lisa! Thank you

  • @jasonsting
    @jasonsting 11 дней назад

    Nice overview.

  • @andrzejbilek56
    @andrzejbilek56 13 дней назад

    Is there a chance to download a PowerPoint presentation? I'm curious about the omitted part about the new Query Editor features.

  • @supriyasharma9517
    @supriyasharma9517 14 дней назад

    can you please provide code for this?

  • @carloscantu75
    @carloscantu75 14 дней назад

    FYI, the audio is still not working.

  • @playmysongjo
    @playmysongjo 15 дней назад

    Hi Robert, Thank you for this well explained demo. I have one question - you mention that you set up a dataflow and on top of that a datasource. Finally you create the report. Why do you have both a dataflow and a datasource? Thank you!

  • @supriyasharma9517
    @supriyasharma9517 16 дней назад

    Great video and easy explanation. I hope you come up with a series on step by step on Databricks for beginners like me who are finding to difficult / struggling to make the switch. Thanks for your efforts

  • @pabeader1941
    @pabeader1941 16 дней назад

    Is this available somewhere? I would pay a few dollars for the base zip file.

  • @oleksandrbielov4680
    @oleksandrbielov4680 17 дней назад

    Finished watching on the 3rd minute. Showing an analog car dashboard at a presentation in 2024 is terrible.

  • @simple-security
    @simple-security 17 дней назад

    I’d like to see a demo of what you can do with Labels for sql and blob storage please and thanks. And i don’t see any labeling capability for blobs outside of Purview so i assume labeling must be done in purview. Maybe add some labeling support to the Purview data explorer?

  • @Ali-ds5iy
    @Ali-ds5iy 18 дней назад

    can you share the code here pls?

  • @carloscantu75
    @carloscantu75 18 дней назад

    Thanks for sharing!

  • @Milton-wn3rf
    @Milton-wn3rf 19 дней назад

    22:19 The right type of music for me is sad music, I noticed that I actually get things done in the house when I'm sad

    • @Milton-wn3rf
      @Milton-wn3rf 19 дней назад

      idk why maybe because I unconsciously distract myself from negative thoughts when I'm doing chores but purposely listen to sad music in order to have negative thoughts. I dunno it's weird

  • @carloscantu75
    @carloscantu75 19 дней назад

    Great presentation about a topic that is normally overlooked, thanks for sharing!

  • @carloscantu75
    @carloscantu75 19 дней назад

    Fascinating, thanks for sharing your experience!

  • @Nathan-nj6kt
    @Nathan-nj6kt 20 дней назад

    The issue isnt the policy, it's how you go about the said policy. Tinubu way of removing subsidy wasnt well planned

  • @denxx6126
    @denxx6126 20 дней назад

    Amazing stuff... thx Bob!!

  • @DavidGallardo-z4s
    @DavidGallardo-z4s 21 день назад

    Educational and Hilarious!! Thank you so much for the knowledge

  • @a.useronly2266
    @a.useronly2266 22 дня назад

    Indeed this is brief session about dbatools, one question? How we can bulk attach mdf , ldf to new server with different file path

  • @BloggingThis
    @BloggingThis 23 дня назад

    Well done Erin - thank you.

  • @bmoore813
    @bmoore813 25 дней назад

    So use splink 😂

  • @superfreiheit1
    @superfreiheit1 26 дней назад

    I think it is better to develop models in VS code and then export to Sql server

  • @carloscantu75
    @carloscantu75 26 дней назад

    Thanks for sharing, looking forward to implementing this idea.

  • @user-mf2nb3fi6c
    @user-mf2nb3fi6c 28 дней назад

    Would you kindly give the Powershell scripts' git link?

  • @deadly1604
    @deadly1604 28 дней назад

    that's actually insightful....i have tested this product and it's working faster than i thought....really cool

  • @joaoluismartins
    @joaoluismartins 28 дней назад

    hey everyone! nice video, loved the tips on how to optimize DAX Fusion. However, I didn't understand what is the problem when using calculation groups and why fusion doesn't kick in. Anyone has understood it?

    • @ralliartur
      @ralliartur 28 дней назад

      Sadly there is no code shown to compare, so we can only speculate on the reasons why it was not kicking in.

  • @paulopraca6197
    @paulopraca6197 Месяц назад

    Thanks, very useful.

  • @atulpathare2775
    @atulpathare2775 Месяц назад

    Very well explained, I wonder why this video is under rated, this is one of the best video I've found on the internet regarding ARC SQL Mi and Arc SQL severs.

  • @geehaf
    @geehaf Месяц назад

    Great session Bob - it's full of top tips and ideas. Thank you.

  • @jayanagaraj1687
    @jayanagaraj1687 Месяц назад

    🎉🎉🎉🎉❤❤

  • @freetrainingvideos
    @freetrainingvideos Месяц назад

    Very well explained, Thanks

  • @simple-security
    @simple-security Месяц назад

    Curious how much of this can now be done with Copilot for Security.

  • @feliciozo
    @feliciozo Месяц назад

    This video aged like wine 🤣

  • @anthonycouzens8356
    @anthonycouzens8356 Месяц назад

    Incredibly useful to help with my journey into composite models. Loved the section about manager aggregates and the emphasis on what's available within pro licensing. Thanks Alex!

  • @InmarciaconilTagliamento
    @InmarciaconilTagliamento Месяц назад

    A video that I strongly suggest to enyone working with powerbi and espetially data flows. THANKS

  • @zumado
    @zumado Месяц назад

    Dunno why Microsoft always creates new terminology pointing to the same thing we used to use. It confused people and increase learning curve.

  • @shaiknazeeruddin8182
    @shaiknazeeruddin8182 Месяц назад

    how to convert ssis package to databricks notebook

  • @jeffmoden4332
    @jeffmoden4332 Месяц назад

    Interesting. We suffered a huge and devastating slowdown when we migrated from 2016 EE to 2022 EE. Even changing back to the 2016 compatibility level still has us running much slower than before. I've also done some separate testing on a different machine that has 2017 and 2022 installed. Even for pure CPU code, 2022 runs 15 to 30% slower. And, yeah... I make sure the configuration settings were both the same, etc.

  • @John-qo7ks
    @John-qo7ks Месяц назад

    Great presentation, thank you for sharing. It's good to hear this from someone I trust :)

  • @bombay_8368
    @bombay_8368 Месяц назад

    This was definitely helpful for my DP-900 exam

  • @mudassir192
    @mudassir192 Месяц назад

    Thanks Ola!

  • @mudassir192
    @mudassir192 Месяц назад

    I greatly appreciate Joe Sack and Bob Ward. Thanks to both ! I wish Kimberly Tripp was still doing this stuff though!

  • @solar_tea
    @solar_tea Месяц назад

    Thanks!

  • @leppyr64
    @leppyr64 Месяц назад

    That's a really unfortunate ending.