sqlpass, Twitter, 9/11/2022 9:28:55 AM, 281704


FAQ | Problem?

sqlpass_2022-09-10_22-15-45.xlsx
sqlpass_2022-09-10_22-15-45.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
September 11, 2022
Short Description:
sqlpass via NodeXL https://bit.ly/3U4N78i
@dcacco
@sqlrus
@sqlespresso
@passdatasummit
@sqlmisssunshine
@solarwinds
@brainbug23
@oengels
@mrdenny
@torstenst

Top hashtags:
#sqlpass
#sqlserver
#azure
#cloud
#it
#infrastructure
#thekrewe
#speakeridol
#solarwinds

Description:
Description
The graph represents a network of 33 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, 11 September 2022 at 05:15 UTC.

The requested start date was Sunday, 11 September 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 13-day, 0-hour, 42-minute period from Sunday, 28 August 2022 at 14:09 UTC to Saturday, 10 September 2022 at 14:51 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 : 33
Unique Edges : 14
Edges With Duplicates : 234
Total Edges : 248
Number of Edge Types : 4
Retweet : 53
MentionsInRetweet : 68
Mentions : 122
Tweet : 5
Self-Loops : 5
Reciprocated Vertex Pair Ratio : 0.0238095238095238
Reciprocated Edge Ratio : 0.0465116279069767
Connected Components : 3
Single-Vertex Connected Components : 0
Maximum Vertices in a Connected Component : 24
Maximum Edges in a Connected Component : 235
Maximum Geodesic Distance (Diameter) : 4
Average Geodesic Distance : 2.050874
Graph Density : 0.040719696969697
Modularity : 0.112826
NodeXL Version : 1.0.1.504
Data Import : The graph represents a network of 33 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, 11 September 2022 at 05:15 UTC.

The requested start date was Sunday, 11 September 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 13-day, 0-hour, 42-minute period from Sunday, 28 August 2022 at 14:09 UTC to Saturday, 10 September 2022 at 14:51 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:
[55] https://www.dcac.com/blog/azure-infrastructure-precon-at-pass-summit-2022/
[26] https://www.dcac.com/blog/pass-data-platform-summit-2022-sql-karaoke-party/
[22] https://twitter.com/DCACco/status/1560327838133354496
[4] https://www.dcac.com/blog/your-sqlpass-2022-speaker-idol-judges-are/
[2] https://twitter.com/DCACco/status/1565082120824963076/photo/1
[2] https://twitter.com/DCACco/status/1564428963698675712/photo/1
[2] https://twitter.com/DCACco/status/1568229493999022080/photo/1
[2] https://twitter.com/DCACco/status/1567618754724388866/photo/1
[2] https://twitter.com/DCACco/status/1567581725542195200/photo/1
[2] https://twitter.com/DCACco/status/1565716432838660096/photo/1

Top URLs in Tweet in G1:
[20] https://www.dcac.com/blog/azure-infrastructure-precon-at-pass-summit-2022/
[6] https://www.dcac.com/blog/pass-data-platform-summit-2022-sql-karaoke-party/
[6] https://twitter.com/DCACco/status/1560327838133354496
[1] https://www.dcac.com/blog/your-sqlpass-2022-speaker-idol-judges-are/

Top URLs in Tweet in G2:
[1] https://www.sqlpass.de/events/pass-rg-ruhrgebiet-tempdb-metadata-torsten-strauss/

Top URLs in Tweet in G3:
[13] https://www.dcac.com/blog/azure-infrastructure-precon-at-pass-summit-2022/
[8] https://twitter.com/DCACco/status/1560327838133354496
[7] https://www.dcac.com/blog/pass-data-platform-summit-2022-sql-karaoke-party/
[1] https://twitter.com/DCACco/status/1565082120824963076/photo/1
[1] https://twitter.com/DCACco/status/1564296076080959488/photo/1
[1] https://www.dcac.com/blog/your-sqlpass-2022-speaker-idol-judges-are/
[1] https://twitter.com/DCACco/status/1564306610188582917/photo/1
[1] https://twitter.com/DCACco/status/1564832105380679680/photo/1
[1] https://twitter.com/DCACco/status/1565045013905563648/photo/1
[1] https://twitter.com/DCACco/status/1565345488697667585/photo/1

