sqlpass, Twitter, 6/6/2021 6:45:19 AM, 256414


FAQ | Problem?

sqlpass_2021-06-05_22-18-00.xlsx
sqlpass_2021-06-05_22-18-00.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
June 06, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/3uY3kOF
@passdatasummit
@redgate
@volkerbachmann
@dbanuggets
@retracement
@datasaturdays
@wstrasser
@sqlmisssunshine
@dbberater
@thesmilingdba

Top hashtags:
#sqlpass
#passdatacommunitysummit
#azuredata
#sqlserver
#powerbi
#sqlfamily

Description:
Description
The graph represents a network of 74 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, 06 June 2021 at 05:18 UTC.

The requested start date was Sunday, 06 June 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, 10-minute period from Monday, 24 May 2021 at 14:57 UTC to Friday, 04 June 2021 at 21:08 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 : 74
Unique Edges : 36
Edges With Duplicates : 150
Total Edges : 186
Number of Edge Types : 4
Retweet : 69
MentionsInRetweet : 85
Tweet : 16
Mentions : 16
Self-Loops : 16
Reciprocated Vertex Pair Ratio : 0.043956043956044
Reciprocated Edge Ratio : 0.0842105263157895
Connected Components : 6
Single-Vertex Connected Components : 1
Maximum Vertices in a Connected Component : 56
Maximum Edges in a Connected Component : 161
Maximum Geodesic Distance (Diameter) : 6
Average Geodesic Distance : 2.929857
Graph Density : 0.0175860792299148
Modularity : 0.415677
NodeXL Version : 1.0.1.445
Data Import : The graph represents a network of 74 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, 06 June 2021 at 05:18 UTC.

The requested start date was Sunday, 06 June 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, 10-minute period from Monday, 24 May 2021 at 14:57 UTC to Friday, 04 June 2021 at 21:08 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:
[11] https://datasaturdays.com/
[4] https://passdatacommunitysummit.com/speakers
[2] https://sqlespresso.com/2021/02/03/mastering-tempdb-the-basics/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[2] https://www.meetup.com/hybrid-virtual-group/events/278144930/
[2] https://www.youtube.com/channel/UCKDL2mjJcn5Kxv2-Tm5C_FQ
[1] https://sqlespresso.com/2018/10/24/keeping-large-table-statistics-current/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2020/01/15/memory-optimizer-advisor/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://www.youtube.com/watch?v=FTq1SBNDxsY

[1] https://twitter.com/bweissman/status/1399629499906641923
[1] https://www.meetup.com/GLASS-Greater-Lansing-Area-for-SQL-Server/events/277836881/

Top URLs in Tweet in G1:
[1] https://passdatacommunitysummit.com/speakers?utm_source=twitter&utm_medium=social&utm_campaign=CFS_Launch
[1] https://passdatacommunitysummit.com
[1] https://www.linkedin.com/showcase/pass-data-community-summit/
[1] https://passdatacommunitysummit.com/
[1] https://passdatacommunitysummit.com/speakers

Top URLs in Tweet in G2:
[11] https://datasaturdays.com/

Top URLs in Tweet in G3:
[3] https://passdatacommunitysummit.com/speakers
[1] https://assets.red-gate.com/hub/pass/pass-community-insights-infographic.pdf
[1] https://pass.org/

Top URLs in Tweet in G4:
[2] https://sqlespresso.com/2021/02/03/mastering-tempdb-the-basics/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[2] https://www.meetup.com/hybrid-virtual-group/events/278144930/
[1] https://sqlespresso.com/2020/01/15/memory-optimizer-advisor/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2018/10/24/keeping-large-table-statistics-current/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://www.youtube.com/watch?v=FTq1SBNDxsY

[1] https://www.youtube.com/c/HybridVirtualGroup/videos

Top URLs in Tweet in G5:
[1] https://twitter.com/bweissman/status/1399629499906641923

Top URLs in Tweet in G6:
[2] https://www.youtube.com/channel/UCKDL2mjJcn5Kxv2-Tm5C_FQ
[1] https://twitter.com/SQL_aus_HH/status/1397436444457701376

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

Top URLs in Tweet in G9:
[1] https://blog.sqlauthority.com/2021/04/15/neutralize-troublesome-sql-server-indexes-fun-stories-demos-video/

