sqlpass, Twitter, 5/30/2021 1:48:41 PM, 255869


FAQ | Problem?

sqlpass_2021-05-29_22-18-00.xlsx
sqlpass_2021-05-29_22-18-00.xlsx
From:
NodeXLExcelAutomator
Uploaded on:
May 30, 2021
Short Description:
sqlpass via NodeXL https://bit.ly/2RV2ox3
@dbanuggets
@sqlpass_de
@passdatasummit
@wstrasser
@redgate
@retracement
@thesmilingdba
@volkerbachmann
@datacommunityat
@dirkhondong

Top hashtags:
#dbcc2021
#sqlpass
#sqlpass_de
#powerbi
#sqlserver
#data
#devops
#azuredata

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

The requested start date was Sunday, 30 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 12-day, 5-hour, 28-minute period from Monday, 17 May 2021 at 02:16 UTC to Saturday, 29 May 2021 at 07:44 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 : 103
Unique Edges : 124
Edges With Duplicates : 314
Total Edges : 438
Number of Edge Types : 5
Retweet : 105
MentionsInRetweet : 194
Mentions : 95
Tweet : 26
Replies to : 18
Self-Loops : 26
Reciprocated Vertex Pair Ratio : 0.117647058823529
Reciprocated Edge Ratio : 0.210526315789474
Connected Components : 7
Single-Vertex Connected Components : 4
Maximum Vertices in a Connected Component : 95
Maximum Edges in a Connected Component : 423
Maximum Geodesic Distance (Diameter) : 8
Average Geodesic Distance : 3.305743
Graph Density : 0.0217018846373501
Modularity : 0.325462
NodeXL Version : 1.0.1.445
Data Import : The graph represents a network of 103 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, 30 May 2021 at 05:18 UTC.

The requested start date was Sunday, 30 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 12-day, 5-hour, 28-minute period from Monday, 17 May 2021 at 02:16 UTC to Saturday, 29 May 2021 at 07:44 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:
[13] https://www.sqlpass.de/dbcc-2021-die-data-blaster-community-conference/
[10] https://datasaturdays.com/
[4] https://passdatacommunitysummit.com/speakers
[3] https://1drv.ms/u/s!AkuS7cuuZyXwhdV-YYcm9Zg_XPpqWQ?e=6PRH2a
[3] https://twitter.com/sqlpass_de/status/1393233395371622401
[3] https://passdatacommunitysummit.com/
[2] https://web.cvent.com/event/2116834e-01c8-48a9-9dd6-950ef14c476b/websitePage:55dc8fd7-e500-4550-9055-6b1fde364777
[2] https://workingondata.wordpress.com/2021/05/20/azure-purview-and-sql-server-azure-sql-views/
[2] https://twitter.com/sqlpass_de/status/1394679096064585731
[2] https://blog.sqlauthority.com/2021/04/15/neutralize-troublesome-sql-server-indexes-fun-stories-demos-video/

Top URLs in Tweet in G1:
[4] https://passdatacommunitysummit.com/speakers
[3] https://passdatacommunitysummit.com/
[1] https://passdatacommunitysummit.com
[1] https://www.linkedin.com/showcase/pass-data-community-summit/
[1] https://pass.org/
[1] https://www.red-gate.com/simple-talk/opinion/editorials/pass-data-community-summit-2021/

Top URLs in Tweet in G2:
[12] https://www.sqlpass.de/dbcc-2021-die-data-blaster-community-conference/
[2] https://twitter.com/sqlpass_de/status/1393233395371622401
[1] https://datasaturdays.com/
[1] https://twitter.com/sqlpass_de/status/1394679096064585731
[1] https://twitter.com/SQL_aus_HH/status/1397436444457701376
[1] https://1drv.ms/u/s!AkuS7cuuZyXwhdV-YYcm9Zg_XPpqWQ?e=6PRH2a
[1] https://twitter.com/DataGrillen/status/1395380653319987204
[1] https://www.pleasetalkdatatome.de/2021/05/16/20-milliarden/

Top URLs in Tweet in G3:
[1] https://www.youtube.com/c/HybridVirtualGroup/videos
[1] https://www.meetup.com/hybrid-virtual-group/events/277550090/

Top URLs in Tweet in G4:
[2] https://1drv.ms/u/s!AkuS7cuuZyXwhdV-YYcm9Zg_XPpqWQ?e=6PRH2a
[1] https://twitter.com/sqlpass_de/status/1394679096064585731
[1] https://twitter.com/sqlpass_de/status/1393233395371622401

