sqlpass, Twitter, 5/16/2021 9:11:01 AM, 254866


FAQ | Problem?

sqlpass_2021-05-15_22-18-00.xlsx
sqlpass_2021-05-15_22-18-00.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
May 16, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/3owvmPT
@passdatasummit
@redgate
@mehrenmueller
@datacommunityat
@sqlswimmer
@retracement
@sqlpass_de
@bob_duffy
@datamonsterben
@pshore73

Top hashtags:
#sqlpass
#powerbi
#datacommunityat
#dbcc2021
#tsql
#devops
#mvpbuzz
#sqlpass_de

Description:
Description
The graph represents a network of 83 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, 16 May 2021 at 05:18 UTC.

The requested start date was Sunday, 16 May 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, 7-hour, 48-minute period from Monday, 03 May 2021 at 09:27 UTC to Friday, 14 May 2021 at 17:15 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 : 83
Unique Edges : 28
Edges With Duplicates : 161
Total Edges : 189
Number of Edge Types : 4
Retweet : 75
MentionsInRetweet : 88
Tweet : 16
Mentions : 10
Self-Loops : 16
Reciprocated Vertex Pair Ratio : 0.0449438202247191
Reciprocated Edge Ratio : 0.0860215053763441
Connected Components : 10
Single-Vertex Connected Components : 6
Maximum Vertices in a Connected Component : 58
Maximum Edges in a Connected Component : 138
Maximum Geodesic Distance (Diameter) : 5
Average Geodesic Distance : 2.421112
Graph Density : 0.0136644137525713
Modularity : 0.406372
NodeXL Version : 1.0.1.445
Data Import : The graph represents a network of 83 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, 16 May 2021 at 05:18 UTC.

The requested start date was Sunday, 16 May 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, 7-hour, 48-minute period from Monday, 03 May 2021 at 09:27 UTC to Friday, 14 May 2021 at 17:15 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.youtube.com/c/DataCommunityAustria
[2] https://www.sqlpass.de/dbcc-2021-die-data-blaster-community-conference/
[2] https://pass.org/
[2] https://www.meetup.com/hybrid-virtual-group/events/277550090/
[2] https://blog.sqlauthority.com/2021/04/15/neutralize-troublesome-sql-server-indexes-fun-stories-demos-video/
[1] https://twitter.com/sqlpass_de/status/1393233395371622401
[1] https://sqlusergroupaustria.wordpress.com/2021/05/12/data-community-austria-meeting-mai/
[1] https://www.google.com/sorry/index?continue=https://www.youtube.com/watch%3Fv%3DHXTK6A9oLwQ&q=EgS4SO-bGIvWgoUGIhDO-h2eFmmsdiKI_yzBh5HjMgFy
[1] https://www.meetup.com/hybrid-virtual-group/events/277548597/
[1] https://www.google.com/sorry/index?continue=https://www.youtube.com/watch%3Fv%3DIzElqE4-mJU%26t%3D142s&q=EgS4SO-bGIzWgoUGIhB4kIIauHQXoD985OcOLQr5MgFy

Top URLs in Tweet in G1:
[1] https://pass.org/

Top URLs in Tweet in G2:
[1] https://pass.org/

Top URLs in Tweet in G3:
[2] https://www.meetup.com/hybrid-virtual-group/events/277550090/
[1] https://www.google.com/sorry/index?continue=https://www.youtube.com/watch%3Fv%3DHXTK6A9oLwQ&q=EgS4SO-bGIvWgoUGIhDO-h2eFmmsdiKI_yzBh5HjMgFy
[1] https://www.google.com/sorry/index?continue=https://www.youtube.com/watch%3Fv%3DIzElqE4-mJU%26t%3D142s&q=EgS4SO-bGIzWgoUGIhB4kIIauHQXoD985OcOLQr5MgFy
[1] https://www.meetup.com/hybrid-virtual-group/events/277548597/

Top URLs in Tweet in G4:
[4] https://www.youtube.com/c/DataCommunityAustria
[1] https://sqlusergroupaustria.wordpress.com/2021/05/12/data-community-austria-meeting-mai/

Top URLs in Tweet in G5:
[2] https://blog.sqlauthority.com/2021/04/15/neutralize-troublesome-sql-server-indexes-fun-stories-demos-video/
[1] https://sqlespresso.com/2019/01/23/scheduling-things-to-run-in-sql-server/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2021/02/24/identifying-sql-server-performance-problems-part-3/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlperformance.com/2021/05/t-sql-queries/number-series-solutions-5
[1] https://sqlperformance.com/2021/05/sql-performance/introduction-to-latches
[1] https://sqlperformance.com/2021/05/sql-performance/parallel-plans-start-4
[1] https://twitter.com/TorstenStrauss/status/1392538507684585472
[1] https://twitter.com/sqlpass_de/status/1393233395371622401
[1] https://www.sqlpass.de/dbcc-2021-die-data-blaster-community-conference/

