sqlpass, Twitter, 11/28/2021 1:32:52 PM, 267101


FAQ | Problem?

sqlpass_2021-11-27_22-19-04.xlsx
sqlpass_2021-11-27_22-19-04.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
November 28, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/3FZRIRj
@this0499154500
@sqlpass_de
@steverezhener
@sqlworldwide
@brento
@bweissman
@sql_williamd
@jenstirrup
@reutsmichael1
@runclouds

Top hashtags:
#sqlpass
#sqlbits
#sqlserver
#sqlblog
#speaker
#sqlfamily
#sql
#event
#engagement

Description:
Description
The graph represents a network of 37 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, 28 November 2021 at 06:19 UTC.

The requested start date was Sunday, 28 November 2021 at 01: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 12-day, 8-hour, 5-minute period from Sunday, 14 November 2021 at 13:02 UTC to Friday, 26 November 2021 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 : 37
Unique Edges : 58
Edges With Duplicates : 157
Total Edges : 215
Number of Edge Types : 5
Tweet : 4
Mentions : 149
Replies to : 29
Retweet : 10
MentionsInRetweet : 23
Self-Loops : 5
Reciprocated Vertex Pair Ratio : 0.179487179487179
Reciprocated Edge Ratio : 0.304347826086957
Connected Components : 4
Single-Vertex Connected Components : 1
Maximum Vertices in a Connected Component : 27
Maximum Edges in a Connected Component : 196
Maximum Geodesic Distance (Diameter) : 6
Average Geodesic Distance : 2.580645
Graph Density : 0.0690690690690691
Modularity : 0.280297
NodeXL Version : 1.0.1.447
Data Import : The graph represents a network of 37 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, 28 November 2021 at 06:19 UTC.

The requested start date was Sunday, 28 November 2021 at 01: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 12-day, 8-hour, 5-minute period from Sunday, 14 November 2021 at 13:02 UTC to Friday, 26 November 2021 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:
[4] https://www.brentozar.com/archive/2013/05/questions-about-your-sqlpass-summit-submission/
[4] https://nodexlgraphgallery.org/Pages/Graph.aspx?graphID=266205
[1] https://sqlespresso.com/2019/06/26/understanding-columnstore-indexes-in-sql-server-part-1/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2017/10/30/quick-model-database-tidbit/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2021/06/30/using-readable-secondary-in-azure-sqldb/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://twitter.com/garyshe45345520/status/1457120169889697793?s=20
[1] https://sqlbits.com/information/sponsors
[1] https://www.linkedin.com/slink?code=dUyHwV3H
[1] https://app.orbital.chat/invite/galaxy/14f4802a-85cb-4dfb-a37a-5cef284a02df
[1] https://twitter.com/jenstirrup/status/1460334964189405188

Top URLs in Tweet in G1:
[4] https://nodexlgraphgallery.org/Pages/Graph.aspx?graphID=266205
[1] https://www.brentozar.com/archive/2013/05/questions-about-your-sqlpass-summit-submission/

Top URLs in Tweet in G2:
[1] https://sqlbits.com/information/sponsors

Top URLs in Tweet in G3:
[1] https://twitter.com/jenstirrup/status/1460334964189405188
[1] https://app.orbital.chat/invite/galaxy/14f4802a-85cb-4dfb-a37a-5cef284a02df
[1] https://www.linkedin.com/slink?code=dUyHwV3H

Top URLs in Tweet in G4:
[1] https://twitter.com/garyshe45345520/status/1457120169889697793?s=20

Top URLs in Tweet in G5:
[3] https://www.brentozar.com/archive/2013/05/questions-about-your-sqlpass-summit-submission/

Top URLs in Tweet in G7:
[1] https://sqlespresso.com/2019/06/26/understanding-columnstore-indexes-in-sql-server-part-1/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2021/06/30/using-readable-secondary-in-azure-sqldb/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2017/10/30/quick-model-database-tidbit/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost

Top Domains
Top Domains in Tweet in Entire Graph:
[4] brentozar.com
[4] nodexlgraphgallery.org
[3] sqlespresso.com
[2] twitter.com
[1] sqlbits.com
[1] linkedin.com
[1] orbital.chat

Top Domains in Tweet in G1:
[4] nodexlgraphgallery.org
[1] brentozar.com

Top Domains in Tweet in G2:
[1] sqlbits.com

Top Domains in Tweet in G3:
[1] twitter.com
[1] orbital.chat
[1] linkedin.com

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

Top Domains in Tweet in G5:
[3] brentozar.com

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

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[11] sqlpass
[6] sqlbits
[5] sqlserver
[4] sqlblog
[3] speaker
[2] sqlfamily
[1] sql
[1] event
[1] engagement
[1] sqlbits2022



Top Hashtags in Tweet in G1:
[1] sqlpass
[1] sqlserver
[1] sqlblog
[1] sqlfamily
[1] sqlsat
[1] sqlserver2022
[1] devops

Top Hashtags in Tweet in G2:
[1] sqlbits2022
[1] sqlbits

Top Hashtags in Tweet in G3:
[6] sqlpass
[5] sqlbits
[3] speaker
[1] womenintech
[1] team
[1] virtual
[1] coworking

Top Hashtags in Tweet in G6:
[1] sql
[1] event
[1] engagement
[1] sqlpass
[1] sqlfamily
[1] sqlserver

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

