sqlpass, Twitter, 8/8/2021 10:13:12 AM, 259755


FAQ | Problem?

sqlpass_2021-08-07_22-19-04.xlsx
sqlpass_2021-08-07_22-19-04.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
August 08, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/3yCjpMA
@hybridvug
@thesqlgrrrl
@sqlpass_de
@mamacodet
@lenz_philipp
@passdatasummit
@synstalker
@seekandd3stroy
@communities4f
@papariedel

Top hashtags:
#sqlpass
#sqlserver
#passdatacommunitysummit
#bestofsummit2020
#sqlblog

Description:
Description
The graph represents a network of 36 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, 08 August 2021 at 05:19 UTC.

The requested start date was Sunday, 08 August 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, 6-hour, 38-minute period from Sunday, 25 July 2021 at 11:07 UTC to Thursday, 05 August 2021 at 17:46 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 : 36
Unique Edges : 32
Edges With Duplicates : 35
Total Edges : 67
Number of Edge Types : 5
Mentions : 17
Tweet : 4
Replies to : 4
Retweet : 15
MentionsInRetweet : 27
Self-Loops : 4
Reciprocated Vertex Pair Ratio : 0.0731707317073171
Reciprocated Edge Ratio : 0.136363636363636
Connected Components : 9
Single-Vertex Connected Components : 1
Maximum Vertices in a Connected Component : 12
Maximum Edges in a Connected Component : 33
Maximum Geodesic Distance (Diameter) : 4
Average Geodesic Distance : 1.472441
Graph Density : 0.0349206349206349
Modularity : 0.517209
NodeXL Version : 1.0.1.445
Data Import : The graph represents a network of 36 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, 08 August 2021 at 05:19 UTC.

The requested start date was Sunday, 08 August 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, 6-hour, 38-minute period from Sunday, 25 July 2021 at 11:07 UTC to Thursday, 05 August 2021 at 17:46 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://dataontheroad.blog/
[1] https://www.meetup.com/GLASS-Greater-Lansing-Area-for-SQL-Server/events/279932907/
[1] https://michaeljswart.com/2021/08/what-to-avoid-if-you-want-to-use-merge/
[1] https://sqlperformance.com/2021/07/sql-performance/dbcc-object-metadata-latch
[1] https://sessionize.com/PASSMNDATASATURDAY2021
[1] https://sqlespresso.com/2021/01/19/storage-tiers-what-sql-server-dbas-need-to-know/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2019/10/16/the-fast-number_rows-query-hint/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://www.youtube.com/watch?v=ZYhAGJ8nzCs

[1] https://www.youtube.com/watch?v=FGVN7qGNLU8&feature=youtu.be

[1] https://www.linkedin.com/posts/philipp-lenz1_sqlpass-activity-6825827858997362688-LjV6

Top URLs in Tweet in G1:
[1] https://www.youtube.com/watch?v=FGVN7qGNLU8&feature=youtu.be

[1] https://www.youtube.com/watch?v=-JhMVPKMhco&feature=youtu.be


Top URLs in Tweet in G2:
[1] https://www.linkedin.com/posts/philipp-lenz1_sqlpass-activity-6825827858997362688-LjV6
[1] https://www.sqlpass.de/events/warum-man-abfragen-nicht-mit-variablen-testet/
[1] https://twitter.com/seekandd3stroy/status/1364931389305597952

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

[1] https://passdatacommunitysummit.com/best-of-summit-2020?utm_source=twitter&utm_medium=social&utm_campaign=BestofSummit

Top URLs in Tweet in G4:
[1] https://www.meetup.com/GLASS-Greater-Lansing-Area-for-SQL-Server/events/279932907/

Top URLs in Tweet in G5:
[1] https://michaeljswart.com/2021/08/what-to-avoid-if-you-want-to-use-merge/
[1] https://sqlperformance.com/2021/07/sql-performance/dbcc-object-metadata-latch

Top URLs in Tweet in G6:
[1] https://sessionize.com/PASSMNDATASATURDAY2021

Top URLs in Tweet in G8:
[2] https://dataontheroad.blog/

Top URLs in Tweet in G9:
[1] https://sqlespresso.com/2021/01/19/storage-tiers-what-sql-server-dbas-need-to-know/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2019/10/16/the-fast-number_rows-query-hint/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost

Top Domains
Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[14] sqlpass
[4] sqlserver
[4] passdatacommunitysummit
[3] bestofsummit2020
[2] sqlblog
[2] passsummit
[2] mvpbuzz
[2] community
[1] azuredatacommunity
[1] meetup



Top Hashtags in Tweet in G1:
[2] sqlpass
[2] mvpbuzz
[1] powerbi
[1] powerautomate

Top Hashtags in Tweet in G2:
[2] community
[2] sqlpass
[1] tree
[1] carbonfootprint
[1] communityrocks
[1] communities4future
[1] oneeventonetree
[1] sustainability
[1] greenit

Top Hashtags in Tweet in G3:
[4] passdatacommunitysummit
[3] bestofsummit2020
[2] passsummit
[2] sqlpass
[1] datascience
[1] bigdata
[1] sqlserver

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

Top Hashtags in Tweet in G5:
[2] sqlpass