Top Domains
Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[32] sqlpass
[24] passdatacommunitysummit
[11] azuredata
[8] sqlserver
[8] powerbi
[8] sqlfamily
[8] passsummit
[5] mvpbuzz
[5] sqlpass_de
[4] sqlblog



Top Hashtags in Tweet in G1:
[16] passdatacommunitysummit
[5] passsummit
[5] sqlpass
[3] sqlfamily
[1] microsoft

Top Hashtags in Tweet in G2:
[12] sqlpass
[11] azuredata
[2] data
[2] passdatacommunitysummit
[1] passsummit
[1] community
[1] sqlfamily
[1] sqlserver
[1] learning

Top Hashtags in Tweet in G3:
[5] passdatacommunitysummit
[3] passsummit2021
[2] sqlpass
[1] passsummit
[1] sqlfamily
[1] sqlsaturday

Top Hashtags in Tweet in G4:
[10] sqlpass
[8] powerbi
[5] mvpbuzz
[4] sqlserver
[4] sqlblog
[1] passdatacommunitysummit
[1] hybridvug

Top Hashtags in Tweet in G5:
[3] sqlpass_de
[3] sqlfamily
[1] sqlpass

Top Hashtags in Tweet in G6:
[2] dbcc2021
[2] sqlpass_de
[1] youtube
[1] recordings
[1] dataplatform
[1] community
[1] germany
[1] sqlserver

Top Hashtags in Tweet in G7:
[2] sqlserver
[1] azuredatacommunity
[1] sqlpass

Top Hashtags in Tweet in G8:
[1] sqlpass
[1] passsummit

Top Words
Top Words in Tweet in Entire Graph:
[36] community
[32] #sqlpass
[30] passdatasummit
[29] session
[28] data
[24] #passdatacommunitysummit
[22] pass
[21] speakers
[20] icymi
[18] submitted

Top Words in Tweet in G1:
[22] passdatasummit
[16] #passdatacommunitysummit
[15] data
[14] speakers
[13] submitted
[13] abstract
[13] miss
[13] chance
[13] present
[13] session

Top Words in Tweet in G2:
[13] community
[12] #sqlpass
[11] #azuredata
[11] know
[10] datasaturdays
[10] âš
[10] hurry
[9] wstrasser
[9] looâ
[4] session

Top Words in Tweet in G3:
[10] redgate
[7] icymi
[7] finally
[7] introducing
[7] pass
[7] data
[7] community
[7] summit
[7] check
[7] website

Top Words in Tweet in G4:
[10] #sqlpass
[9] session
[8] retracement
[8] made
[8] #powerbi
[8] ma
[6] recording
[6] sqlmisssunshine
[6] presented
[6] modeling

Top Words in Tweet in G5:
[3] #sqlpass_de
[3] #sqlfamily
[2] sqlfabrik

Top Words in Tweet in G6:
[6] videos
[5] sqlpass_de
[5] youtube
[5] kanal
[5] wieder
[5] neue
[5] unserer
[5] virtuellen
[5] regionalgruppentreffen
[5] verã

Top Words in Tweet in G7:
[2] join
[2] thursday
[2] june
[2] 10
[2] 30
[2] sqlrv
[2] speaks
[2] practical
[2] guide
[2] set

Top Words in Tweet in G8:
[2] seems
[2] weird
[2] community
[2] conference
[2] run
[2] single
[2] software
[2] vendor
[2] data
[2] professionals

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[22] pass,data
[22] data,community
[18] submitted,#passdatacommunitysummit
[18] #passdatacommunitysummit,abstract
[18] miss,chance
[18] chance,present
[18] present,session
[18] call,speakers
[17] passdatasummit,submitted
[13] abstract,donâ

Top Word Pairs in Tweet in G1:
[13] submitted,#passdatacommunitysummit
[13] #passdatacommunitysummit,abstract
[13] miss,chance
[13] chance,present
[13] present,session
[13] call,speakers
[13] pass,data
[13] data,community
[12] passdatasummit,submitted
[11] abstract,donâ

