sqlpass, Twitter, 9/6/2020 4:47:54 AM, 234479


FAQ | Problem?

sqlpass_2020-09-05_21-36-00.xlsx
sqlpass_2020-09-05_21-36-00.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
September 06, 2020
Short Description:
sqlpass via NodeXL https://bit.ly/32WEsLe
@sqlpass
@yatessql
@volkerbachmann
@sqlpass_de
@tommartens68
@dirkhondong
@paulswengrr
@conexion_sv
@sqlsatoslo
@landrews5807

Top hashtags:
#sqlpass
#passsummit
#sqlserver
#sqlfamily
#sqlpass_de
#networking
#passsummit2020

Description:
Description
The graph represents a network of 186 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 September 2020 at 04:36 UTC.

The requested start date was Sunday, 06 September 2020 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 9-day, 11-hour, 28-minute period from Thursday, 27 August 2020 at 10:34 UTC to Saturday, 05 September 2020 at 22:02 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 : 186
Unique Edges : 202
Edges With Duplicates : 476
Total Edges : 678
Number of Edge Types : 5
Mentions : 183
Retweet : 164
MentionsInRetweet : 244
Replies to : 37
Tweet : 50
Self-Loops : 50
Reciprocated Vertex Pair Ratio : 0.149659863945578
Reciprocated Edge Ratio : 0.260355029585799
Connected Components : 14
Single-Vertex Connected Components : 7
Maximum Vertices in a Connected Component : 162
Maximum Edges in a Connected Component : 653
Maximum Geodesic Distance (Diameter) : 9
Average Geodesic Distance : 2.960116
Graph Density : 0.00982272595175821
Modularity : 0.29299
NodeXL Version : 1.0.1.439
Data Import : The graph represents a network of 186 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 September 2020 at 04:36 UTC.

The requested start date was Sunday, 06 September 2020 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 9-day, 11-hour, 28-minute period from Thursday, 27 August 2020 at 10:34 UTC to Saturday, 05 September 2020 at 22:02 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:
[9] https://twitter.com/sqlpass/status/1299368687594602497
[5] https://www.pass.org/summit/2020/Learn/BestofSummit2019.aspx?utm_source=Organic%20Social&utm_medium=Twitter&utm_campaign=Complimentary_Content
[4] https://www.sqlpass.de/fbp/02-09-2020-ein-kunterbuntes-haus/
[4] https://www.dcac.com/blog/pass-summit-virtual-speaker-idol-2020
[4] https://www.pass.org/summit/2020/Attend/Activities?utm_source=Organic%20Social&utm_medium=Twitter&utm_campaign=Networking_Activities
[3] https://www.pass.org/About-PASS/PASS-News/pass-welcomes-pure-storage-as-a-knowledge-partner
[3] https://fundamentals.pass.org/
[3] https://www.sqlpass.de/fbp/31-08-2020-keine-ahnung/
[3] https://www.pass.org/marathon/2020/professionaldevelopment/?utm_source=Organic%20Social&utm_medium=Twitter&utm_campaign=PASS_Marathon_Techinical_Leadership
[2] https://glennsqlperformance.com/2020/09/02/sql-server-2019-cu7-released/

Top URLs in Tweet in G1:
[5] https://www.pass.org/summit/2020/Learn/BestofSummit2019.aspx?utm_source=Organic%20Social&utm_medium=Twitter&utm_campaign=Complimentary_Content
[4] https://www.dcac.com/blog/pass-summit-virtual-speaker-idol-2020
[4] https://www.pass.org/summit/2020/Attend/Activities?utm_source=Organic%20Social&utm_medium=Twitter&utm_campaign=Networking_Activities
[3] https://www.pass.org/marathon/2020/professionaldevelopment/?utm_source=Organic%20Social&utm_medium=Twitter&utm_campaign=PASS_Marathon_Techinical_Leadership
[2] https://www.pass.org/summit/2020/RegisterNow.aspx?utm_source=Organic%20Social&utm_medium=Twitter&utm_campaign=Bob_Ward_Complimentary_Book
[2] https://www.pass.org/PASS-Blog/introducing-the-diversity-equality-inclusion-keynote
[2] https://twitter.com/sqlpass/status/1299368687594602497
[1] https://www.pass.org/PASS-Blog/ArtMID/99177/ArticleID/851/preview/true
[1] https://www.pass.org/Governance/Elections/Nominations-Committee
[1] https://www.pass.org/summit/2020/Learn/News/userid/263946/wit-and-diversity-equality-inclusion-keynotes-at-pass-virtual-summit-2020?utm_source=OrganicSocial&utm_medium=Twitter&utm_campaign=DEI_Keynote