Top URLs in Tweet in G6:
[1] https://www.sqlpass.de/dbcc-2021-die-data-blaster-community-conference/

Top URLs in Tweet in G7:
[1] https://sqlswimmer.com/2021/05/08/data-saturday-8-southwest-us/
[1] https://sqlswimmer.com/2021/05/08/data-weekender-v3-1/

Top Domains
Top Domains in Tweet in Entire Graph:
[4] youtube.com
[3] meetup.com
[3] sqlperformance.com
[2] sqlpass.de
[2] twitter.com
[2] pass.org
[2] google.com
[2] sqlespresso.com
[2] sqlauthority.com
[2] sqlswimmer.com

Top Domains in Tweet in G1:
[1] pass.org

Top Domains in Tweet in G2:
[1] pass.org

Top Domains in Tweet in G3:
[3] meetup.com
[2] google.com

Top Domains in Tweet in G4:
[4] youtube.com
[1] wordpress.com

Top Domains in Tweet in G5:
[3] sqlperformance.com
[2] sqlauthority.com
[2] sqlespresso.com
[2] twitter.com
[1] sqlpass.de

Top Domains in Tweet in G6:
[1] sqlpass.de

Top Domains in Tweet in G7:
[2] sqlswimmer.com

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[18] sqlpass
[8] powerbi
[7] datacommunityat
[6] dbcc2021
[6] tsql
[6] devops
[5] mvpbuzz
[4] sqlpass_de
[4] sqlfamily
[2] sqlpass_at



Top Hashtags in Tweet in G1:
[1] passsummit
[1] sqlpass
[1] sqlfamily

Top Hashtags in Tweet in G2:
[1] passsummit
[1] sqlpass
[1] sqlfamily

Top Hashtags in Tweet in G3:
[8] powerbi
[7] sqlpass
[6] devops
[5] mvpbuzz

Top Hashtags in Tweet in G4:
[7] datacommunityat
[6] tsql
[2] sqlpass_at
[1] power
[1] sqlpass_de

Top Hashtags in Tweet in G5:
[5] sqlpass
[2] sqlserver
[2] sqlblog
[2] sqlpass_de
[1] dataplatform
[1] community
[1] dbcc2021

Top Hashtags in Tweet in G6:
[5] dbcc2021
[1] sqlpass_de

Top Hashtags in Tweet in G7:
[2] sqlpass

Top Hashtags in Tweet in G8:
[2] sqlfamily
[2] sqlpass
[1] azuredatacommunity

Top Words
Top Words in Tweet in Entire Graph:
[60] data
[55] announcement
[55] ve
[55] waiting
[55] finally
[55] introducing
[55] pass
[55] community
[55] summit
[55] head

Top Words in Tweet in G1:
[34] announcement
[34] ve
[34] waiting
[34] finally
[34] introducing
[34] pass
[34] data
[34] community
[34] summit
[34] head

Top Words in Tweet in G2:
[19] announcement
[19] ve
[19] waiting
[19] finally
[19] introducing
[19] pass
[19] data
[19] community
[19] summit
[19] head

Top Words in Tweet in G3:
[10] bi
[8] #powerbi
[8] power
[8] retracement
[7] #sqlpass
[6] bob_duffy
[6] next
[6] #devops
[5] interested
[5] #mvpbuzz

Top Words in Tweet in G4:
[8] datacommunityat
[7] #datacommunityat
[6] nächste
[6] woche
[6] mittwoch
[6] 19
[6] mai
[6] meeting
[6] datamonsterben
[6] mehrenmueller

Top Words in Tweet in G5:
[5] #sqlpass
[3] performance
[3] part
[3] canadian
[3] blogger
[3] sqlperformance
[2] lots
[2] people
[2] ask
[2] creating

Top Words in Tweet in G6:
[6] die
[5] freuen
[5] #dbcc2021
[5] 20
[5] 05
[5] 2021
[5] tagen
[5] soweit
[5] neuen
[5] deutschsprachigen

Top Words in Tweet in G7:
[3] data
[2] member
[2] blog
[2] sqlswimmer
[2] #sqlpass

Top Words in Tweet in G8:
[2] thank
[2] helping
[2] spreading
[2] word
[2] virtual
[2] group
[2] crossed
[2] 2k
[2] membership
[2] #sqlfamily

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[55] announcement,ve
[55] ve,waiting
[55] waiting,finally
[55] finally,introducing
[55] introducing,pass
[55] pass,data
[55] data,community
[55] community,summit
[55] summit,head
[55] head,over

Top Word Pairs in Tweet in G1:
[34] announcement,ve
[34] ve,waiting
[34] waiting,finally
[34] finally,introducing
[34] introducing,pass
[34] pass,data
[34] data,community
[34] community,summit
[34] summit,head
[34] head,over

Top Word Pairs in Tweet in G2:
[19] announcement,ve
[19] ve,waiting
[19] waiting,finally
[19] finally,introducing
[19] introducing,pass
[19] pass,data
[19] data,community
[19] community,summit
[19] summit,head
[19] head,over

Top Word Pairs in Tweet in G3:
[8] power,bi
[6] #powerbi,#devops
[5] #devops,enterprise
[5] super,happy
[5] happy,announce
[5] announce,recording
[5] recording,learn
[5] learn,power
[5] bi,activity
[5] activity,log

Top Word Pairs in Tweet in G4:
[6] nächste,woche
[6] woche,mittwoch
[6] mittwoch,19
[6] 19,mai
[6] mai,#datacommunityat
[6] #datacommunityat,meeting
[6] meeting,datamonsterben
[6] datamonsterben,mehrenmueller
[6] mehrenmueller,gt
[6] gt,#tsql

Top Word Pairs in Tweet in G5:
[3] canadian,blogger
[3] blogger,sqlperformance
[2] lots,people
[2] people,ask
[2] ask,creating
[2] creating,long
[2] long,videos
[2] videos,well
[2] well,clients
[2] clients,comprehensive

Top Word Pairs in Tweet in G6:
[5] freuen,die
[5] die,#dbcc2021
[5] #dbcc2021,20
[5] 20,05
[5] 05,2021
[5] 2021,tagen
[5] tagen,soweit
[5] soweit,neuen
[5] neuen,deutschsprachigen
[5] deutschsprachigen,ausgabe

Top Word Pairs in Tweet in G7:
[2] member,blog
[2] blog,sqlswimmer
[2] sqlswimmer,data

Top Word Pairs in Tweet in G8:
[2] thank,helping
[2] helping,spreading
[2] spreading,word
[2] word,virtual
[2] virtual,group
[2] group,crossed
[2] crossed,2k
[2] 2k,membership
[2] membership,#sqlfamily
[2] #sqlfamily,#sqlpass

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@passdatasummit
@redgate
@datacommunityat
@retracement
@datamonsterben
@mehrenmueller
@bob_duffy
@sqlpass_de
@r1k91
@sqlswimmer

Top Mentioned in G1:
@passdatasummit
@redgate

Top Mentioned in G2:
@redgate
@passdatasummit

Top Mentioned in G3:
@retracement
@bob_duffy
@r1k91
@datarelay_uk
@sqlchick
@hybridvug

Top Mentioned in G4:
@datacommunityat
@datamonsterben
@mehrenmueller
@tsql_ninja
@passdatasummit

Top Mentioned in G6:
@sqlpass_de

Top Mentioned in G7:
@sqlswimmer
@passdatasummit

Top Mentioned in G8:
@dbavug

Top Tweeters
Top Tweeters in Entire Graph:
@dataaugmented
@gfritchey
@intoleranse
@pinaldave
@theconstructor
@sqlgator
@sqldba
@klunkysql
@realrubberduck1
@retracement

Top Tweeters in G1:
@gfritchey
@sqlgator
@sqldba
@klunkysql
@nikoneugebauer
@derfredo
@kendra_little
@sqlbek
@sqlmct
@tim_mitchell

Top Tweeters in G2:
@pshore73
@ko_ver
@yatessql
@redgate
@_alexyates_
@thestephlocke
@toddkleinhans
@peterdanielsco
@ladyruna
@mbourgon

Top Tweeters in G3:
@dataaugmented
@intoleranse
@realrubberduck1
@retracement
@gauteweb
@sqlchick
@datarelay_uk
@ianpike
@bob_duffy
@mikehubrecht

Top Tweeters in G4:
@wstrasser
@frankgeisler
@mehrenmueller
@datamozart
@datamonsterben
@linearisbi
@tsql_ninja
@datacommunityat

Top Tweeters in G5:
@pinaldave
@sqlespresso
@dirkhondong
@kostjaklein
@pass_rm_canada
@tkansy

Top Tweeters in G6:
@theconstructor
@bweissman
@brainbug23
@mkepert
@sqlpass_de

Top Tweeters in G7:
@sqlswimmer
@triadsql

Top Tweeters in G8:
@irishsql
@dbavug


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.