NodeXL Graph Gallery: Interactive Graph


Donate to the Social Media Research Foundation's NodeXL development fund

sqlpass_2021-04-17_22-17-20.xlsx (experimental version)
NOTE: This version of the graph is not available with the browser you are using. A more recent version of the browser is required.
Zoom in Zoom out Reset the graph
Go to the graph's main page

From:
NodeXLExcelAutomator
Uploaded on:
April 19, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/3v0z6uH
@sammie_nyakundi
@hybridvug
@retracement
@dirkhondong
@rgmuensterland
@grrl_geek
@dbavug
@sqldbawithbeard
@sqlpaparazzo
@sqldocs

Top hashtags:
#sqlpass
#mvpbuzz
#azure
#sqlserver
#azuredatacommunity
#sqlpass_de
#azuresql

Description:
Description
The graph represents a network of 53 Twitter users whose tweets in the requested range contained "sqlpass", or who were replied to or mentioned in those tweets. The network was obtained from the NodeXL Graph Server on Sunday, 18 April 2021 at 05:17 UTC.

The requested start date was Sunday, 18 April 2021 at 00:01 UTC and the maximum number of days (going backward) was 14.

The maximum number of tweets collected was 7,500.

The tweets in the network were tweeted over the 11-day, 9-hour, 45-minute period from Sunday, 04 April 2021 at 20:19 UTC to Friday, 16 April 2021 at 06:04 UTC.

Additional tweets that were mentioned in this data set were also collected from prior time periods. These tweets may expand the complete time period of the data.

There is an edge for each "replies-to" relationship in a tweet, an edge for each "mentions" relationship in a tweet, and a self-loop edge for each tweet that is not a "replies-to" or "mentions".

The graph is directed.

The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.

The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.


Author Description


Overall Graph Metrics
Vertices : 53
Unique Edges : 38
Edges With Duplicates : 60
Total Edges : 98
Number of Edge Types : 5
MentionsInRetweet : 34
Mentions : 33
Retweet : 20
Replies to : 2
Tweet : 9
Self-Loops : 9
Reciprocated Vertex Pair Ratio : 0.0350877192982456
Reciprocated Edge Ratio : 0.0677966101694915
Connected Components : 9
Single-Vertex Connected Components : 3
Maximum Vertices in a Connected Component : 18
Maximum Edges in a Connected Component : 27
Maximum Geodesic Distance (Diameter) : 3
Average Geodesic Distance : 1.674177
Graph Density : 0.0214078374455733
Modularity : 0.532617
NodeXL Version : 1.0.1.445
Data Import : The graph represents a network of 53 Twitter users whose tweets in the requested range contained "sqlpass", or who were replied to or mentioned in those tweets. The network was obtained from the NodeXL Graph Server on Sunday, 18 April 2021 at 05:17 UTC.

The requested start date was Sunday, 18 April 2021 at 00:01 UTC and the maximum number of days (going backward) was 14.

The maximum number of tweets collected was 7,500.

The tweets in the network were tweeted over the 11-day, 9-hour, 45-minute period from Sunday, 04 April 2021 at 20:19 UTC to Friday, 16 April 2021 at 06:04 UTC.

Additional tweets that were mentioned in this data set were also collected from prior time periods. These tweets may expand the complete time period of the data.

There is an edge for each "replies-to" relationship in a tweet, an edge for each "mentions" relationship in a tweet, and a self-loop edge for each tweet that is not a "replies-to" or "mentions".

Layout Algorithm : The graph was laid out using the Harel-Koren Fast Multiscale layout algorithm.
Graph Source : GraphServerTwitterSearch
Graph Term : sqlpass
Groups : The graph's vertices were grouped by cluster using the Clauset-Newman-Moore cluster algorithm.
Edge Color : Edge Weight
Edge Width : Edge Weight
Edge Alpha : Edge Weight
Vertex Radius : Betweenness Centrality

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[5] https://www.meetup.com/dbavug/events/276088487/
[2] https://twitter.com/hybridvug/status/1376934342019198978
[2] https://zoom.us/webinar/register/9216171215286/WN_V1oOoKiyQ0y8k3jW3IjC2A
[2] https://sqlespresso.com/2018/10/31/how-much-will-compression-really-gain-me/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://www.eventbrite.de/e/global-azure-virtual-2021-ludinghausen-tickets-144981867669?aff=ebdssbeac
[1] https://mailchi.mp/99a60527f365/session7
[1] https://www.meetup.com/hybrid-virtual-group/
[1] https://sqlperformance.com/2021/04/t-sql-queries/number-series-solutions-4
[1] https://sqlperformance.com/2021/04/sql-performance/parallel-plans-start-2
[1] https://twitter.com/way0utwest/status/1381678310757908484

Top URLs in Tweet in G2:
[2] https://zoom.us/webinar/register/9216171215286/WN_V1oOoKiyQ0y8k3jW3IjC2A
[2] https://twitter.com/hybridvug/status/1376934342019198978
[1] https://www.meetup.com/hybrid-virtual-group/events/
[1] https://twitter.com/sqldbawithbeard/status/1379782090330406912
[1] https://mailchi.mp/99a60527f365/session7
[1] https://www.meetup.com/hybrid-virtual-group/

Top URLs in Tweet in G3:
[1] https://www.eventbrite.de/e/global-azure-virtual-2021-ludinghausen-tickets-144981867669?aff=ebdssbeac

Top URLs in Tweet in G4:
[5] https://www.meetup.com/dbavug/events/276088487/

Top URLs in Tweet in G6:
[1] https://twitter.com/way0utwest/status/1381678310757908484
[1] https://sqlperformance.com/2021/04/t-sql-queries/number-series-solutions-4
[1] https://sqlperformance.com/2021/04/sql-performance/parallel-plans-start-2

Top URLs in Tweet in G7:
[2] https://sqlespresso.com/2018/10/31/how-much-will-compression-really-gain-me/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2018/12/05/sql-data-discovery-and-classification-in-ssms-18-0/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2020/01/08/memory-optimized-tables-in-sql-server/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost

Top Domains
Top Domains in Tweet in Entire Graph:
[7] meetup.com
[4] twitter.com
[4] sqlespresso.com
[2] sqlperformance.com
[2] zoom.us
[1] eventbrite.de
[1] mailchi.mp

Top Domains in Tweet in G2:
[3] twitter.com
[2] meetup.com
[2] zoom.us
[1] mailchi.mp

Top Domains in Tweet in G3:
[1] eventbrite.de

Top Domains in Tweet in G4:
[5] meetup.com

Top Domains in Tweet in G6:
[2] sqlperformance.com
[1] twitter.com

Top Domains in Tweet in G7:
[4] sqlespresso.com

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[23] sqlpass
[12] mvpbuzz
[5] azure
[5] sqlserver
[5] azuredatacommunity
[4] sqlpass_de
[4] azuresql
[4] azuredata
[4] sqlblog
[3] powerbi



Top Hashtags in Tweet in G2:
[10] sqlpass
[10] mvpbuzz
[3] powerbi

Top Hashtags in Tweet in G3:
[4] sqlpass_de
[2] globalazure
[1] sap
[1] azure

Top Hashtags in Tweet in G4:
[4] sqlpass
[4] azure
[4] azuresql
[4] azuredata
[4] azuredatacommunity

Top Hashtags in Tweet in G5:
[1] azuredatacommunity
[1] sqlpass

Top Hashtags in Tweet in G6:
[4] sqlpass
[2] mvpbuzz
[1] sqlsaturday
[1] sqlserver
[1] sqlfamily
[1] pass

Top Hashtags in Tweet in G7:
[4] sqlserver
[4] sqlblog
[4] sqlpass

Top Words
Top Words in Tweet in Entire Graph:
[23] #sqlpass
[17] sql
[16] azure
[12] #mvpbuzz
[12] grrl_geek
[12] database
[12] options
[12] choose
[11] 2021
[8] session

Top Words in Tweet in G2:
[10] #sqlpass
[10] #mvpbuzz
[5] register
[5] jupyter
[4] retracement
[4] hybridvug
[4] session
[4] notebooks
[4] sqldbawithbeard
[3] amazing

Top Words in Tweet in G3:
[4] rgmuensterland
[4] #sqlpass_de
[3] globalazure
[3] ganz
[3] mal
[2] spät
[2] virtuelle
[2] event
[2] luedinghausen
[2] #globalazure

Top Words in Tweet in G4:
[12] grrl_geek
[12] azure
[12] sql
[12] database
[12] options
[12] choose
[8] dbavug
[7] talking
[7] wednesday
[7] april

Top Words in Tweet in G5:
[3] sqldocs
[3] team
[3] presenting
[3] session
[3] becoming
[3] contributor
[3] microsoft
[3] docs
[3] various
[3] confs

Top Words in Tweet in G6:
[4] #sqlpass
[2] days
[2] #mvpbuzz
[2] interested
[2] canadian
[2] blogger
[2] sqlperformance
[2] part

Top Words in Tweet in G7:
[4] blog
[4] archive
[4] sql
[4] #sqlserver
[4] #sqlblog
[4] #sqlpass
[3] server
[2] much
[2] compression
[2] really

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[12] azure,sql
[12] sql,database
[12] database,options
[12] options,choose
[7] grrl_geek,talking
[7] talking,azure
[7] choose,wednesday
[7] wednesday,april
[7] april,14
[7] 14,2021

Top Word Pairs in Tweet in G2:
[5] #sqlpass,#mvpbuzz
[5] #mvpbuzz,#sqlpass
[4] jupyter,notebooks
[3] amazing,#powerbi
[3] #powerbi,webinars
[3] webinars,scheduled
[3] scheduled,over
[3] over,coming
[3] coming,weeks
[3] weeks,check

Top Word Pairs in Tweet in G3:
[2] spät,virtuelle
[2] virtuelle,globalazure
[2] globalazure,event
[2] event,rgmuensterland
[2] rgmuensterland,luedinghausen
[2] mehr,ganz
[2] ganz,lange
[2] lange,global
[2] global,azure
[2] azure,2021

Top Word Pairs in Tweet in G4:
[12] azure,sql
[12] sql,database
[12] database,options
[12] options,choose
[7] grrl_geek,talking
[7] talking,azure
[7] choose,wednesday
[7] wednesday,april
[7] april,14
[7] 14,2021

Top Word Pairs in Tweet in G5:
[3] sqldocs,team
[3] team,presenting
[3] presenting,session
[3] session,becoming
[3] becoming,contributor
[3] contributor,microsoft
[3] microsoft,docs
[3] docs,various
[3] various,confs
[2] william_a_dba,sqldocs

Top Word Pairs in Tweet in G6:
[2] canadian,blogger
[2] blogger,sqlperformance
[2] part,#sqlpass

Top Word Pairs in Tweet in G7:
[4] blog,archive
[4] #sqlserver,#sqlblog
[4] #sqlblog,#sqlpass
[3] sql,server
[3] server,#sqlserver
[2] archive,much
[2] much,compression
[2] compression,really
[2] really,gain
[2] gain,sql

Top Replied-To
Top Replied-To in Entire Graph:
@_michael_sch_
@nutanix

Top Replied-To in G1:
@nutanix

Top Replied-To in G3:
@_michael_sch_

Top Mentioned
Top Mentioned in Entire Graph:
@grrl_geek
@dbavug
@rgmuensterland
@retracement
@hybridvug
@sqldbawithbeard
@globalazure
@sqldocs
@luedinghausen
@william_a_dba

Top Mentioned in G1:
@scpcapital
@screenscape
@sdtc1976
@seon_tech
@sigmacomputing
@signatelab
@situlive
@skeletontweet
@specflow
@spotifypodcasts

Top Mentioned in G2:
@retracement
@hybridvug
@sqldbawithbeard
@bruco441
@irishsql

Top Mentioned in G3:
@rgmuensterland
@globalazure
@luedinghausen
@dirkhondong
@markuswinand
@sqlpass_de

Top Mentioned in G4:
@grrl_geek
@dbavug

Top Mentioned in G5:
@sqldocs
@william_a_dba

Top Mentioned in G7:
@sqlespresso

Top Tweeters
Top Tweeters in Entire Graph:
@grrl_geek
@resing
@sqldbawithbeard
@retracement
@sqlpass
@nutanix
@irishsql
@glennalanberry
@sqlbobscot
@sqlbek

Top Tweeters in G1:
@sqlpass
@nutanix
@squadhelp
@sqanews
@skeletontweet
@sammie_nyakundi
@screenscape
@spotifypodcasts
@studio_goblinz
@sigmacomputing

Top Tweeters in G2:
@sqldbawithbeard
@retracement
@irishsql
@sqlbobscot
@yatessql
@bruco441
@jonsequitur
@zappedtothe
@jqmtweets
@hybridvug

Top Tweeters in G3:
@dirkhondong
@frankgeisler
@markuswinand
@sqlpaparazzo
@sqlpass_de
@globalazure
@luedinghausen
@rgmuensterland
@_michael_sch_

Top Tweeters in G4:
@grrl_geek
@sqlbek
@sqlworldwide
@alzdba
@mobileck
@kaysauter
@dbavug

Top Tweeters in G5:
@resing
@william_a_dba
@sqldocs
@talk2toks

Top Tweeters in G6:
@victoria_holt
@akarcher
@pass_rm_canada

Top Tweeters in G7:
@glennalanberry
@sqlespresso


We use necessary cookies to make our site work. We’d like to set additional cookies to understand site usage, make site improvements and to remember your settings. We also use cookies set by other sites to help deliver content from their services.