sqlpass, Twitter, 5/22/2022 11:00:05 AM, 276815


FAQ | Problem?

sqlpass_2022-05-21_22-15-45.xlsx
sqlpass_2022-05-21_22-15-45.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
May 22, 2022
Short Description:
sqlpass via NodeXL https://bit.ly/3sMxAhm
@preguntoncabron
@frankgeisler
@cebrusa
@bweissman
@bilbostack
@rpertusa
@wtmmadrid
@wtmzaragoza
@sqlpass
@netconfbcn

Top hashtags:
#sqlpass
#sqlserver
#sqlpass_de
#sqlblog
#sqlfamily
#passsummit
#tsql
#azuredatacommunity

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, 22 May 2022 at 05:15 UTC.

The requested start date was Sunday, 22 May 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, 16-hour, 13-minute period from Monday, 09 May 2022 at 04:54 UTC to Friday, 20 May 2022 at 21:07 UTC.

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 : 45
Edges With Duplicates : 29
Total Edges : 74
Number of Edge Types : 5
Retweet : 3
MentionsInRetweet : 2
Tweet : 9
Mentions : 56
Replies to : 4
Self-Loops : 10
Reciprocated Vertex Pair Ratio : 0.0188679245283019
Reciprocated Edge Ratio : 0.037037037037037
Connected Components : 7
Single-Vertex Connected Components : 2
Maximum Vertices in a Connected Component : 34
Maximum Edges in a Connected Component : 33
Maximum Geodesic Distance (Diameter) : 3
Average Geodesic Distance : 1.84818
Graph Density : 0.0195936139332366
Modularity : 0.496941
NodeXL Version : 1.0.1.449
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, 22 May 2022 at 05:15 UTC.

The requested start date was Sunday, 22 May 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, 16-hour, 13-minute period from Monday, 09 May 2022 at 04:54 UTC to Friday, 20 May 2022 at 21:07 UTC.

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:
[2] https://sqlespresso.com/2020/06/16/what-is-batch-mode-on-rowstore-in-sql-server/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2019/05/22/filtered-index-basics/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2017/10/25/synchronous-vs-asynchronously-statistics-updates/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlperformance.com/2022/05/sql-optimizer/simple-parameterization-and-trivial-plans-part-4
[1] https://sqlperformance.com/2022/05/t-sql-queries/are-you-sorted-window-ordering
[1] https://www.meetup.com/GLASS-Greater-Lansing-Area-for-SQL-Server/events/285864685/?utm_medium=referral&utm_campaign=announceModal_savedevents_share_modal&utm_source=twitter
[1] https://passdatacommunitysummit.com/

Top URLs in Tweet in G3:
[2] https://sqlespresso.com/2020/06/16/what-is-batch-mode-on-rowstore-in-sql-server/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2017/10/25/synchronous-vs-asynchronously-statistics-updates/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2019/05/22/filtered-index-basics/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost

Top URLs in Tweet in G4:
[1] https://www.meetup.com/GLASS-Greater-Lansing-Area-for-SQL-Server/events/285864685/?utm_medium=referral&utm_campaign=announceModal_savedevents_share_modal&utm_source=twitter

Top URLs in Tweet in G6:
[1] https://passdatacommunitysummit.com/
[1] https://sqlperformance.com/2022/05/sql-optimizer/simple-parameterization-and-trivial-plans-part-4
[1] https://sqlperformance.com/2022/05/t-sql-queries/are-you-sorted-window-ordering

Top Domains
Top Domains in Tweet in Entire Graph:
[4] sqlespresso.com
[2] sqlperformance.com
[1] meetup.com
[1] passdatacommunitysummit.com

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

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

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

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[9] sqlpass
[5] sqlserver
[5] sqlpass_de
[4] sqlblog
[2] sqlfamily
[2] passsummit
[1] tsql
[1] azuredatacommunity
[1] ichfallinsbett
[1] passdatacommunitysummit