Top Word Pairs in Tweet in G2:
[10] #azuredata,#sqlpass
[10] #sqlpass,community
[10] community,know
[10] know,datasaturdays
[10] datasaturdays,âš
[10] âš,hurry
[9] wstrasser,#azuredata
[9] hurry,looâ
[2] redgate,feedback
[2] feedback,gift

Top Word Pairs in Tweet in G3:
[7] icymi,finally
[7] finally,introducing
[7] introducing,pass
[7] pass,data
[7] data,community
[7] community,summit
[7] summit,check
[7] check,website
[7] website,save
[7] save,date

Top Word Pairs in Tweet in G4:
[6] recording,made
[6] made,sqlmisssunshine
[6] sqlmisssunshine,presented
[6] presented,modeling
[6] modeling,#powerbi
[6] #powerbi,live
[6] live,fabulous
[5] retracement,recording
[5] fabulous,sess
[4] blog,archive

Top Word Pairs in Tweet in G6:
[5] youtube,kanal
[5] kanal,wieder
[5] wieder,neue
[5] neue,videos
[5] videos,unserer
[5] unserer,virtuellen
[5] virtuellen,regionalgruppentreffen
[5] regionalgruppentreffen,verã
[5] verã,ffentlicht
[5] ffentlicht,schau

Top Word Pairs in Tweet in G7:
[2] join,thursday
[2] thursday,june
[2] june,10
[2] 10,30
[2] 30,sqlrv
[2] sqlrv,speaks
[2] speaks,practical
[2] practical,guide
[2] guide,set
[2] set,based

Top Word Pairs in Tweet in G8:
[2] seems,weird
[2] weird,community
[2] community,conference
[2] conference,run
[2] run,single
[2] single,software
[2] software,vendor
[2] vendor,data
[2] data,professionals
[2] professionals,speak

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@passdatasummit
@redgate
@datasaturdays
@wstrasser
@retracement
@sqlmisssunshine
@purplefrogalex
@sqlpass_de
@sqlfabrik
@sqlrv

Top Mentioned in G1:
@passdatasummit
@redgate

Top Mentioned in G2:
@datasaturdays
@wstrasser
@redgate
@passdatasummit
@paulswengrr
@dbanuggets

Top Mentioned in G3:
@redgate
@passdatasummit
@thesmilingdba
@sqlpass

Top Mentioned in G4:
@retracement
@sqlmisssunshine
@purplefrogalex
@sqlespresso
@redgate
@passdatasummit

Top Mentioned in G5:
@sqlfabrik
@bweissman
@sqlatspeed
@sqljen

Top Mentioned in G6:
@sqlpass_de

Top Mentioned in G7:
@sqlrv
@glassusergroup

Top Mentioned in G8:
@lawyersql

Top Tweeters
Top Tweeters in Entire Graph:
@dataaugmented
@datachick
@sql_handle
@intoleranse
@pinaldave
@theconstructor
@klunkysql
@retracement
@nikoneugebauer
@derfredo

Top Tweeters in G1:
@sql_handle
@sqlmal
@cathrinew
@sqlworldwide
@willvelida
@mrs_fatherjack
@steverezhener
@segovoni
@gavinclark66
@thehybriddba

Top Tweeters in G2:
@nikoneugebauer
@spaghettidba
@wstrasser
@andrekamman
@bidgeir
@jjuelke
@dbberater
@dbanuggets
@ta_rente
@paulswengrr

Top Tweeters in G3:
@intoleranse
@sqlpass
@yatessql
@redgate
@drsql
@sqlsuperguru
@thesmilingdba
@jebacanisqldude
@jen_redgate
@sqlfam

Top Tweeters in G4:
@dataaugmented
@klunkysql
@retracement
@desertislesql
@sqlespresso
@alzdba
@volkerbachmann
@purplefrogalex
@sqlmisssunshine
@hybridvug

Top Tweeters in G5:
@a_bansal
@bweissman
@dirkhondong
@sqlatspeed
@sqljen
@sqlfabrik

Top Tweeters in G6:
@theconstructor
@derfredo
@atholymardies
@kostjaklein
@brainbug23
@sqlpass_de

Top Tweeters in G7:
@irishsql
@sqlrv
@glassusergroup

Top Tweeters in G8:
@datachick
@lawyersql

Top Tweeters in G9:
@pinaldave


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.