Top URLs in Tweet in G2:
[3] https://twitter.com/sqlpass/status/1299368687594602497
[2] https://glennsqlperformance.com/2020/09/02/sql-server-2019-cu7-released/
[2] https://www.pass.org/summit/2020/Learn/Spotlights
[2] https://twitter.com/SqlrUs/status/1299340904524902403
[1] https://www.pass.org/summit/2020/Learn/Session-Details/name/real-world-implications-of-bias-in-coding-machine-learning/sid/104864
[1] https://www.pass.org/summit/2020/Learn/Session-Details/name/code-like-a-snake-charmer-version-2-0-introduction-to-python/sid/104868
[1] https://twitter.com/sqlpass/status/1300826033541845000
[1] https://www.pass.org/summit/2020/Attend/Activities?utm_source=Board%20Member&utm_medium=Twitter&utm_campaign=Networking_Activities
[1] https://www.pass.org/summit/2020/Learn/Session-Details/name/blogging-for-success-advancing-your-career-by-blogging/sid/104415
[1] https://twitter.com/sqlpass/status/1300518117001621506

Top URLs in Tweet in G3:
[4] https://www.sqlpass.de/fbp/02-09-2020-ein-kunterbuntes-haus/
[3] https://www.sqlpass.de/fbp/31-08-2020-keine-ahnung/
[2] https://www.sqlpass.de/fbp/28-08-2020-glasfaser/
[2] https://twitter.com/tommartens68/status/1300148887332753408
[1] https://www.youtube.com/playlist?list=PLHhVmT-3Q3J_p1D2YNqOArgcVLSDrDfNC

[1] https://twitter.com/tsql_ninja/status/1301430526012784641
[1] https://twitter.com/SQL_aus_HH/status/1301190240946839552
[1] https://twitter.com/tsql_ninja/status/1298893199096844289
[1] https://twitter.com/PleaseTalkData/status/1300064607726374912
[1] https://twitter.com/PassFruehstueck/status/1300492565196800000

Top URLs in Tweet in G4:
[2] http://blogs.lobsterpot.com.au/2020/08/26/pass-pro-memberships-for-deserving-people/
[1] https://twitter.com/SQLMelody/status/1301607277946863616
[1] https://twitter.com/sqlpass/status/1299368687594602497
[1] https://twitter.com/sqlpass/status/1300507325409656833

Top URLs in Tweet in G5:
[1] https://www.pass.org/About-PASS/PASS-News/pass-welcomes-pure-storage-as-a-knowledge-partner
[1] https://twitter.com/sqlpass/status/1299368687594602497
[1] https://twitter.com/sqlpass/status/1300524084900573186
[1] https://twitter.com/HRTact/status/1301589455250358277
[1] https://twitter.com/sqlpass/status/1301913383801847809
[1] https://twitter.com/sqlpass/status/1301566245653950467
[1] https://professionaldevelopment.pass.org/

Top URLs in Tweet in G6:
[3] https://fundamentals.pass.org/
[2] https://cloud.pass.org

Top URLs in Tweet in G7:
[1] https://twitter.com/sqlpass/status/1299368687594602497

Top URLs in Tweet in G8:
[1] https://www.kevinrchant.com/2020/08/31/speaking-at-sql-saturday-oslo/
[1] https://www.sqlsaturday.com/971/Sessions/Schedule

Top URLs in Tweet in G9:
[1] https://twitter.com/sqlpass/status/1299067923907186688
[1] https://twitter.com/sqlpass/status/1299368687594602497
[1] https://twitter.com/sqlpass/status/1300463722348113923
[1] https://sqlperformance.com/2020/09/locking/upsert-anti-pattern
[1] https://techcommunity.microsoft.com/t5/sql-server/cumulative-update-7-for-sql-server-2019-rtm/ba-p/1629317
[1] https://www.pass.org/About-PASS/PASS-News/pass-welcomes-pure-storage-as-a-knowledge-partner

Top URLs in Tweet in G10:
[1] https://www.eventbrite.com/e/toronto-pass-data-lake-overview-tickets-119191764777

Top Domains
Top Domains in Tweet in Entire Graph:
[60] pass.org
[32] twitter.com
[9] sqlpass.de
[5] sqlespresso.com
[4] dcac.com
[3] sqlsaturday.com
[2] meetup.com
[2] glennsqlperformance.com
[2] linkedin.com
[2] com.au

