Friday Five: SQL Server, Power BI Tips, More!

Published Mar 18 2022 07:00 AM 1,199 Views
Senior Member

image.png

SQL Server query mode execution and columnstore indexes

Sergio Govoni is a graduate of Computer Science from "Università degli Studi" in Ferrara, Italy. Following almost two decades at Centro Software, a software house that produces the best ERP for manufacturing companies that are export-oriented, Sergio now manages the Development Product Team and is constantly involved on several team projects. For the provided help to technical communities and for sharing his own experience, since 2010 he has received the Microsoft Data Platform MVP award. During 2011 he contributed to writing the book: SQL Server MVP Deep Dives Volume 2. Follow him on Twitter or read his blogs in Italian and English.

image.png

Power BI Custom Sort order in Bar Chart

Mohamed El-Qassas is a Microsoft MVP, SharePoint StackExchange (StackOverflow) Moderator, C# Corner MVP, Microsoft TechNet Wiki Judge, Blogger, and Senior Technical Consultant with +10 years of experience in SharePoint, Project Server, and BI. In SharePoint StackExchange, he has been elected as the 1st Moderator in the GCC, Middle East, and Africa, and ranked as the 2nd top contributor of all the time. Check out his blog here.

image.png

Backup Azure Firewall with virtual wan #Azure #SDWAN #Backup #Runbook

Robert Smit is a EMEA Cloud Solution Architect at Insight.de and is a current Microsoft MVP Cloud and Datacenter as of 2009. Robert has over 20 years experience in IT with experience in the educational, health-care and finance industries. Robert’s past IT experience in the trenches of IT gives him the knowledge and insight that allows him to communicate effectively with IT professionals. Follow him on Twitter at @clusterMVP

image.png

Building micro services through Event Driven Architecture part19 : Building and Securing Real Time C...

Gora Leye is a Solutions Architect, Technical Expert and Devoper based in Paris. He works predominantly in Microsoft stacks: Dotnet, Dotnet Core, Azure, Azure Active Directory/Graph, VSTS, Docker, Kubernetes, and software quality. Gora has a mastery of technical tests (unit tests, integration tests, acceptance tests, and user interface tests). Follow him on Twitter @logcorner.

5002133.jpg

Reduce code complexity by letting an API Gateway handle disparate services and document transformati...

Oscar Garcia is a Principal Software Architect who resides in South Florida. He is a Developer Technologies MVP and certified solutions developer with many years of experience building software solutions. He specializes in building cloud solutions using technologies like AWS, Azure, ASP.NET, NodeJS, AngularJS as well as BI projects for data visualization using tools like Power BI, Tableau and JMP. You can follow Oscar on Twitter @ozkary or his blog at ozkary.com 