Top Hashtags in Tweet in G2:
[2] sqlfamily
[2] sqlpass_de
[1] datamonster

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

Top Hashtags in Tweet in G4:
[1] sqlserver
[1] tsql
[1] azuredatacommunity
[1] sqlpass

Top Hashtags in Tweet in G5:
[3] sqlpass_de
[1] ichfallinsbett

Top Hashtags in Tweet in G6:
[4] sqlpass
[2] passsummit
[1] passdatacommunitysummit
[1] loooonghashtag

Top Words
Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[4] blog,archive
[4] #sqlserver,#sqlblog
[4] #sqlblog,#sqlpass
[3] happy,birthday
[3] jeroenterheerdt,ms_kellykaye
[3] ms_kellykaye,awsaxton
[3] awsaxton,will_mi77
[3] will_mi77,heidihasting
[3] heidihasting,tsql_ninja
[2] archive,batch

Top Word Pairs in Tweet in G2:
[3] jeroenterheerdt,ms_kellykaye
[3] ms_kellykaye,awsaxton
[3] awsaxton,will_mi77
[3] will_mi77,heidihasting
[3] heidihasting,tsql_ninja
[2] happy,birthday
[2] #sqlfamily,#sqlpass_de
[2] cebrusa,jeroenterheerdt
[2] tsql_ninja,sqlpass_de

Top Word Pairs in Tweet in G3:
[4] blog,archive
[4] #sqlserver,#sqlblog
[4] #sqlblog,#sqlpass
[2] archive,batch
[2] batch,mode
[2] mode,rowstore
[2] rowstore,sql
[2] sql,server
[2] server,#sqlserver

Top Word Pairs in Tweet in G4:
[2] join,next
[2] next,thursday
[2] thursday,19
[2] 19,jeff
[2] jeff,moden
[2] moden,talks
[2] talks,black
[2] black,arts
[2] arts,sql
[2] sql,dates

Top Word Pairs in Tweet in G6:
[2] pass,data
[2] data,community
[2] community,summit
[2] summit,hybrid
[2] hybrid,november
[2] november,going
[2] going,whos'
[2] whos',fence
[2] fence,#sqlpass
[2] #sqlpass,#passsummit

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@jeroenterheerdt
@ms_kellykaye
@awsaxton
@will_mi77
@heidihasting
@tsql_ninja
@sqlpass_de
@sqlespresso
@neraija
@frankgeisler

Top Mentioned in G1:
@yondemon
@rallat
@alba_roza
@flipper83
@commitconf
@jsdayes
@jscanarias
@wtmmadrid
@wtmzaragoza
@sqlpass

Top Mentioned in G2:
@jeroenterheerdt
@ms_kellykaye
@awsaxton
@will_mi77
@heidihasting
@tsql_ninja
@sqlpass_de
@neraija
@frankgeisler

Top Mentioned in G3:
@sqlespresso

Top Mentioned in G4:
@glassusergroup

Top Mentioned in G5:
@w_gauer

Top Mentioned in G6:
@heyminionware

Top Tweeters
Top Tweeters in Entire Graph:
@flipper83
@rallat
@yondemon
@sqlmct
@bweissman
@sqlespresso
@tlptenerife
@dirkhondong
@t3chfest
@awsaxton

Top Tweeters in G1:
@flipper83
@rallat
@yondemon
@tlptenerife
@t3chfest
@alba_roza
@preguntoncabron
@wtmzaragoza
@bilbostack
@jscanarias

Top Tweeters in G2:
@bweissman
@awsaxton
@will_mi77
@frankgeisler
@jeroenterheerdt
@heidihasting
@neraija
@cebrusa
@sqlpass_de
@ms_kellykaye

Top Tweeters in G3:
@sqlmct
@sqlespresso

Top Tweeters in G4:
@andersom79
@glassusergroup

Top Tweeters in G5:
@dirkhondong
@w_gauer

Top Tweeters in G6:
@heyminionware
@pass_rm_canada