Top URLs in Tweet in G4:
[12] https://www.dcac.com/blog/azure-infrastructure-precon-at-pass-summit-2022/
[7] https://www.dcac.com/blog/pass-data-platform-summit-2022-sql-karaoke-party/
[4] https://twitter.com/DCACco/status/1560327838133354496
[1] https://twitter.com/DCACco/status/1565082120824963076/photo/1
[1] https://sqlespresso.com/2019/05/15/dmvs-for-the-beginner/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://twitter.com/DCACco/status/1564296076080959488/photo/1
[1] https://www.dcac.com/blog/your-sqlpass-2022-speaker-idol-judges-are/
[1] https://twitter.com/DCACco/status/1564306610188582917/photo/1
[1] https://twitter.com/DCACco/status/1564832105380679680/photo/1
[1] https://twitter.com/DCACco/status/1565045013905563648/photo/1

Top URLs in Tweet in G5:
[10] https://www.dcac.com/blog/azure-infrastructure-precon-at-pass-summit-2022/
[6] https://www.dcac.com/blog/pass-data-platform-summit-2022-sql-karaoke-party/
[4] https://twitter.com/DCACco/status/1560327838133354496
[1] https://www.dcac.com/blog/your-sqlpass-2022-speaker-idol-judges-are/
[1] https://www.dcac.com/pass/speaker-idol-is-back-at-sqlpass-for-2022/

Top URLs in Tweet in G6:
[1] https://michaeljswart.com/2022/09/this-function-generates-unpivot-syntax/
[1] https://sqlperformance.com/2022/09/sql-performance/lock-escalation-threshold-part-1

Top Domains
Top Domains in Tweet in Entire Graph:
[86] dcac.com
[65] twitter.com
[3] sqlespresso.com
[1] sqlpass.de
[1] michaeljswart.com
[1] sqlperformance.com

Top Domains in Tweet in G1:
[27] dcac.com
[6] twitter.com

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

Top Domains in Tweet in G3:
[30] twitter.com
[21] dcac.com

Top Domains in Tweet in G4:
[25] twitter.com
[20] dcac.com
[3] sqlespresso.com

Top Domains in Tweet in G5:
[18] dcac.com
[4] twitter.com

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

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[110] sqlpass
[102] sqlserver
[58] azure
[45] cloud
[42] it
[33] infrastructure
[19] thekrewe
[13] speakeridol
[10] solarwinds
[9] azuresql



Top Hashtags in Tweet in G1:
[33] sqlpass
[32] sqlserver
[21] azure
[18] cloud
[17] it
[13] infrastructure
[6] thekrewe
[4] speakeridol
[3] azuresql
[3] solarwinds

Top Hashtags in Tweet in G2:
[1] sqlpass
[1] sqlserver
[1] community

Top Hashtags in Tweet in G3:
[29] sqlserver
[29] sqlpass
[14] azure
[10] it
[10] cloud
[7] infrastructure
[7] thekrewe
[4] speakeridol
[4] solarwinds
[3] azuresql

Top Hashtags in Tweet in G4:
[28] sqlpass
[26] sqlserver
[13] azure
[10] it
[10] cloud
[7] infrastructure
[6] thekrewe
[4] speakeridol
[3] sqlblog
[3] azuresql

Top Hashtags in Tweet in G5:
[17] sqlpass
[14] sqlserver
[10] azure
[7] cloud
[6] passdatacommunitysummit
[6] infrastructure
[5] it
[1] sql
[1] speakeridol

Top Hashtags in Tweet in G6:
[2] sqlpass

Top Words
Top Words in Tweet in Entire Graph:
[127] summit
[110] #sqlpass
[102] #sqlserver
[90] 2022
[87] pass
[86] dcacco
[59] denny
[59] passdatasummit
[58] #azure
[55] presenting

Top Words in Tweet in G1:
[40] summit
[33] #sqlpass
[32] #sqlserver
[28] 2022
[27] pass
[21] denny
[21] #azure
[20] presenting
[20] passdatasummit
[18] #cloud

Top Words in Tweet in G2:
[6] event
[5] finally
[5] pass
[5] germany
[5] rg
[5] ruhrgebiet
[5] planning
[5] first
[5] person
[5] ages