%3CLINGO-SUB%20id%3D%22lingo-sub-3260490%22%20slang%3D%22en-US%22%3EFriday%20Five%3A%20SQL%20Server%2C%20Power%20BI%20Tips%2C%20More!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3260490%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20177px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176793i4D8A6B81F1C57568%2Fimage-dimensions%2F177x266%3Fv%3Dv2%22%20width%3D%22177%22%20height%3D%22266%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fmedium.com%2Fcodex%2Fsql-server-query-mode-execution-and-columnstore-indexes-fa05152c0753%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ESQL%20Server%20query%20mode%20execution%20and%20columnstore%20indexes%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fit-it%2FPublicProfile%2F4029181%3FfullName%3DSergio%2520Govoni%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESergio%20Govoni%3C%2FA%3E%20is%20a%20graduate%20of%20Computer%20Science%20from%20%22Universit%C3%A0%20degli%20Studi%22%20in%20Ferrara%2C%20Italy.%20Following%20almost%20two%20decades%20at%20Centro%20Software%2C%20a%20software%20house%20that%20produces%20the%20best%20ERP%20for%20manufacturing%20companies%20that%20are%20export-oriented%2C%20Sergio%20now%20manages%20the%20Development%20Product%20Team%20and%20is%20constantly%20involved%20on%20several%20team%20projects.%20For%20the%20provided%20help%20to%20technical%20communities%20and%20for%20sharing%20his%20own%20experience%2C%20since%202010%20he%20has%20received%20the%20Microsoft%20Data%20Platform%20MVP%20award.%20During%202011%20he%20contributed%20to%20writing%20the%20book%3A%3CA%20href%3D%22http%3A%2F%2Fwww.manning.com%2Fdelaney%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20SQL%20Server%20MVP%20Deep%20Dives%20Volume%202%3C%2FA%3E.%20Follow%20him%20on%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fsegovoni%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20Twitter%3C%2FA%3E%20or%20read%20his%20blogs%20in%3CA%20href%3D%22https%3A%2F%2Fwww.ugiss.org%2Fauthor%2Fsgovoni%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20Italian%3C%2FA%3E%20and%3CA%20href%3D%22https%3A%2F%2Fmedium.com%2F%40segovoni%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20English%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190070i7E09B746CCC2B5F1%2Fimage-dimensions%2F208x207%3Fv%3Dv2%22%20width%3D%22208%22%20height%3D%22207%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fdevoworx.net%2Fpower-bi-custom-sort-order-bar-chart%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EPower%20BI%20Custom%20Sort%20order%20in%20Bar%20Chart%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5002973%3FfullName%3DMohamed%2520%2520El-Qassas%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMohamed%20El-Qassas%3C%2FA%3E%20is%20a%20Microsoft%20MVP%2C%20SharePoint%20StackExchange%20(StackOverflow)%20Moderator%2C%20C%23%20Corner%20MVP%2C%20Microsoft%20TechNet%20Wiki%20Judge%2C%20Blogger%2C%20and%20Senior%20Technical%20Consultant%20with%20%2B10%20years%20of%20experience%20in%20SharePoint%2C%20Project%20Server%2C%20and%20BI.%20In%20SharePoint%20StackExchange%2C%20he%20has%20been%20elected%20as%20the%201st%20Moderator%20in%20the%20GCC%2C%20Middle%20East%2C%20and%20Africa%2C%20and%20ranked%20as%20the%202nd%20top%20contributor%20of%20all%20the%20time.%20Check%20out%20his%20%3CA%20href%3D%22https%3A%2F%2Fspgeeks.devoworx.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eblog%3C%2FA%3E%20here.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20219px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167041iA0B732322D2366D6%2Fimage-dimensions%2F219x219%3Fv%3Dv2%22%20width%3D%22219%22%20height%3D%22219%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Frobertsmit.wordpress.com%2F2022%2F02%2F24%2Fbackup-azure-firewall-with-virtual-wan-azure-sdwan-backup-runbook%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EBackup%20Azure%20Firewall%20with%20virtual%20wan%20%23Azure%20%23SDWAN%20%23Backup%20%23Runbook%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F4025011%3FfullName%3DRobert%2520Smit%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERobert%20Smit%3C%2FA%3E%20is%20a%20EMEA%20Cloud%20Solution%20Architect%20at%20Insight.de%20and%20is%20a%20current%20Microsoft%20MVP%20Cloud%20and%20Datacenter%20as%20of%202009.%20Robert%20has%20over%2020%20years%20experience%20in%20IT%20with%20experience%20in%20the%20educational%2C%20health-care%20and%20finance%20industries.%20Robert%E2%80%99s%20past%20IT%20experience%20in%20the%20trenches%20of%20IT%20gives%20him%20the%20knowledge%20and%20insight%20that%20allows%20him%20to%20communicate%20effectively%20with%20IT%20professionals.%20Follow%20him%20on%20Twitter%20at%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FClustermvp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%40clusterMVP%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20217px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F178462iEDA63D9879185C1B%2Fimage-dimensions%2F217x217%3Fv%3Dv2%22%20width%3D%22217%22%20height%3D%22217%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Flogcorner.com%2Fbuilding-micro-services-through-event-driven-architecture-part19-building-and-securing-real-time-communications-using-signalr-and-azure-active-directory%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EBuilding%20micro%20services%20through%20Event%20Driven%20Architecture%20part19%20%3A%20Building%20and%20Securing%20Real%20Time%20Communications%20using%20SignalR%20and%20Azure%20Active%20Directory%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5003013%3FfullName%3DGora%2520%2520LEYE%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGora%20Leye%3C%2FA%3E%20is%20a%20Solutions%20Architect%2C%20Technical%20Expert%20and%20Devoper%20based%20in%20Paris.%20He%20works%20predominantly%20in%20Microsoft%20stacks%3A%20Dotnet%2C%20Dotnet%20Core%2C%20Azure%2C%20Azure%20Active%20Directory%2FGraph%2C%20VSTS%2C%20Docker%2C%20Kubernetes%2C%20and%20software%20quality.%20Gora%20has%20a%20mastery%20of%20technical%20tests%20(unit%20tests%2C%20integration%20tests%2C%20acceptance%20tests%2C%20and%20user%20interface%20tests).%20Follow%20him%20on%20Twitter%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Flogcorner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%40logcorner%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%225002133.jpg%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F219180iF35CE4F86F7D67C3%2Fimage-size%2Fsmall%3Fv%3Dv2%26amp%3Bpx%3D200%22%20role%3D%22button%22%20title%3D%225002133.jpg%22%20alt%3D%225002133.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fwww.ozkary.com%2F2022%2F02%2Freduce-code-complexity-api-gateway-handles-disparate-services-transformation.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EReduce%20code%20complexity%20by%20letting%20an%20API%20Gateway%20handle%20disparate%20services%20and%20document%20transformation%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5002133%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOscar%20Garcia%3C%2FA%3E%20is%20a%20Principal%20Software%20Architect%20who%20resides%20in%20South%20Florida.%20He%20is%20a%20Developer%20Technologies%20MVP%20and%20certified%20solutions%20developer%20with%20many%20years%20of%20experience%20building%20software%20solutions.%20He%20specializes%20in%20building%20cloud%20solutions%20using%20technologies%20like%20AWS%2C%20Azure%2C%20ASP.NET%2C%20NodeJS%2C%20AngularJS%20as%20well%20as%20BI%20projects%20for%20data%20visualization%20using%20tools%20like%20Power%20BI%2C%20Tableau%20and%20JMP.%20You%20can%20follow%20Oscar%20on%20Twitter%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fozkary%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%40ozkary%3C%2FA%3E%20or%20his%20blog%20at%20%3CA%20href%3D%22http%3A%2F%2Fozkary.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eozkary.com%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3260490%22%20slang%3D%22en-US%22%3E%3CP%20data-unlink%3D%22true%22%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22cloud-gfa9db375f_1920.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F356677iB7227990A9B4649D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22cloud-gfa9db375f_1920.jpg%22%20alt%3D%22cloud-gfa9db375f_1920.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20data-unlink%3D%22true%22%3E%3CSTRONG%3EBuilding%20micro%20services%20through%20Event%20Driven%20Architecture%20part19%20%3A%20Building%20and%20Securing%20Real%20Time%20Communications%20using%20SignalR%20and%20Azure%20Active%20Directory%2C%26nbsp%3BReduce%20code%20complexity%20by%20letting%20an%20API%20Gateway%20handle%20disparate%20services%20and%20document%20transformation%2C%26nbsp%3BSQL%20Server%20query%20mode%20execution%20and%20columnstore%20indexes%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3260490%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFriday%20Five%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Mar 18 2022 07:00 AM
Updated by: