sqlpass, Twitter, 7/3/2022 1:34:00 PM, 278963


FAQ | Problem?

sqlpass_2022-07-02_22-15-45.xlsx
sqlpass_2022-07-02_22-15-45.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
July 03, 2022
Short Description:
sqlpass via NodeXL https://bit.ly/3yBpxHq
@sqlpass_de
@kostjaklein
@charleyhanania
@frankgeisler
@volkerbachmann
@sqlpass
@oengels
@triaddataplatug
@azure_synapse
@datamonsterben

Top hashtags:
#sqlpass
#mvpbuzz
#sqlfamily
#sqlserver
#sqlblog
#sqlpass_de
#datamonster

Description:
Description
The graph represents a network of 34 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, 03 July 2022 at 05:15 UTC.

The requested start date was Sunday, 03 July 2022 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, 22-hour, 49-minute period from Sunday, 19 June 2022 at 21:07 UTC to Friday, 01 July 2022 at 19:57 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 : 34
Unique Edges : 46
Edges With Duplicates : 56
Total Edges : 102
Number of Edge Types : 5
Mentions : 59
Retweet : 7
MentionsInRetweet : 12
Replies to : 18
Tweet : 6
Self-Loops : 7
Reciprocated Vertex Pair Ratio : 0.1
Reciprocated Edge Ratio : 0.181818181818182
Connected Components : 6
Single-Vertex Connected Components : 1
Maximum Vertices in a Connected Component : 16
Maximum Edges in a Connected Component : 71
Maximum Geodesic Distance (Diameter) : 4
Average Geodesic Distance : 1.64881
Graph Density : 0.0588235294117647
Modularity : 0.361592
NodeXL Version : 1.0.1.449
Data Import : The graph represents a network of 34 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, 03 July 2022 at 05:15 UTC.

The requested start date was Sunday, 03 July 2022 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, 22-hour, 49-minute period from Sunday, 19 June 2022 at 21:07 UTC to Friday, 01 July 2022 at 19:57 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:
[1] https://twitter.com/PASSDataSummit/status/1542571175322288128
[1] https://sqlespresso.com/2019/09/11/quick-ssms-tip/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2018/05/02/5-ways-to-examine-cardinality-metrics/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2020/01/29/sorting-in-stored-procedures-food-for-thought/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://www.youtube.com/watch?v=ZH6Dchwee1s

[1] https://www.meetup.com/triad-microsoft-data-platform-user-group/events/286858145/

Top URLs in Tweet in G3:
[1] https://www.youtube.com/watch?v=ZH6Dchwee1s

[1] https://www.meetup.com/triad-microsoft-data-platform-user-group/events/286858145/

Top URLs in Tweet in G5:
[1] https://twitter.com/PASSDataSummit/status/1542571175322288128

Top URLs in Tweet in G7:
[1] https://sqlespresso.com/2019/09/11/quick-ssms-tip/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2020/01/29/sorting-in-stored-procedures-food-for-thought/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2018/05/02/5-ways-to-examine-cardinality-metrics/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost

Top Domains
Top Domains in Tweet in Entire Graph:
[3] sqlespresso.com
[1] twitter.com
[1] youtube.com
[1] meetup.com

Top Domains in Tweet in G3:
[1] youtube.com
[1] meetup.com

Top Domains in Tweet in G5:
[1] twitter.com

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

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[8] sqlpass
[4] mvpbuzz
[3] sqlfamily
[3] sqlserver
[3] sqlblog
[2] sqlpass_de
[2] datamonster
[2] dataviz
[1] microsoft
[1] cloudadoptionframework



Top Hashtags in Tweet in G1:
[1] sqlpass_de
[1] sqlfamily

Top Hashtags in Tweet in G2:
[2] dataviz

Top Hashtags in Tweet in G3:
[2] sqlpass
[1] azuresynapse
[1] sqlsat
[1] sqllive

Top Hashtags in Tweet in G4:
[2] datamonster
[2] mvpbuzz
[1] sqlpass_de
[1] microsoft
[1] cloudadoptionframework
[1] dba
[1] caf
[1] waf
[1] passcamp

Top Hashtags in Tweet in G5:
[1] sqlpass

Top Hashtags in Tweet in G6:
[2] sqlpass
[2] sqlfamily
[2] mvpbuzz

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

Top Words
Top Words in Tweet in Entire Graph:
[18] sqlpass_de
[13] oengels
[8] #sqlpass
[8] kostjaklein
[8] frankgeisler
[8] khoeltgen
[7] datamonsterben
[5] speaker
[5] event
[4] #mvpbuzz

Top Words in Tweet in G1:
[14] sqlpass_de
[11] oengels
[7] kostjaklein
[7] frankgeisler
[7] khoeltgen
[6] datamonsterben
[2] voted
[2] looking
[2] forward
[2] helping

Top Words in Tweet in G2:
[5] speaker
[5] event
[4] grrl_geek
[4] two
[4] conferences
[3] contract
[3] diversity
[3] groups
[3] speakers
[2] amtwo

Top Words in Tweet in G3:
[2] azure_synapse
[2] #sqlpass
[2] excited
[2] welcome
[2] feaselkl
[2] speak
[2] virtual
[2] user
[2] group
[2] july

Top Words in Tweet in G4:
[4] sqlpass_de
[3] great
[2] azuresql
[2] hope
[2] oengels
[2] organizers
[2] #datamonster
[2] 2022
[2] #mvpbuzz

Top Words in Tweet in G6:
[2] thank
[2] leadership
[2] #sqlpass
[2] #sqlfamily
[2] #mvpbuzz
[2] good
[2] place
[2] world

Top Words in Tweet in G7:
[3] blog
[3] archive
[3] #sqlserver
[3] #sqlblog
[3] #sqlpass

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[8] frankgeisler,khoeltgen
[7] oengels,kostjaklein
[7] kostjaklein,frankgeisler
[6] datamonsterben,sqlpass_de
[6] sqlpass_de,oengels
[3] speaker,contract
[3] blog,archive
[3] #sqlserver,#sqlblog
[3] #sqlblog,#sqlpass
[3] oengels,sqlpass_de

Top Word Pairs in Tweet in G1:
[7] oengels,kostjaklein
[7] kostjaklein,frankgeisler
[7] frankgeisler,khoeltgen
[5] sqlpass_de,oengels
[5] datamonsterben,sqlpass_de
[3] oengels,sqlpass_de
[2] sqlpass_de,voted
[2] voted,looking
[2] looking,forward
[2] forward,helping

Top Word Pairs in Tweet in G2:
[3] speaker,contract
[2] anyone,copy
[2] copy,old
[2] old,sqlpass
[2] sqlpass,speaker
[2] contract,love
[2] love,see
[2] see,pretty
[2] pretty,sure
[2] sure,language

Top Word Pairs in Tweet in G3:
[2] excited,welcome
[2] welcome,feaselkl
[2] feaselkl,speak
[2] speak,virtual
[2] virtual,user
[2] user,group
[2] group,july
[2] july,13th
[2] 13th,30
[2] 30,pm

Top Word Pairs in Tweet in G4:
[2] sqlpass_de,organizers

Top Word Pairs in Tweet in G6:
[2] good,place

Top Word Pairs in Tweet in G7:
[3] blog,archive
[3] #sqlserver,#sqlblog
[3] #sqlblog,#sqlpass

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@sqlpass_de
@oengels
@kostjaklein
@frankgeisler
@khoeltgen
@grrl_geek
@amtwo
@sqlpass
@azuresql
@azure_synapse

Top Mentioned in G1:
@sqlpass_de
@oengels
@kostjaklein
@frankgeisler
@khoeltgen
@datamonsterben
@kostjak

Top Mentioned in G2:
@grrl_geek
@amtwo
@sqlpass
@sherrod_im
@abmakulec

Top Mentioned in G3:
@azure_synapse
@feaselkl
@triaddataplatug

Top Mentioned in G4:
@sqlpass_de
@azuresql
@oengels
@frankgeisler
@khoeltgen
@kostjaklein
@_tillmann

Top Mentioned in G5:
@procuresql
@shondalgr03

Top Tweeters
Top Tweeters in Entire Graph:
@amtwo
@jenstirrup
@sqlrockstar
@intoleranse
@grrl_geek
@andyleonard
@sqldbawithbeard
@derfredo
@sherrod_im
@abmakulec

Top Tweeters in G1:
@intoleranse
@sqldbawithbeard
@derfredo
@bweissman
@frankgeisler
@volkerbachmann
@oengels
@erwindekreuk
@datamonsterben
@sqlpass_de

Top Tweeters in G2:
@amtwo
@sqlrockstar
@grrl_geek
@sherrod_im
@abmakulec
@sqlpass

Top Tweeters in G3:
@sqlnikon
@thesmilingdba
@feaselkl
@azure_synapse
@triaddataplatug

Top Tweeters in G4:
@kostjaklein
@azuresql
@_tillmann
@charleyhanania

Top Tweeters in G5:
@johnsterrett
@procuresql
@shondalgr03

Top Tweeters in G6:
@jenstirrup
@andyleonard
@sqlrunr

Top Tweeters in G7:
@sqlespresso