Top URLs in Tweet in G5:
[9] https://datasaturdays.com/
[2] https://workingondata.wordpress.com/2021/05/20/azure-purview-and-sql-server-azure-sql-views/
[1] https://www.sqlpass.de/dbcc-2021-die-data-blaster-community-conference/
[1] https://twitter.com/wstrasser/status/1395258024428703751
[1] https://m365chicago.com/
[1] https://www.meetup.com/hybrid-virtual-group/events/278137977/

Top URLs in Tweet in G6:
[1] https://www.microsoft.com/en-us/sql-server/community
[1] https://sqlusergroupaustria.wordpress.com/2021/05/12/data-community-austria-meeting-mai/

Top URLs in Tweet in G7:
[1] https://sqlperformance.com/2021/05/sql-performance/parallel-plans-start-5
[1] https://sqlespresso.com/2020/01/15/memory-optimizer-advisor/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost
[1] https://sqlespresso.com/2019/03/13/enable-mail-profile-back-to-basics/?utm_source=ReviveOldPost&utm_medium=social&utm_campaign=ReviveOldPost

Top URLs in Tweet in G9:
[2] https://web.cvent.com/event/2116834e-01c8-48a9-9dd6-950ef14c476b/websitePage:55dc8fd7-e500-4550-9055-6b1fde364777

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

Top Domains
Top Domains in Tweet in Entire Graph:
[13] sqlpass.de
[10] datasaturdays.com
[8] passdatacommunitysummit.com
[8] twitter.com
[3] 1drv.ms
[3] wordpress.com
[2] cvent.com
[2] sqlespresso.com
[2] meetup.com
[2] sqlauthority.com

Top Domains in Tweet in G1:
[8] passdatacommunitysummit.com
[1] linkedin.com
[1] pass.org
[1] red-gate.com

Top Domains in Tweet in G2:
[12] sqlpass.de
[5] twitter.com
[1] datasaturdays.com
[1] 1drv.ms
[1] pleasetalkdatatome.de

Top Domains in Tweet in G3:
[1] youtube.com
[1] meetup.com

Top Domains in Tweet in G4:
[2] 1drv.ms
[2] twitter.com

Top Domains in Tweet in G5:
[9] datasaturdays.com
[2] wordpress.com
[1] sqlpass.de
[1] twitter.com
[1] m365chicago.com
[1] meetup.com

Top Domains in Tweet in G6:
[1] microsoft.com
[1] wordpress.com

Top Domains in Tweet in G7:
[2] sqlespresso.com
[1] sqlperformance.com

Top Domains in Tweet in G9:
[2] cvent.com

Top Domains in Tweet in G10:
[2] sqlauthority.com

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[62] dbcc2021
[31] sqlpass
[23] sqlpass_de
[16] powerbi
[12] sqlserver
[11] data
[11] devops
[10] azuredata
[10] passsummit
[9] sqlfamily



Top Hashtags in Tweet in G1:
[8] passsummit
[8] sqlpass
[7] data
[7] passdatacommunitysummit
[6] sqlfamily
[3] passsummit2021
[1] sqlsaturday
[1] dbcc2021

Top Hashtags in Tweet in G2:
[36] dbcc2021
[16] sqlpass_de
[9] sqlserver
[5] serverless
[4] community
[3] powerbi
[3] microsoft
[2] azuresql
[2] dataplatform
[2] mvpbuzz

Top Hashtags in Tweet in G3:
[11] powerbi
[11] devops
[4] sqlpass
[3] mvpbuzz
[1] azurepurview
[1] dbcc2021
[1] bossmode

Top Hashtags in Tweet in G4:
[18] dbcc2021
[5] sqlpass_de
[2] powerbi
[1] sqlfamiliy
[1] sqlfamily
[1] learning
[1] azuresql
[1] microsoft
[1] dataplatform
[1] mvpbuzz

Top Hashtags in Tweet in G5:
[9] azuredata
[9] sqlpass
[5] azurepurview
[4] dbcc2021
[2] sql
[2] views
[1] data
[1] dbcckunde
[1] dbcc
[1] sqlpass_de

Top Hashtags in Tweet in G6:
[2] azuredatacommunity
[2] datacommunityat
[2] tsql
[1] power
[1] sqlpass_at
[1] sqlpass_de
[1] dbcc2021