Top Words in Tweet in G3:
[36] summit
[29] dcacco
[29] #sqlserver
[29] #sqlpass
[23] pass
[23] 2022
[17] passdatasummit
[15] community
[14] denny
[14] #azure

Top Words in Tweet in G4:
[31] summit
[28] #sqlpass
[26] #sqlserver
[24] dcacco
[21] 2022
[20] pass
[17] passdatasummit
[14] data
[13] denny
[13] #azure

Top Words in Tweet in G5:
[21] dcacco
[20] summit
[18] 2022
[17] #sqlpass
[14] #sqlserver
[12] pass
[11] data
[11] community
[11] denny
[10] presenting

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

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[86] summit,2022
[55] denny,presenting
[50] pass,summit
[48] dcacco,denny
[45] pre,pass
[45] 2022,#sqlpass
[41] presenting,#azure
[37] #sqlserver,#cloud
[35] #sqlpass,#sqlserver
[35] #cloud,#it

Top Word Pairs in Tweet in G1:
[27] summit,2022
[20] denny,presenting
[18] pass,summit
[16] pre,pass
[16] 2022,#sqlpass
[15] presenting,#azure
[15] #sqlserver,#cloud
[15] #cloud,#it
[13] #sqlpass,#sqlserver
[12] #azure,#infrastructure

Top Word Pairs in Tweet in G2:
[5] finally,pass
[5] pass,germany
[5] germany,rg
[5] rg,ruhrgebiet
[5] ruhrgebiet,planning
[5] planning,first
[5] first,person
[5] person,event
[5] event,ages
[5] ages,starting

Top Word Pairs in Tweet in G3:
[22] summit,2022
[14] pass,summit
[14] dcacco,denny
[13] denny,presenting
[11] pre,pass
[11] 2022,#sqlpass
[10] presenting,#azure
[9] pass,data
[8] dcacco,speaker
[8] speaker,#sqlserver

Top Word Pairs in Tweet in G4:
[20] summit,2022
[13] dcacco,denny
[12] pass,summit
[12] denny,presenting
[10] pre,pass
[10] 2022,#sqlpass
[9] presenting,#azure
[8] pass,data
[8] #sqlserver,#cloud
[8] #cloud,#it

Top Word Pairs in Tweet in G5:
[17] summit,2022
[11] dcacco,denny
[10] denny,presenting
[8] pre,pass
[8] 2022,#sqlpass
[7] presenting,#azure
[6] data,community
[6] community,summit
[6] karaoke,party
[6] party,many

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

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@dcacco
@passdatasummit
@solarwinds
@sqlrus
@sqlmisssunshine
@sqlespresso
@torstenst
@pa

Top Mentioned in G1:
@passdatasummit
@dcacco
@solarwinds

Top Mentioned in G2:
@sqlmisssunshine
@torstenst
@torstenstrauss

Top Mentioned in G3:
@dcacco
@passdatasummit
@solarwinds
@sqlrus
@pa
@passdat

Top Mentioned in G4:
@dcacco
@passdatasummit
@solarwinds
@sqlespresso
@pas
@passdata

Top Mentioned in G5:
@dcacco
@solarwinds
@passdatasummit
@mrdenny

Top Mentioned in G6:
@mjswart

Top Tweeters
Top Tweeters in Entire Graph:
@sql_handle
@pa
@dbargenis
@readtechhere
@mrdenny
@savranweb
@way0utwest
@allenrevans
@crazyaboutcloud
@vegasazure

Top Tweeters in G1:
@allenrevans
@crazyaboutcloud
@vegasazure
@azuretweetbot
@sqlatspeed
@dcacco
@jphillips_data
@carolynmauney

Top Tweeters in G2:
@koprowskit
@derfredo
@brainbug23
@oengels
@sqlmisssunshine
@torstenstrauss
@torstenst

Top Tweeters in G3:
@pa
@readtechhere
@savranweb
@pshore73
@sqlrus
@passdat

Top Tweeters in G4:
@sql_handle
@way0utwest
@sqlespresso
@pas
@passdata

Top Tweeters in G5:
@dbargenis
@mrdenny
@solarwinds
@sqlworldwide
@passdatasummit

Top Tweeters in G6:
@mjswart
@pass_rm_canada