sqlpass, Twitter, 8/14/2022 8:49:21 AM, 280020


FAQ | Problem?

sqlpass_2022-08-13_22-15-45.xlsx
sqlpass_2022-08-13_22-15-45.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
August 14, 2022
Short Description:
sqlpass via NodeXL https://bit.ly/3Amu556
@dcacco
@sqlespresso
@sqlrus
@solarwinds
@mrdenny
@hannespreishub
@chwenz
@asp_net
@carolynmauney
@warwick_rudd

Top hashtags:
#sqlpass
#sqlserver
#azure
#cloud
#it
#thekrewe
#sqlblog

Description:
Description
The graph represents a network of 23 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, 14 August 2022 at 05:15 UTC.

The requested start date was Sunday, 14 August 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 12-day, 11-hour, 43-minute period from Monday, 01 August 2022 at 09:25 UTC to Saturday, 13 August 2022 at 21:09 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 : 23
Unique Edges : 12
Edges With Duplicates : 156
Total Edges : 168
Number of Edge Types : 5
Mentions : 57
Retweet : 39
MentionsInRetweet : 52
Replies to : 2
Tweet : 18
Self-Loops : 18
Reciprocated Vertex Pair Ratio : 0.03125
Reciprocated Edge Ratio : 0.0606060606060606
Connected Components : 4
Single-Vertex Connected Components : 1
Maximum Vertices in a Connected Component : 17
Maximum Edges in a Connected Component : 160
Maximum Geodesic Distance (Diameter) : 3
Average Geodesic Distance : 1.709571
Graph Density : 0.0652173913043478
Modularity : 0.138818
NodeXL Version : 1.0.1.502
Data Import : The graph represents a network of 23 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, 14 August 2022 at 05:15 UTC.

The requested start date was Sunday, 14 August 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 12-day, 11-hour, 43-minute period from Monday, 01 August 2022 at 09:25 UTC to Saturday, 13 August 2022 at 21:09 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:
[51] https://www.dcac.com/blog/azure-infrastructure-precon-at-pass-summit-2022/
[41] https://www.dcac.com/blog/pass-data-platform-summit-2022-sql-karaoke-party/
[2] https://twitter.com/DCACco/status/1554935295707070464/photo/1
[2] https://twitter.com/DCACco/status/1558082809700519936/photo/1
[2] https://twitter.com/DCACco/status/1557905967358124034/photo/1
[2] https://twitter.com/DCACco/status/1557434866924404736/photo/1
[2] https://twitter.com/DCACco/status/1557221962652467201/photo/1
[2] https://twitter.com/DCACco/status/1556685931343761408/photo/1
[2] https://sqlespresso.com/2017/08/30/system-versioned-temporal-tables/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[2] https://twitter.com/DCACco/status/1558106260800782336/photo/1

Top URLs in Tweet in G1:
[29] https://www.dcac.com/blog/azure-infrastructure-precon-at-pass-summit-2022/
[21] https://www.dcac.com/blog/pass-data-platform-summit-2022-sql-karaoke-party/
[1] https://twitter.com/DCACco/status/1554935295707070464/photo/1
[1] https://twitter.com/DCACco/status/1554149217018552320/photo/1
[1] https://twitter.com/DCACco/status/1554282093345210369/photo/1
[1] https://twitter.com/DCACco/status/1554488957160853506/photo/1
[1] https://twitter.com/DCACco/status/1554898149738700800/photo/1
[1] https://twitter.com/DCACco/status/1555198632659484674/photo/1
[1] https://twitter.com/DCACco/status/1555545917431943168/photo/1
[1] https://twitter.com/DCACco/status/1555569569900658688/photo/1

Top URLs in Tweet in G2:
[22] https://www.dcac.com/blog/azure-infrastructure-precon-at-pass-summit-2022/
[20] https://www.dcac.com/blog/pass-data-platform-summit-2022-sql-karaoke-party/
[2] https://sqlespresso.com/2017/08/30/system-versioned-temporal-tables/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://twitter.com/DCACco/status/1554935295707070464/photo/1
[1] https://twitter.com/DCACco/status/1554149217018552320/photo/1
[1] https://twitter.com/DCACco/status/1554282093345210369/photo/1
[1] https://twitter.com/DCACco/status/1554488957160853506/photo/1
[1] https://twitter.com/DCACco/status/1554898149738700800/photo/1
[1] https://twitter.com/DCACco/status/1555198632659484674/photo/1
[1] https://twitter.com/DCACco/status/1555545917431943168/photo/1

Top URLs in Tweet in G3:
[1] https://www.sqlpass.de/
[1] https://www.google.de/search?q=sqlpass

Top URLs in Tweet in G4:
[1] https://michaeljswart.com/2022/08/formatting-binary10-lsn-values-for-use-in-sys-fn_dblog/
[1] https://sqlperformance.com/2022/08/sql-server-2022/additional-t-sql-improvements-in-sql-server-2022
[1] https://sqlperformance.com/2022/08/sql-optimizer/simple-parameterization-and-trivial-plans-part-6

Top URLs in Tweet in G5:
[1] https://twitter.com/SQLEspresso/status/1554198532839571458

Top Domains
Top Domains in Tweet in Entire Graph:
[92] dcac.com
[37] twitter.com
[4] sqlespresso.com
[2] sqlperformance.com
[1] sqlpass.de
[1] google.de
[1] michaeljswart.com

Top Domains in Tweet in G1:
[50] dcac.com
[18] twitter.com

Top Domains in Tweet in G2:
[42] dcac.com
[18] twitter.com
[4] sqlespresso.com

Top Domains in Tweet in G3:
[1] sqlpass.de
[1] google.de

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

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

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[93] sqlpass
[83] sqlserver
[46] azure
[42] cloud
[39] it
[31] thekrewe
[4] sqlblog



Top Hashtags in Tweet in G1:
[49] sqlpass
[47] sqlserver
[26] azure
[25] cloud
[23] it
[20] thekrewe

Top Hashtags in Tweet in G2:
[40] sqlpass
[36] sqlserver
[20] azure
[17] cloud
[16] it
[11] thekrewe
[4] sqlblog

Top Hashtags in Tweet in G4:
[3] sqlpass

Top Hashtags in Tweet in G5:
[1] sqlpass

Top Words
Top Word Pairs
Top Replied-To
Top Mentioned
Top Tweeters
Top Tweeters in Entire Graph:
@mrdenny
@readtechhere
@way0utwest
@realrubberduck1
@crazyaboutcloud
@azuretweetbot
@sqlrus
@irishsql
@solarwinds
@sqlespresso

Top Tweeters in G1:
@readtechhere
@realrubberduck1
@crazyaboutcloud
@azuretweetbot
@sqlrus
@irishsql
@lisagb_sql
@made2mentor
@dcacco
@mayfconsulting

Top Tweeters in G2:
@mrdenny
@way0utwest
@solarwinds
@sqlespresso
@jc_russell
@warwick_rudd
@carolynmauney

Top Tweeters in G3:
@hannespreishub
@chwenz
@asp_net

Top Tweeters in G4:
@mjswart
@pass_rm_canada

Top Tweeters in G5:
@sqlgoddess


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.