Top Hashtags in Tweet in G7:
[5] sqlpass
[2] sqlserver
[2] sqlblog
[1] pass
[1] dbcc2021

Top Hashtags in Tweet in G8:
[2] data
[1] community
[1] sqlpass
[1] sqlfamily
[1] sqlserver
[1] learning

Top Hashtags in Tweet in G9:
[3] sqlpass
[2] pass
[1] passsummit

Top Words
Top Words in Tweet in Entire Graph:
[65] sqlpass_de
[62] #dbcc2021
[57] data
[50] community
[47] die
[34] pass
[31] #sqlpass
[28] summit
[26] sessions
[24] wstrasser

Top Words in Tweet in G1:
[33] data
[31] pass
[31] community
[22] summit
[19] speakers
[19] website
[18] icymi
[18] call
[18] learn
[18] more

Top Words in Tweet in G2:
[36] #dbcc2021
[32] die
[29] sqlpass_de
[17] sessions
[16] #sqlpass_de
[14] morgen
[13] data
[12] bweissman
[10] 15
[9] uhr

Top Words in Tweet in G3:
[12] bob_duffy
[11] retracement
[11] super
[11] excited
[11] tonights
[11] webinar
[11] bimaestro
[11] mcm
[11] mvp
[11] wow

Top Words in Tweet in G4:
[21] sqlpass_de
[18] #dbcc2021
[12] dbberater
[11] die
[10] kirnerka
[7] donnerstag
[7] erwarten
[6] mittagspause
[6] torstenstrauss
[5] #sqlpass_de

Top Words in Tweet in G5:
[12] wstrasser
[11] sqlpass_de
[9] #azuredata
[9] #sqlpass
[9] know
[8] community
[8] datasaturdays
[8] hurry
[8] azurepurview
[7] loo

Top Words in Tweet in G6:
[2] #azuredatacommunity
[2] nächste
[2] woche
[2] mittwoch
[2] 19
[2] mai
[2] #datacommunityat
[2] meeting
[2] datamonsterben
[2] mehrenmueller

Top Words in Tweet in G7:
[5] #sqlpass
[2] blog
[2] archive
[2] #sqlserver
[2] #sqlblog

Top Words in Tweet in G8:
[4] session
[4] data
[4] community
[4] thanks
[3] excellent
[3] extensive
[3] learning
[3] thursday
[3] toronto
[3] professionals

Top Words in Tweet in G9:
[3] #sqlpass
[2] lawyersql
[2] seems
[2] weird
[2] community
[2] conference
[2] run
[2] single
[2] software
[2] vendor

Top Words in Tweet in G10:
[3] lots
[3] people
[3] ask
[3] creating
[3] long
[3] videos
[3] well
[3] clients
[3] comprehensive
[3] database

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[34] pass,data
[34] data,community
[25] community,summit
[20] learn,more
[18] call,speakers
[18] die,#dbcc2021
[13] finally,introducing
[13] introducing,pass
[11] free,online
[11] website,save

Top Word Pairs in Tweet in G1:
[31] pass,data
[31] data,community
[22] community,summit
[17] call,speakers
[17] learn,more
[12] finally,introducing
[12] introducing,pass
[10] website,save
[10] save,date
[10] date,learn

Top Word Pairs in Tweet in G2:
[11] die,#dbcc2021
[7] 15,30
[6] 30,uhr
[6] morgen,#dbcc2021
[5] sqlpass_de,die
[5] #dbcc2021,sessions
[5] sessions,15
[5] uhr,solltet
[5] solltet,morgen
[5] morgen,verpassen

Top Word Pairs in Tweet in G3:
[11] super,excited
[11] excited,tonights
[11] tonights,webinar
[11] webinar,bob_duffy
[11] bob_duffy,bimaestro
[11] bimaestro,mcm
[11] mcm,mvp
[11] mvp,wow
[11] wow,presentation
[11] presentation,#powerbi

Top Word Pairs in Tweet in G4:
[5] tkansy,kirnerka
[5] sqlpass_de,mittagspause
[5] mittagspause,erwarten
[5] erwarten,torstenstrauss
[5] torstenstrauss,dbberater
[5] dbberater,frankgeisler
[5] frankgeisler,kirnerka
[5] kirnerka,#dbcc2021
[5] #dbcc2021,donn
[4] die,#dbcc2021