Top Words
Top Words in Tweet in Entire Graph:
[26] sqlpass_de
[25] steverezhener
[25] sqlday
[24] datagrillen
[23] sqlbits
[13] bweissman
[11] #sqlpass
[10] sql_williamd
[8] sqlpass
[7] presentation

Top Words in Tweet in G1:
[7] this0499154500
[4] sqlpass
[4] nodexl
[4] sqlworldwide
[4] muad_dba
[4] dirkhondong
[4] passdatasummit
[3] runclo

Top Words in Tweet in G2:
[22] steverezhener
[22] sqlday
[22] sqlpass_de
[21] datagrillen
[20] sqlbits
[12] bweissman
[9] sql_williamd
[5] nocentino
[2] beer
[2] actual

Top Words in Tweet in G3:
[7] presentation
[6] #sqlpass
[5] #sqlbits
[5] orbitalchat
[4] online
[4] virtual
[4] team
[4] anyone
[4] chat
[4] submissions

Top Words in Tweet in G4:
[4] sqlpass
[3] steverezhener
[3] garyshe45345520
[3] edwinmsarmiento
[3] datagrillen
[3] sqlbits
[3] sqlday
[3] sqlpass_de
[2] sqlha
[2] need

Top Words in Tweet in G5:
[3] 51
[3] questions
[3] conference
[3] session
[3] submission
[2] brento

Top Words in Tweet in G6:
[2] thanks

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:
[25] sqlday,sqlpass_de
[21] steverezhener,sqlday
[18] datagrillen,steverezhener
[15] sqlbits,datagrillen
[7] sql_williamd,sqlbits
[6] bweissman,sqlbits
[6] bweissman,datagrillen
[5] sqlpass_de,nocentino
[5] #sqlbits,#sqlpass
[4] #sqlserver,#sqlblog

Top Word Pairs in Tweet in G1:
[4] sqlpass,nodexl
[4] nodexl,sqlworldwide
[4] sqlworldwide,muad_dba
[4] muad_dba,dirkhondong
[4] dirkhondong,this0499154500
[4] this0499154500,passdatasummit
[3] this0499154500,sqlpass
[3] passdatasummit,runclo

Top Word Pairs in Tweet in G2:
[22] sqlday,sqlpass_de
[21] steverezhener,sqlday
[18] datagrillen,steverezhener
[13] sqlbits,datagrillen
[6] sql_williamd,sqlbits
[6] bweissman,sqlbits
[6] bweissman,datagrillen
[4] sqlpass_de,nocentino
[3] sqlbits,steverezhener
[3] sql_williamd,bweissman

Top Word Pairs in Tweet in G3:
[5] #sqlbits,#sqlpass
[4] online,orbitalchat
[4] orbitalchat,virtual
[4] virtual,team
[4] team,anyone
[4] anyone,chat
[4] chat,presentation
[4] presentation,submissions
[4] submissions,abstracts
[4] abstracts,tips

Top Word Pairs in Tweet in G4:
[3] edwinmsarmiento,sqlpass
[3] sqlday,sqlpass_de
[2] steverezhener,garyshe45345520
[2] garyshe45345520,edwinmsarmiento
[2] sqlbits,datagrillen
[2] datagrillen,sqlday

Top Word Pairs in Tweet in G5:
[3] 51,questions
[3] questions,conference
[3] conference,session
[3] session,submission
[2] brento,51

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
@sqlday
@datagrillen
@steverezhener
@sqlbits
@nocentino
@orbitalchat
@sqlpass
@bweissman
@jenstirrup

Top Mentioned in G1:
@sqlworldwide
@muad_dba
@dirkhondong
@this0499154500
@passdatasummit
@brento
@runclouds
@angella_andrea
@sqlpass_de

Top Mentioned in G2:
@sqlday
@sqlpass_de
@steverezhener
@datagrillen
@sqlbits
@nocentino
@bweissman
@sql_williamd

Top Mentioned in G3:
@orbitalchat
@jenstirrup

Top Mentioned in G4:
@sqlpass
@edwinmsarmiento
@datagrillen
@sqlday
@sqlpass_de
@garyshe45345520
@sqlha
@sqlbits
@sql_williamd
@nocentino

Top Mentioned in G5:
@brento

Top Mentioned in G6:
@hellosqlkitty
@sqlfamily

Top Tweeters
Top Tweeters in Entire Graph:
@brento
@jenstirrup
@sqlha
@mycowork_space
@klunkysql
@sql_williamd
@sqlpass
@sqlespresso
@bweissman
@nocentino

Top Tweeters in G1:
@buckwoodymsft
@dirkhondong
@sqlworldwide
@runclouds
@muad_dba
@this0499154500
@reutsmichael1
@angella_andrea
@sporri
@passdatasummit

Top Tweeters in G2:
@sql_williamd
@bweissman
@nocentino
@wstrasser
@pah66
@sqlbits
@datagrillen
@sqlpass_de
@sqlday

Top Tweeters in G3:
@jenstirrup
@mycowork_space
@mrs_fatherjack
@steminist_bot
@felipe_yyc
@orbitalchat

Top Tweeters in G4:
@sqlha
@sqlpass
@edwinmsarmiento
@steverezhener
@garyshe45345520

Top Tweeters in G5:
@brento
@klunkysql
@pkamasani

Top Tweeters in G6:
@paulswengrr
@hellosqlkitty
@sqlfamily

Top Tweeters in G7:
@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.