Top Domains in Tweet in G1:
[25] pass.org
[5] twitter.com
[4] dcac.com
[1] red-gate.com
[1] sqlsaturday.com
[1] linkedin.com

Top Domains in Tweet in G2:
[26] pass.org
[7] twitter.com
[2] glennsqlperformance.com
[1] linkedin.com
[1] sqlespresso.com
[1] google.com
[1] paper.li

Top Domains in Tweet in G3:
[9] sqlpass.de
[8] twitter.com
[1] youtube.com
[1] google.com

Top Domains in Tweet in G4:
[3] twitter.com
[2] com.au

Top Domains in Tweet in G5:
[5] twitter.com
[2] pass.org

Top Domains in Tweet in G6:
[5] pass.org

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

Top Domains in Tweet in G8:
[1] kevinrchant.com
[1] sqlsaturday.com

Top Domains in Tweet in G9:
[3] twitter.com
[1] sqlperformance.com
[1] microsoft.com
[1] pass.org

Top Domains in Tweet in G10:
[1] eventbrite.com

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[89] sqlpass
[81] passsummit
[26] sqlserver
[20] sqlfamily
[14] sqlpass_de
[11] networking
[11] passsummit2020
[9] powerbi
[8] azure
[8] sqlrun



Top Hashtags in Tweet in G1:
[23] passsummit
[22] sqlpass
[8] sqlserver
[5] networking
[4] data
[4] passmarathon
[4] sqlfamily
[4] professionaldevelopment
[3] prodev
[3] dbatools

Top Hashtags in Tweet in G2:
[43] passsummit
[40] sqlpass
[4] sqlserver
[3] sqlserver2019
[3] networking
[3] sqlfamily
[1] powershell
[1] dbas
[1] dbatools
[1] sqlpass_de

Top Hashtags in Tweet in G3:
[12] sqlpass_de
[7] powerbi
[4] dbcc2020
[1] learning
[1] sqlfamily
[1] pbifamily

Top Hashtags in Tweet in G4:
[3] sqlpass
[2] sqlfamily
[2] passpro
[2] passsummit2020
[2] wit
[2] diversity
[2] inclusion
[1] passsummit
[1] twotimecompetitor
[1] speakeridol

Top Hashtags in Tweet in G5:
[3] sqlpass
[2] passsummit
[2] professionaldevelopment
[1] prodev
[1] data
[1] passmarathon
[1] profdev
[1] passprofdev
[1] networking

Top Hashtags in Tweet in G6:
[6] sqlserver
[3] downunder
[3] sqlpass
[3] passsummit
[3] azure
[2] pass
[2] cloud
[1] sqlbits

Top Hashtags in Tweet in G7:
[6] sqlfamily
[6] sqlrun
[6] passsummit2020
[3] passsummit
[1] sqlpass
[1] networking
[1] sqlrace

Top Hashtags in Tweet in G8:
[6] sqlpass
[4] sqlsatoslo
[4] azuredevops
[4] github
[4] passsummit
[3] azuredatastudio
[1] sqlsatgothenburg
[1] githubactions
[1] passmarathon
[1] technicalleadership

Top Hashtags in Tweet in G9:
[3] sqlpass
[1] speakeridol
[1] passsummit
[1] sqlserver
[1] purestorage

Top Hashtags in Tweet in G10:
[1] bigdata

Top Words
Top Words in Tweet in Entire Graph:
[131] sqlpass
[89] #sqlpass
[81] #passsummit
[70] yatessql
[57] sql
[49] join
[43] data
[42] session
[33] server
[33] cc

Top Words in Tweet in G1:
[42] sqlpass
[26] yatessql
[23] #passsummit
[22] #sqlpass
[20] sql
[17] learn
[17] speaker
[16] 2020
[16] session
[14] pass

Top Words in Tweet in G2:
[43] #passsummit
[40] sqlpass
[40] #sqlpass
[27] cc
[24] data
[22] yatessql
[21] join
[20] sql
[17] today
[15] server

Top Words in Tweet in G3:
[15] die
[12] #sqlpass_de
[10] neue
[9] folge
[7] #powerbi
[6] guten
[6] cc
[6] passfruehstueck
[5] fã
[5] dear

Top Words in Tweet in G4:
[8] excited
[7] year
[6] irishsql
[6] sqlpass
[5] well
[5] cool
[5] news
[5] purestorage
[5] collaborate
[5] closely

