Guy Glantser @guy_glantser
I'm the founder and CEO of Madeira, a company that provides data solutions. I am a Data Platform MVP and the leader of the Israeli Data Platform Meetup. madeiradata.com Israel Joined May 2010-
Tweets1K
-
Followers774
-
Following373
-
Likes847
#SQLServerRadio Episode 158 (English Edition) - Reverse Engineering Table Relations based on SQL Plans: buff.ly/4aa2kwN
The "Power (Up) BI" event was held in September 2023. In one of the excellent talks, Rita Fainshtein presented some of the most frequently asked questions in the #PowerBI community along with a detailed answer to each one. Watch the recording: buff.ly/3GzPiuQ
Join us for a unique session (Hebrew) where we'll dive into the enhanced capabilities of Delta Lake, explore various machine-learning workflows, and give a live demonstration of #Databricks in action... buff.ly/489kOf7
If you missed Chen's excellent session about Navigating Large Data in #PowerBI (Hebrew), then the session recording is now available: buff.ly/3t1UxjT
The latest episode of #SQLServerRadio (Hebrew Edition) has been released... buff.ly/3Gp6PWu
The wrong (and right) ways to use date/time functions in a query... buff.ly/40Rr3l1
Explore the evolving landscape of the #DataLake and discover the key strategies for effectively working with it in the modern business environment. Join us (Hebrew) as we delve into the various options available to optimize your data lake experience... buff.ly/47nAICA
Read about all the latest exciting announcements about #MicrosoftFabric, including Copilot, a new Explore feature, a new DAX query view in Power BI Desktop, and more... buff.ly/47ICHAS
Get used to the new name in #MicrosoftFabric: Datasets are now called Semantic Models: buff.ly/47riSy2
A nice use case for Instead of Triggers... buff.ly/3QqsClq
#SQLServerRadio for kids (Hebrew Edition)... buff.ly/3SrkyDk
Join me for an insightful 30-minute exploration into the crucial strategies and best practices that enable effective safeguarding of sensitive data in your databases. This meetup will be in Hebrew. buff.ly/3QBzLjZ
Join this meetup (Hebrew) to learn about execution plans in #SQLServer, and the various hints available, examining their effects and when it’s appropriate to use them... buff.ly/46WQDHz
On 13/11 I will be speaking about database cybersecurity. It will be a practical guide for CIOs and whoever is responsible for the security of the organization's databases. This session will be presented in Hebrew. Register today and join me on 13/11... buff.ly/3QBzLjZ
Here are five tips for saving "Real Estate" on your dashboard... buff.ly/3LPWUfQ
In the latest episode of #SQLServerRadio (Hebrew Edition), we hosted Alex Peles, cloud solution architect at Microsoft. We talked about a lot of exciting stuff, everything except SQL Server 🙂 ... buff.ly/3RGQp2L
How to handle SQL Server’s tempdb bloat like a Chef... buff.ly/3ZwlAzs
How can you run reports in #PowerBI when your tables are too large for import mode, but direct mode queries are too slow? Join this meetup (Hebrew) to learn about Power BI aggregate tables and dual mode... buff.ly/3DTTzYQ
I'm super excited to announce that registration is now open for Data.TLV - the biggest non-profit event for data professionals in Israel. The number of seats is limited, so reserve your tickets today... buff.ly/3RdEIjG
Read Geri Reshef's tips for performance tuning of your queries (post in Hebrew)... buff.ly/3P4x60b
Cathrine Wilhelmsen @cathrinew
14K Followers 1K Following Full-time geek from Norway 🤓 Microsoft Data Platform MVP, speaker, organizer, blogger. Loves sci-fi, gaming, chocolate and coffee. Getting a dog! Be kind 💙Gianluca Sartori @spaghettidba
3K Followers 1K Following Data Platform MVP. Formula 1 DBA. Founder at @quantumdatisSQLBits @SQLBits
11K Followers 3K Following The largest Data Platform conference!👨💻 Winner of UK Conference of the Year!🏆 Use #SQLBits & #SQLBits2024🏷️ Watch on-demand @ https://t.co/5Lbsrp429s🎥William Durkin (he/hi.. @sql_williamd
3K Followers 493 Following UK born, DE based Microsoft MVP, co-owner @datamasterminds | Grillmeister @DataGrillen | Co-organizer @NewStarsOfData @Dativerse | @[email protected]Johan Ludvig Brattås @intoleranse
4K Followers 3K Following just this guy, you know? (he/him) (and a Microsoft Data Platform MVP) @[email protected]Koen Verbeeck 🇺�.. @Ko_Ver
4K Followers 981 Following BI pro and tattooed #sqlserver geek. Data warehousing. Data Platform MVP. Punk rock fan. Married & father of 2. He/him @[email protected].Paul White @SQL_Kiwi
5K Followers 145 Following Live in Aotearoa New Zealand 🇳🇿 I write about SQL Server on https://t.co/4mFehtds0Z and https://t.co/nuZwOWQzHy MS Data Platform MVP 2011-2022 Stack Exchange ModL_ N___ @sqL_handLe
2K Followers 3K Following n–n–no… nobody's fault but mine. virtue signaler; seasoned database systems scientician; he/him.Brent Ozar @BrentO
33K Followers 330 Following I make SQL Server go faster. I love teaching, travel, laughing. Las Vegas. Ferrari 328 GTS, two Jaguar XKR-S’s, Speedster replica. He/him, pan.Peter Shore @pshore73.. @pshore73
2K Followers 1K Following Happily married in Ohio originally from the Philly 'burbs. Polynerd SQL Server DBA @CbusPASS chapter leader. 2020/21 #IderaAce Opinions are my own. (he/him)Matt Gordon @sqlatspeed
2K Followers 925 Following Sr. Architect, Data & Analytics @centric by trade, racing driver by hobby. Microsoft Data Platform MVP. Opinions mine. Audere est Facere. (He/him)Niko Neugebauer @NikoNeugebauer
3K Followers 536 Following Work at @Microsoft on Azure SQL Managed Instance #AzureSQL #SQLMI, Community, Columnstore, Teach/Learn. My opinion is always my own & I am mostly wrong. He/Him.Louis Davidson @drsql
4K Followers 2K Following Database\theme park writer, speaker, influencer. https://t.co/XeiAnCTIES editor and Data Platform MVP All reasonable opinions are mine! https://t.co/hRZRZ8KSlHWolfgang Strasser @wstrasser
3K Followers 1K Following Music, Nature, Family MS DataPlatform MVP, @_cubido "Power BI 4 Dummies" #DataCommunityAT #AzureDatacommunity, #Speaker @wstrasser at dataplatformNicky van Vroenhoven @NickyvV
1K Followers 485 Following Data Platform MVP | @Powerdobs | Blogger | Speaker | Marathon Runner | #Chess | Husband | Father of 3 | Ballroom dancer | He/HimBenni De Jagere @BenniDeJagere
2K Followers 1K Following Senior Program Manager Fabric CAT, Microsoft Employee - Volunteer of things @dataMindsBe - Data Enthusiast - Consumer of Coffee - Karateka - Fulltime weirdoThomas LaRock @SQLRockstar
16K Followers 966 Following Microsoft MVP, #vExpert, Data Professional, and #bacon lover (not in that order). #data #analytics #python #infosec https://t.co/l3sg3yqiSgReitse Eskens @2meterDBA
785 Followers 924 Following MVP | MCT | SQL Server | Azure | Photography | Learning | Teaching | Blogging | PowerShell | Speaker | He/HimKamil Nowinski (@nowi.. @NowinskiK
2K Followers 868 Following Group Manager at @avanadeuki. Data Platform #MVP, MCSE. Blogger, speaker, data geek. #azure #sqlfamily @SQLDay @DataRelay_UK. He/him. My own opinions.Bradley Ball @SQLBalls
3K Followers 869 Following Father of 4, Sr. @Azure Engineer @Microsoft, Comic Book aficionado, I ❤️ roller coasters. cohost https://t.co/rymeOtewIt Opinions are my own. 🧵’s @sqlballsRob Nilsen @robnilsen1
3 Followers 48 FollowingHeather Cook she/her .. @heddamaven
9K Followers 6K Following ✨ Connector. Maven. Producer of experiences. 🤝 Community Evangelism/Events - #Microsoft365 Opi my own. Host @Mavensdoitbetta #PodcastChuy Varela @chuy_varela_
1K Followers 5K Following #PowerBI, The Beatles, football fan (soccer for the gringos), Formula 1 🇲🇽 🇺🇸Gaston Cruz - MVP Dat.. @GastonFCruz
2K Followers 2K Following Global Data & AI Leader @Slalom. Love the future. Dad of Florencia and Valentin. Microsoft Data Platform MVP. MCT. PowerPlatform and Data UG Leader 🇺🇾🇺🇸Daniel Taylor | DBABu.. @DBABullDog
2K Followers 2K Following Azure Fast Track Engineer @Microsoft. One Tenacious DBA. Enjoy the mountains, Celtic/highland games, & time with the family. Opinions are my own. He/HimPqorwyu shcudjsj @finstance9987
214 Followers 612 Followingmrtcan @mrtcan38167707
2 Followers 87 FollowingYASİN ÇOBAN @gezgincoban
4 Followers 61 Followingnironimous @nironimous
1 Followers 40 FollowingSaul Montalvo @saulmp
102 Followers 736 FollowingKiki 2213 @KikiMcwhorter
24 Followers 250 Following Humility-Integrity-Positivity.. “Try not to become a man of success, but rather try to become a man of value." - Albert EinsteinBaran @bosadam1xyz
52 Followers 2K FollowingG @Hamas_ISisis
58 Followers 228 FollowingAilin Peter @Ailin789789
175 Followers 1K Following It's better to be single than to be in a cheating relationship.pan jadę @Sergzerodel
164 Followers 1K FollowingSasaPopovicMSFT @SasaPopovicMSFT
190 Followers 272 Following Program Manager at Microsoft. Working on Azure SQL Managed Instance.Yeatsie @syeats
219 Followers 966 Following Database & data integration specialist sometimes found above large waves attached to kites.Shlomi_Cohen @Shlomi_Cohen1
5 Followers 212 FollowingJuliana Austin @rugreen4u
19 Followers 72 FollowingOhad @tzuf_o
64 Followers 872 Following לא לוקח את עצמי ברצינות • מעדיף פרינטים על דיבאג • שגעתם עם הימין ושמאל שלכם • רק פרגי!jens @jens01887392
6 Followers 285 FollowingH D @haridsilva
133 Followers 1K FollowingDaniel Maenle @DanTheSQLMan
389 Followers 369 Following Senior Consultant at SQL Solutions Group. The views expressed here are my own and not of my employer. He/himOrdy (Parody) @Ordnancman
6 Followers 178 Following On my tools configuring & maintaining SQL Server & Azure. Small govt advocate! Swore an oath to the U.S. Constitution, the epotome of civilization.Noor Muhammad @asifsarohi84
336 Followers 3K Following I am working in BreakThru as a Database Administrator Team Lead from 2nd of February 2021 to Onward.ash1985 @ash19853
102 Followers 5K FollowingArthur Greenberg @ArthurG88
10 Followers 147 Followingdsk @santhudsk
0 Followers 521 FollowingRomán Peralta @RomanPeraltaD
49 Followers 356 Following Admirador de la gente sencilla con sueños sofisticadosJonathan Marbutt @jmarbutt
1K Followers 1K Following Love building things that make a difference & impacts lives.Lars Rasmussen @larsra
162 Followers 182 Following Member of The Church of Jesus Christ of Latter-day Saints, husband, dad, specializing in operational aspects of SQL Server. Cardinals. PowerShell. Community.Bulls Eye @b5lls3y3
0 Followers 301 FollowingMagnus Andersen @magandersen
33 Followers 192 FollowingJonathan Gennick @JonathanGennick
1K Followers 3K FollowingQuirino Scaramastra @QuirinoScaram
23 Followers 239 Following l play with databases and some other stuff , i love tech , travel , motorbikes , philosophy and physics then also silly tales.Or Manor @OrManor3
409 Followers 3K Following Passionate about Data & Future Tech, Certified Systems Analyst , Certified Director & Officer, Mentor @Google WTM, Strategic Partnership Lead, Google DevelopersMike Mylie @Brozzagi
18 Followers 489 FollowingGuruprasad @KancheeGuru
24 Followers 146 FollowingVinodh Kumar @vinsdata
35 Followers 120 Following Azure BigData architect, Microsoft Certified Trainer, C#Corner MVP, Azure synapse champion, Microsoft Q&A Contributor, Blogger!Jenny Cosgrove @EvalNerd
1K Followers 5K Following Independent #Eval consultant. Focus on collaborative and participatory approaches to generate useable #Evaluation findings. #EvalTwitter-ersiva @sivameti
46 Followers 2K FollowingBuck Woody @BuckWoodyMSFT
11K Followers 276 FollowingGrant Fritchey @GFritchey
14K Followers 372 Following Grant Fritchey is a database geek, a Microsoft Data Platform MVP and an AWS Community Builder. He works for Red Gate Software as a DevOps Advocate. Call: KC1KCERob He/Him - Not an A.. @sqldbawithbeard
8K Followers 2K Following Big Bearded PowerShell Data Automation MVP x2, Blogger, Speaker, Data Saturdays PSConfEU, dbatools, dbachecks, dbatoolsMoL https://t.co/L7s4cMvElOCathrine Wilhelmsen @cathrinew
14K Followers 1K Following Full-time geek from Norway 🤓 Microsoft Data Platform MVP, speaker, organizer, blogger. Loves sci-fi, gaming, chocolate and coffee. Getting a dog! Be kind 💙Gianluca Sartori @spaghettidba
3K Followers 1K Following Data Platform MVP. Formula 1 DBA. Founder at @quantumdatisSQLBits @SQLBits
11K Followers 3K Following The largest Data Platform conference!👨💻 Winner of UK Conference of the Year!🏆 Use #SQLBits & #SQLBits2024🏷️ Watch on-demand @ https://t.co/5Lbsrp429s🎥Hugo Kornelis @Hugo_Kornelis
3K Followers 367 Following Married, father of 2 children. No cats anymore :(. MVP SQL Server/Data Platform (2006-2016/2019-now). Also likes computer games, snooker, good food. (he/him)Erin Stellato @erinstellato
11K Followers 579 Following Microsoft PM. Michigan alum. Opinions are my own. Still here for a while...but... CounterSocial: @erinstellato Mastodon: @[email protected] she/herJes Schultz @grrl_geek
35K Followers 677 Following Adventurer. Runner. Foodie. Bookworm. Coffee snob. Beer and bourbon lover. Data nerd/MSFT CSA (with my own opinions). Gonna marry @chapmandew soon. she/herPaul Randal @PaulRandal
16K Followers 80 Following Co-owns SQLskills, wrote CHECKDB+DBCC, internals/waits expert, Master Diver, Lego, bibliophile, fly fishing, excavators, married to @kimberlyltripp, 7 cats!William Durkin (he/hi.. @sql_williamd
3K Followers 493 Following UK born, DE based Microsoft MVP, co-owner @datamasterminds | Grillmeister @DataGrillen | Co-organizer @NewStarsOfData @Dativerse | @[email protected]Johan Ludvig Brattås @intoleranse
4K Followers 3K Following just this guy, you know? (he/him) (and a Microsoft Data Platform MVP) @[email protected]Kimberly L. Tripp @KimberlyLTripp
13K Followers 473 Following SQL Server professional (https://t.co/xZY5mLMzBh) since 1990, SCUBA diver, photographer (https://t.co/vDosjGCcf0) 💙 adventures! Married to @paulrandal. 7 cats!Koen Verbeeck 🇺�.. @Ko_Ver
4K Followers 981 Following BI pro and tattooed #sqlserver geek. Data warehousing. Data Platform MVP. Punk rock fan. Married & father of 2. He/him @[email protected].Paul White @SQL_Kiwi
5K Followers 145 Following Live in Aotearoa New Zealand 🇳🇿 I write about SQL Server on https://t.co/4mFehtds0Z and https://t.co/nuZwOWQzHy MS Data Platform MVP 2011-2022 Stack Exchange ModL_ N___ @sqL_handLe
2K Followers 3K Following n–n–no… nobody's fault but mine. virtue signaler; seasoned database systems scientician; he/him.Tobias Koprowski | Ar.. @KoprowskiT
2K Followers 2K Following Founder & Consultant at @SHAConsultingUK, Data Platform MVP, Trainer, Speaker, Community Activist, Freelancer, Adoptive Dad and Coffee Addict.Rob Farley @rob_farley
4K Followers 1K Following LobsterPot Solutions owner & principal consultant, helping orgs do better with their data. Also does stand-up.Brent Ozar @BrentO
33K Followers 330 Following I make SQL Server go faster. I love teaching, travel, laughing. Las Vegas. Ferrari 328 GTS, two Jaguar XKR-S’s, Speedster replica. He/him, pan.Glenn Berry (@GlennAl.. @GlennAlanBerry
10K Followers 706 Following Services Database Engineer Microsoft Data Platform MVP @[email protected] YouTube: https://t.co/OiMek3ydLnAbu Dhabi Investment .. @InvestAbuDhabi
5K Followers 108 Following Connecting global visionaries to Abu Dhabi’s booming investment landscape 🌐 #InvestInAbuDhabi Contact: [email protected]Simon Whiteley @MrSiWhiteley
3K Followers 588 Following Director of Engineering / Owner of @AdvAnalyticsUK, Speaker & Consultant. Spark Nerd. Londoner, foodie & gamer! Microsoft MVP. Databricks Beacon. He/Him.SQLFriday @SqlFriday
353 Followers 44 Following Online Microsoft Data Platform Lunch Sessions. Organised by @Transmokopter.Anna Hoffman @AnalyticAnna
6K Followers 243 Following Principal Group Product Manager on Microsoft's SQL Engineering team. Host of Data Exposed. GT Engineering Undergrad + Data Science Masters. Millennial.Vitaly Bruk @VitalyBruk
110 Followers 271 Following Data Consultant and SQL Server expert at Madeira Data Solutions. More about me and my articles - https://t.co/SerPRbyshxBydlenka z říše Bi.. @mm_cybersin
701 Followers 333 Following Zileniál s duší búmra. Z IT dělňase se stala maminka. Když nevaří, tak paří. 💛🖤 Paleolibertarian, if you're man of culture.Tomas Tucek @TomasTucek
135 Followers 138 Following Founder & CEO @JoyfulCraftsmen • Microsoft Data Platform Evangelist • Agile Fanatic • Leader • Father of 3Czech BI & SQL PASS @sqlpass_cz
244 Followers 163 Following We are the PASS Chapter - a local user group of Microsoft Data Platform professionals and enthusiasts.Jaroslav Reken @jaroreken
395 Followers 762 Following @JoyfulCraftsmen, Microsoft Data Platform Enthusiast, @sqlpass_cz, Business Intelligence ConsultantJoyful Craftsmen @JoyfulCraftsmen
951 Followers 182 Following We are the Microsoft Data Platform Competence Center. 🤓🙌 The enthusiastic experts in SQL Server, Microsoft Azure, Power BI and other leading #Microsoft tech!Jaroslav Miňha @JaroslavMinha
66 Followers 484 Following Azure Data Engineer | MCSE | Czech PASS & #SQLSatPrague Co-OrganizerPavel Málek @malekpav
146 Followers 195 Following SQL Server Enthusiast, World traveler and mountain hiker, Co-Leader of Czech PASS and SQL Saturday Prague co-organizerAlex Friedman @alexf0101
26 Followers 24 FollowingDibya Tara Shakya @dtarashakya
62 Followers 87 Followingshree khanal @shreekhanal
136 Followers 335 Following I am the Founder and principal consultant at SQLHelps, a company that provides data solutions. I am a Data Platform MVP and the leader of the PASS Chapter NepalAnil Maharjan @Anil_Maharjan
269 Followers 352 Following Microsoft Data Platform MVP ,Senior BI Engineer at Ncell ( Axiata ), Verisk Health.User Group Leader Nepal Power BI.Interests in #blogs #speaking ,#DataScienceGogula G. Aryalingam @gogula
896 Followers 474 Following AVP – Data & AI at @IntellintCo (a @FortudeCo brand), consults and architects on analytics & business intelligence on the Microsoft platform, dino nut, cynicJonathan Stewart @sqllocks
801 Followers 378 Following Business Intelligence Architect or a guy who does stuff with data...SQL Server Radio @SQLServerRadio
519 Followers 138 Following Fun #Podcast for #SQLServer and #AzureSQL enthusiasts, hosted by #Microsoft #Data MVPs @Guy_Glantser and @EitanBlumin. Tune in for the latest news and insights!Buffer @buffer
966K Followers 57K Following Your small business' biggest fan 💙 Brand building products for small businesses and ambitious individuals. We're a fully remote team and work 4 days a week. ✨Martin Cairney @martin_cairney
547 Followers 318 Following Microsoft Data Platform MVP, Tech community volunteer and organiser. Definitely left of centre. Uses 's' rather than 'z'. He/himSQL Shack @SQLShack
5K Followers 2K Following SQL Shack is a new SQL server blog with articles about database auditing, server performance, data recovery and moreRoni Vered Adar @RoniVeredAdar
748 Followers 536 Following This account will mainly tweet in Hebrew. #Tech #Stocks #LifeTrello by Atlassian @trello
187K Followers 763 Following Trusted by millions, Trello is the visual collaboration tool that creates a shared perspective on any project. ✏️ Need support? Go to: https://t.co/39bzobDsJQZion National Park @ZionNPS
196K Followers 777 Following The official Twitter site of Zion National Park.Igor Papirov @ipapirov
22K Followers 20K Following Founder of Paraleap Technologies. Passionate about cloud, monitoring and automation. Chief architect of CloudMonix and AzureWatch. Windows Azure Insider.Nick Harshbarger @nicharsh
1K Followers 1K Following Retired Sales Geek, Leadership Consultant, former @sentryone SVP, and John Deere driver (He/Him) Catch me over at https://t.co/0Fr99tOAH0Agitare Tech Inc. @AgitareTech
3K Followers 3K Following We offer managed services for Dev/Test and Insights-aaS. Download our white papers to learn more: https://t.co/Nb0BUhJ2dySaasabi @Saasabi
6K Followers 6K Following SaaS BI & analytics solutions. Cloud OLAP engine. We enable organisations to make better, data-driven decisions.Robotic Scientist @AI_Scientist
2K Followers 0 FollowingAndré Kamman @AndreKamman
2K Followers 1K Following Data Engineer, preferably lots of it and in Azure. Powershell fan, Python student. Old school SQL Server DBA. Microsoft Data Platform MVPמורן אלקובי @MoranAlkobi
21 Followers 31 Following יועץ ומרצה בתחום הפיתוח, מדעי המחשב, תקשורת ומערכות מידע ארגוניות. עוסק בהקמה ופיתוח של סביבות עבודה ממוחשבות עם ותק של יותר מעשר שנים בתחום המחשבים.Cláudio Silva @ClaudioESSilva
2K Followers 2K Following Data Platform Architect | Microsoft Data Platform MVP | PowerShell lover | @psdbatools & @dbachecks contributor | Speaker | @[email protected]{coding}Sight @codingsight
897 Followers 2K Following Awesome blog for SQL Server, .NET, and JavaScript Developers!SQL SKIPPY @SQL_SKIPPY
51 Followers 76 Following David | Databases are my passion | 90s Kid | Husband | Daddy | Tennis | Dogs | He/HimChris Taylor @SQLGeordie
1K Followers 406 Following Data Platform Architect @DataMasterminds, Microsoft Data Platform MVP, @PowerBI_Newc, @DPaCNewc group leader, wear some gloves for @bedlingtonccRa🅤l Balb🅤ena @raulbalbuena
761 Followers 5K Following Christ Follower, Excelent Dad, over 35 years in Data Platform, I am Azure Data Architect in Microsoft and Universitario Soccer Fan. Y Dale U toda la vida !!!DataKinetics @DataKinetics
2K Followers 3K Following Global leader in #DataPerformance and #Optimization Solutions. Passionate about #IBMz #Mainframe #BigData #IoT #CloudDr Mark van Rijmenam,.. @VanRijmenam
44K Followers 6K Following Innovation Keynote Speaker (CSP) & Strategic Futurist for Fortune 500 | Talk to my Digital Twin via text, audio or video in 28 languages!לא בכל יום אני מתרגשת ככה. תודה לכולכם
20 שנה @LeviYonit מגישת המהדורה אז הכנו משהו קטן
@NikoNeugebauer Batch Mode Nested Loops
Watch now: Data Platform Meetup - Explore Big Data with Serverless SQL Pool - Part 1 (45 minutes, Hebrew) Live Demo with @guy_glantser buff.ly/3i1UsXG #Microsoft #SQLServer #AzureSQL #BigData #MadeiraData #Webinar
Thanks @EitanBlumin and @guy_glantser for this episode ! Very proud to have been quoted in #SqlServerRadio episode 146 😁 lnkd.in/eYdvnsjY
So without the index spool, a large correlated subquery might never finish, so it is necessary, but the presence of that index spool screams loudly: CREATE AN INDEX HERE!
That index spool is worth spending the time to create if the proportion of outer rows to inner rows is high, but is not worth it if there are few outer rows to many inner rows.
@guy_glantser Thank you for the presentation. I always imagined un-indexed correlated subqueries would scan the inner loop for every row of outer loop. I didn't realize it adds an index spool as an attempt at an optimization. It helps in most cases, but...
@Zikato25 Only because it keeps dangerous people busy trying to debug it rather than messing with the real parts of a database
Watch now: Performance Monitoring with #Azure SQL Analytics and SQL Insights (Hebrew, 1 hour) buff.ly/3PxBi7s #Microsoft #Webinar #AzureSQL #MadeiraData
אנחנו ממשיכים בסדרת המפגשים ללימוד משותף לקראת ההסמכה Azure Data Engineer. במפגש הקודם למדנו על Delta Lake ב-Azure Synapse Analytics. במפגש הבא (03/08) נלמד איך לשתף נתונים בין SQL Pools ו-Spark Pools ב-Synapse. הצטרפו אלינו ביום רביעי הקרוב... meetup.com/data-platform-…
We are excited to be a part of the @DataAISummit this year from September 19-23. We'll be there in full force with a Keynote, 70+ Sessions, a Women in Technology panel & more! Another great perk for attending, it's FREE: bit.ly/dps2022 #AzureSQL
סובלים מבעיות ביצועים בבסיסי הנתונים שלכם? חוששים מפריצות וסיכוני אבטחה? לא מצליחים לגייס DBA? יש לנו פתרון בשבילכם...
ב-SQL Server 2022, מיקרוסופט משיקה פתרון שנקרא Contained Availability Groups. הוא מאפשר סנכרון של אוביקטים ברמת השרת בין רפליקות. איתן בלומין ממדירה יסביר וידגים איך זה עובד ב-Meetup שיקרה ב-25/07. מוזמנים להירשם ולהצטרף אלינו. meetup.com/en-AU/data-pla… @Madeira_Data @EitanBlumin
The Complete Guide to Temporary Tables and Table Variables by @guy_glantser Block your seat for FREE. bit.ly/dps2022 Check out the session schedule: bit.ly/dps2022content Thanks for Share/RT #SQLServer #TemporaryTables #TableVariables #DataPlatformSummit
I need this in my life despite the fact that I’d use it maybe once a year
I have a new #Microsoft #umbrella, do you like it? 😉☔ @MicrosoftAzure @Microsoft #Azure #clouds ☁️