Top Word Pairs in Tweet in G5:
[8] #azuredata,#sqlpass
[8] #sqlpass,community
[8] community,know
[8] know,datasaturdays
[8] datasaturdays,hurry
[7] wstrasser,#azuredata
[7] hurry,loo
[5] azurepurview,sqlpass_de
[3] wstrasser,azurepurview
[2] die,#dbcc2021

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

Top Word Pairs in Tweet in G7:
[2] blog,archive
[2] #sqlserver,#sqlblog
[2] #sqlblog,#sqlpass

Top Word Pairs in Tweet in G8:
[3] excellent,session
[3] session,extensive
[3] extensive,learning
[3] learning,thursday
[3] thursday,toronto
[3] toronto,data
[3] data,professionals
[3] professionals,community
[3] community,thanks
[3] thanks,everyone

Top Word Pairs in Tweet in G9:
[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 Word Pairs in Tweet in G10:
[3] lots,people
[3] people,ask
[3] ask,creating
[3] creating,long
[3] long,videos
[3] videos,well
[3] well,clients
[3] clients,comprehensive
[3] comprehensive,database
[2] database,performance

Top Replied-To
Top Mentioned
Top Mentioned in Entire Graph:
@sqlpass_de
@wstrasser
@passdatasummit
@dbberater
@kirnerka
@redgate
@frankgeisler
@bob_duffy
@bweissman
@retracement

Top Mentioned in G1:
@passdatasummit
@redgate
@auntkathi
@thesmilingdba
@sqlpass
@sqlpass_de

Top Mentioned in G2:
@sqlpass_de
@bweissman
@frankgeisler
@sql_aus_hh
@datamonsterben
@dbberater
@wstrasser
@kirnerka
@torstenstrauss
@data

Top Mentioned in G3:
@bob_duffy
@retracement
@wstrasser
@sqlpass_de

Top Mentioned in G4:
@sqlpass_de
@dbberater
@kirnerka
@torstenstrauss
@tkansy
@wstrasser
@frankgeisler
@tommartens68
@khoeltgen
@dirkhondong

Top Mentioned in G5:
@sqlpass_de
@wstrasser
@datasaturdays
@azurepurview
@datacommunityat
@tkansy
@kirnerka
@hybridvug

Top Mentioned in G6:
@datamonsterben
@mehrenmueller
@sqlpass_de
@sqlpass_cz
@tsql_ninja
@datacommunityat

Top Mentioned in G8:
@paulswengrr
@dbanuggets
@passdatasummit

Top Mentioned in G9:
@lawyersql

Top Mentioned in G10:
@pinaldave

Top Tweeters
Top Tweeters in Entire Graph:
@rosenchild
@dataaugmented
@datachick
@sql_handle
@pythonexpertbot
@worrelpa
@intoleranse
@pinaldave
@theconstructor
@realrubberduck1

Top Tweeters in G1:
@sql_handle
@intoleranse
@pshore73
@sqlpass
@sqlbek
@yatessql
@sqlmct
@redgate
@johnsterrett
@sqlworldwide

Top Tweeters in G2:
@koprowskit
@sql_williamd
@microsoftteams
@sqlserver
@bweissman
@atholymardies
@dirkhondong
@data
@frankgeisler
@kostjaklein

Top Tweeters in G3:
@rosenchild
@pythonexpertbot
@worrelpa
@realrubberduck1
@retracement
@allenrevans
@desertislesql
@guyinacube
@pjcov
@bob_duffy

Top Tweeters in G4:
@dataaugmented
@theconstructor
@derfredo
@tommartens68
@brainbug23
@oengels
@dbberater
@sqlpaparazzo
@torstenstrauss
@kirnerka

Top Tweeters in G5:
@klunkysql
@nikoneugebauer
@spaghettidba
@wstrasser
@andrekamman
@bidgeir
@jjuelke
@johannesvink
@ta_rente
@azurepurview

Top Tweeters in G6:
@mehrenmueller
@lenz_philipp
@sqlpass_cz
@tsql_ninja
@datacommunityat

Top Tweeters in G7:
@sqlespresso
@akarcher
@pass_rm_canada
@sql_joachimw

Top Tweeters in G8:
@chrisavwood
@paulswengrr
@sri_innovation

Top Tweeters in G9:
@datachick
@lawyersql

Top Tweeters in G10:
@pinaldave
@sqlbobscot


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.