Top Words in Tweet in G5:
[9] sqlpass
[8] session
[6] top
[5] yatessql
[5] join
[5] kekline
[4] 10
[4] mistakes
[4] leaders
[3] sql

Top Words in Tweet in G6:
[9] sqlpass
[6] #sqlserver
[5] thing
[5] session
[5] yatessql
[5] schedule
[4] heard
[4] called
[4] 2019
[4] find

Top Words in Tweet in G7:
[14] sqlpass
[13] mhaarhues
[9] sqlworldwide
[6] dear
[6] #sqlfamily
[6] working
[6] organize
[6] virtual
[6] #sqlrun
[6] during

Top Words in Tweet in G8:
[7] today
[7] yatessql
[6] myself
[6] #sqlpass
[5] join
[4] thanks
[4] session
[4] sqlstad
[4] #sqlsatoslo
[4] #azuredevops

Top Words in Tweet in G9:
[3] #sqlpass
[2] 15

Top Words in Tweet in G10:
[3] toronto
[3] pass
[3] having
[3] such
[3] hot
[3] topic
[3] september
[3] beat
[3] current
[3] summer

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[32] sql,server
[27] cc,sqlpass
[25] #sqlpass,cc
[21] speaker,idol
[20] #passsummit,2020
[17] register,today
[14] today,#sqlpass
[13] submit,application
[12] #passsummit,#sqlpass
[12] excited,speaker

Top Word Pairs in Tweet in G1:
[12] sql,server
[11] #passsummit,2020
[10] speaker,idol
[7] sql,revealed
[7] revealed,guide
[7] guide,cloud
[7] cloud,sql
[6] submit,application
[6] ebook,azure
[6] azure,sql

Top Word Pairs in Tweet in G2:
[27] cc,sqlpass
[25] #sqlpass,cc
[15] register,today
[14] sql,server
[13] today,#sqlpass
[11] #passsummit,#sqlpass
[8] virtual,#passsummit
[5] data,platform
[4] yatessql,join
[4] outstanding,data

Top Word Pairs in Tweet in G3:
[10] die,neue
[9] neue,folge
[6] cc,#sqlpass_de
[5] passfruehstueck,die
[5] dear,german
[5] german,speaking
[5] speaking,#powerbi
[5] #powerbi,friends
[5] friends,find
[5] find,introduction

Top Word Pairs in Tweet in G4:
[5] well,cool
[5] cool,news
[5] news,purestorage
[5] purestorage,excited
[5] excited,collaborate
[5] collaborate,closely
[5] closely,sqlpass
[5] sqlpass,community
[5] community,first
[5] first,year

Top Word Pairs in Tweet in G5:
[4] top,10
[4] 10,mistakes
[4] mistakes,leaders
[3] sqlpass,marathon
[2] yatessql,securing
[2] securing,sql
[2] sql,servers
[2] servers,network
[2] network,born
[2] born,attacks

Top Word Pairs in Tweet in G6:
[4] heard,thing
[4] thing,called
[4] called,#sqlserver
[4] #sqlserver,2019
[4] 2019,find
[4] find,registering
[4] registering,free
[4] free,hour
[4] hour,session
[3] session,sqlpass

Top Word Pairs in Tweet in G7:
[7] mhaarhues,sqlpass
[6] dear,#sqlfamily
[6] #sqlfamily,mhaarhues
[6] mhaarhues,working
[6] working,sqlpass
[6] sqlpass,organize
[6] organize,virtual
[6] virtual,#sqlrun
[6] #sqlrun,during
[6] during,#passsummit2020

Top Word Pairs in Tweet in G8:
[4] myself,sqlstad
[3] session,myself
[3] good,morning
[3] morning,see
[3] see,#azuredatastudio
[3] #azuredatastudio,#azuredevops
[3] #azuredevops,#github
[3] #github,actions
[3] actions,action
[3] action,today

Top Word Pairs in Tweet in G10:
[3] toronto,pass
[3] pass,having
[3] having,such
[3] such,hot
[3] hot,topic
[3] topic,september
[3] september,beat
[3] beat,current
[3] current,summer
[3] summer,weather

Top Replied-To
Top Replied-To in Entire Graph:
@sqlpass
@sqlworldwide
@bennidejagere
@gregnotatgastro
@yatessql
@bweissman
@sql_doch
@dbanuggets
@way0utwest
@sqlagentman

Top Replied-To in G1:
@sqlpass
@gregnotatgastro
@bennidejagere
@gt1gt1
@william_a_dba
@loriedwards
@j_quezada_