Top Hashtags in Tweet in G6:
[1] datasaturday
[1] sqlpass

Top Hashtags in Tweet in G7:
[1] sqlpass

Top Hashtags in Tweet in G8:
[1] oregonsql
[1] oregondc
[1] 3cloud
[1] sqlfriends
[1] sqlpass
[1] sqlsaturday
[1] wit

Top Hashtags in Tweet in G9:
[2] sqlserver
[2] sqlblog
[2] sqlpass

Top Words
Top Words in Tweet in Entire Graph:
[22] power
[14] #sqlpass
[12] published
[12] fabulous
[11] bi
[11] automate
[11] better
[11] together
[11] yesterday
[11] thesqlgrrrl

Top Words in Tweet in G1:
[22] power
[12] published
[12] fabulous
[11] bi
[11] automate
[11] better
[11] together
[11] yesterday
[11] thesqlgrrrl
[11] go

Top Words in Tweet in G2:
[4] sqlpass_de
[2] communities4f
[2] lenz_philipp
[2] online
[2] #community
[2] #sqlpass
[2] flowerandspice_

Top Words in Tweet in G3:
[6] session
[4] passdatasummit
[4] conference
[4] #passdatacommunitysummit
[3] meet
[3] pre
[3] speakers
[3] thestephlocke
[3] discusses
[3] watch

Top Words in Tweet in G5:
[2] canadian
[2] blogger
[2] #sqlpass

Top Words in Tweet in G8:
[2] inspiring
[2] stories
[2] jessica
[2] aguilar
[2] mike
[2] wall
[2] oregon
[2] data
[2] community
[2] 3cloud

Top Words in Tweet in G9:
[2] blog
[2] archive
[2] #sqlserver
[2] #sqlblog
[2] #sqlpass

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[11] published,power
[11] power,bi
[11] bi,power
[11] power,automate
[11] automate,better
[11] better,together
[11] together,yesterday
[11] yesterday,fabulous
[11] fabulous,thesqlgrrrl
[11] thesqlgrrrl,go

Top Word Pairs in Tweet in G1:
[11] published,power
[11] power,bi
[11] bi,power
[11] power,automate
[11] automate,better
[11] better,together
[11] together,yesterday
[11] yesterday,fabulous
[11] fabulous,thesqlgrrrl
[11] thesqlgrrrl,go

Top Word Pairs in Tweet in G2:
[2] sqlpass_de,flowerandspice_

Top Word Pairs in Tweet in G3:
[3] meet,pre
[3] pre,conference
[3] conference,speakers
[3] speakers,thestephlocke
[3] thestephlocke,discusses
[3] discusses,#passdatacommunitysummit
[3] #passdatacommunitysummit,session
[3] watch,sqlbob's
[3] sqlbob's,#bestofsummit2020
[3] #bestofsummit2020,session

Top Word Pairs in Tweet in G5:
[2] canadian,blogger

Top Word Pairs in Tweet in G8:
[2] inspiring,stories
[2] stories,jessica
[2] jessica,aguilar
[2] aguilar,mike
[2] mike,wall
[2] wall,oregon
[2] oregon,data
[2] data,community
[2] community,3cloud
[2] 3cloud,first

Top Word Pairs in Tweet in G9:
[2] blog,archive
[2] #sqlserver,#sqlblog
[2] #sqlblog,#sqlpass

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@thesqlgrrrl
@hybridvug
@passdatasummit
@sqlpass_de
@thestephlocke
@sqlbob
@communities4f
@flowerandspice_
@tgrohser
@mjswart

Top Mentioned in G1:
@thesqlgrrrl
@hybridvug
@azure_synapse
@jasonhorner

Top Mentioned in G2:
@sqlpass_de
@communities4f
@flowerandspice_
@lenz_philipp

Top Mentioned in G3:
@passdatasummit
@thestephlocke
@sqlbob

Top Mentioned in G4:
@tgrohser

Top Mentioned in G5:
@mjswart

Top Mentioned in G6:
@passmn

Top Mentioned in G8:
@paul_turley

Top Tweeters
Top Tweeters in Entire Graph:
@chidambara09
@andyleonard
@synstalker
@ssharwood
@shih_wei
@retracement
@jasonhorner
@powerplatfrmbot
@vegasazure
@sqlbob

Top Tweeters in G1:
@retracement
@jasonhorner
@powerplatfrmbot
@vegasazure
@larisasteig
@casaaacarlos
@thesqlgrrrl
@warren81340786
@claudia60061150
@gururaj67400847

Top Tweeters in G2:
@synstalker
@papariedel
@lenz_philipp
@sqlpass_de
@flowerandspice_
@mamacodet
@seekandd3stroy
@communities4f

Top Tweeters in G3:
@chidambara09
@andyleonard
@sqlbob
@thestephlocke
@passdatasummit

Top Tweeters in G4:
@glassusergroup
@tgrohser

Top Tweeters in G5:
@mjswart
@pass_rm_canada

Top Tweeters in G6:
@sqlworldwide
@passmn

Top Tweeters in G7:
@ssharwood
@shih_wei

Top Tweeters in G8:
@paul_turley
@briangrantbi

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