Top Replied-To in G2:
@sqlpass
@pianorayk
@sqlworldwide
@yatessql

Top Replied-To in G5:
@dbanuggets
@way0utwest

Top Replied-To in G6:
@bweissman
@sqlagentman

Top Replied-To in G7:
@sqlworldwide
@marclancy
@alevyinroc
@ceedubvee

Top Replied-To in G8:
@sql_doch
@yatessql

Top Mentioned
Top Mentioned in Entire Graph:
@sqlpass
@yatessql
@mhaarhues
@irishsql
@loriedwards
@purestorage
@bobwardms
@sqlrus
@sqlworldwide
@kekline

Top Mentioned in G1:
@sqlpass
@yatessql
@loriedwards
@bobwardms
@unclebiguns
@eduardodba
@edwinmsarmiento
@petegaleotti
@irishsql
@jeffedmunds

Top Mentioned in G2:
@sqlpass
@yatessql
@sqlrus
@nikoneugebauer
@irishsql
@statcowboy
@glennalanberry
@thehybriddba
@sqlservernerd
@mhaarhues

Top Mentioned in G3:
@passfruehstueck
@tommartens68
@sqlpass_de
@kostjaklein
@dirkhondong
@frankgeisler

Top Mentioned in G4:
@irishsql
@sqlpass
@purestorage
@landrews5807
@yatessql
@lobsterpot_au
@sqlmelody

Top Mentioned in G5:
@sqlpass
@yatessql
@kekline
@hrtact
@sqldiplomat
@loriedwards
@purestorage
@dbanuggets
@pass_profdev
@pass

Top Mentioned in G6:
@sqlpass
@yatessql
@dbafun
@armandolacerda1
@greglow
@dbargenis
@hugo_kornelis
@irishsql
@stratesql
@warwick_rudd

Top Mentioned in G7:
@sqlpass
@mhaarhues
@sqlworldwide
@yatessql
@strava
@alevyinroc

Top Mentioned in G8:
@yatessql
@sqlstad
@kevchant
@sqlpass
@azuredatastudio
@eleightondick
@thesmilingdba
@andyleonard

Top Mentioned in G10:
@paulswengrr
@jamesserra
@sqlfamily
@sqlpass

Top Tweeters
Top Tweeters in Entire Graph:
@chidambara09
@dataaugmented
@jandroid
@sql_handle
@ml_tweet_bot
@pythonista11
@jenstirrup
@jorriss
@sqlstudent144
@mrdenny

Top Tweeters in G1:
@jandroid
@_randolph_west
@jasonhorner
@loriedwards
@sqlpass
@vestergaardj
@thedouglane
@begintry
@redgate
@microsoft

Top Tweeters in G2:
@pythonista11
@jenstirrup
@mrdenny
@midnightdba
@nikoneugebauer
@sqlrus
@api_daily
@glennalanberry
@betsyweber
@sqlmal

Top Tweeters in G3:
@dataaugmented
@theconstructor
@koprowskit
@sqlallfather
@nirenmalla
@dirkhondong
@frankgeisler
@kostjaklein
@tommartens68
@_tillmann

Top Tweeters in G4:
@ml_tweet_bot
@sqlstudent144
@diversityup
@irishsql
@marlonribunal
@purestorage
@sqlthugette
@landrews5807
@sqlmelody
@dk_defined

Top Tweeters in G5:
@sql_handle
@way0utwest
@sqlbek
@sqldiplomat
@kekline
@blythemorrow
@hrtact
@gerbyj
@conseilit
@dbanuggets

Top Tweeters in G6:
@dbargenis
@stratesql
@sqlagentman
@desertislesql
@bweissman
@greglow
@buckwoodymsft
@hugo_kornelis
@warwick_rudd
@dbafun

Top Tweeters in G7:
@savranweb
@alevyinroc
@sqlworldwide
@mhaarhues
@strava
@sqlzelda
@ceedubvee
@pass_wit
@marclancy

Top Tweeters in G8:
@intoleranse
@andyleonard
@kevchant
@thesmilingdba
@eleightondick
@sqlstad
@sql_doch
@azuredatastudio

Top Tweeters in G9:
@jorriss
@heraflux
@pass_rm_canada
@dgmelkin
@vickivandamme
@blazdax
@sqlsa

Top Tweeters in G10:
@chidambara09
@arthurz
@jamesserra
@paulswengrr
@sqlfamily


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.