sqlhelp, Twitter, 9/24/2022 11:55:09 PM, 282197


FAQ | Problem?

sqlhelp Twitter NodeXL SNA Map and Report for Saturday, 24 September 2022 at 23:51 UTC
sqlhelp Twitter NodeXL SNA Map and Report for Saturday, 24 September 2022 at 23:51 UTC
From:
@SQLSocialite
Uploaded on:
September 24, 2022
Short Description:
sqlhelp via NodeXL https://bit.ly/3r6LyJs
@jdanton
@dataaugmented
@interflextech
@flitz_so
@sseramemes
@mrdenny
@gbargsley
@azuresupport
@sqlha
@pshore73

Top hashtags:
#sqlhelp
#php
#java
#javascript
#html
#python
#bolhadev
#kotlin
#sql
#sqlassignments

Description:
Description
The graph represents a network of 41 Twitter users whose recent tweets contained "sqlhelp", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 500,000 tweets. The network was obtained from Twitter on Saturday, 24 September 2022 at 23:51 UTC.

The tweets in the network were tweeted over the 7-day, 17-hour, 13-minute period from Saturday, 17 September 2022 at 06:27 UTC to Saturday, 24 September 2022 at 23:40 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 : 41
Unique Edges : 28
Edges With Duplicates : 91
Total Edges : 119
Number of Edge Types : 8
Replies to : 17
MentionsInReplyTo : 21
Mentions : 10
Retweet : 21
MentionsInRetweet : 34
Tweet : 13
MentionsInQuoteReply : 2
Quote : 1
Self-Loops : 14
Reciprocated Vertex Pair Ratio : 0.0666666666666667
Reciprocated Edge Ratio : 0.125
Connected Components : 13
Single-Vertex Connected Components : 5
Maximum Vertices in a Connected Component : 12
Maximum Edges in a Connected Component : 54
Maximum Geodesic Distance (Diameter) : 6
Average Geodesic Distance : 1.745819
Graph Density : 0.0292682926829268
Modularity : 0.379987
NodeXL Version : 1.0.1.504
Data Import : The graph represents a network of 41 Twitter users whose recent tweets contained "sqlhelp", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 500,000 tweets. The network was obtained from Twitter on Saturday, 24 September 2022 at 23:51 UTC.

The tweets in the network were tweeted over the 7-day, 17-hour, 13-minute period from Saturday, 17 September 2022 at 06:27 UTC to Saturday, 24 September 2022 at 23:40 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 : TwitterSearch
Graph Term : sqlhelp
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
Vertex X : Column1

Top Influencers: Top 10 Vertices, Ranked by Betweenness Centrality
Top URLs
Top URLs in Tweet in Entire Graph:
[4] https://twitter.com/cobeclub/status/1573648630724050945/photo/1
[1] https://twitter.com/Estella79020908/status/1571023004536311809/photo/1
[1] https://twitter.com/AzureSupport/status/1573280433722331136
[1] https://twitter.com/Tw__ee__ty/status/1573792478855155713/photo/1
[1] https://brentozar.com/archive/2009/12/i-need-sqlhelp/
[1] https://learn.microsoft.com/en-us/powershell/module/az.sql/get-azsqlinstancedatabasegeobackup?view=azps-8.3.0
[1] https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor-reference?view=azuresql#activity-log
[1] https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/monitor-azure-resource#monitoring-data-from-azure-resources
[1] https://learn.microsoft.com/en-us/azure/storage/files/files-smb-protocol?tabs=azure-portal#:~:text=Azure%20file%20shares%20don't%20support%20accessing%20an%20individual,can%20be%20accessed%20concurrently%20by%20thousands%20of%20clients
[1] https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-audit-file-transact-sql?view=sql-server-ver16

Top URLs in Tweet in G1:
[4] https://twitter.com/cobeclub/status/1573648630724050945/photo/1
[1] https://twitter.com/flitz_so/status/1573740496316407815/video/1
[1] https://twitter.com/flitz_so/status/1573657324077699074/photo/1
[1] https://twitter.com/flitz_so/status/1573704701077590016/photo/1

Top URLs in Tweet in G2:
[1] https://twitter.com/AzureSupport/status/1573280433722331136
[1] https://learn.microsoft.com/en-us/powershell/module/az.sql/get-azsqlinstancedatabasegeobackup?view=azps-8.3.0
[1] https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor-reference?view=azuresql#activity-log
[1] https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/monitor-azure-resource#monitoring-data-from-azure-resources
[1] https://learn.microsoft.com/en-us/azure/storage/files/files-smb-protocol?tabs=azure-portal#:~:text=Azure%20file%20shares%20don't%20support%20accessing%20an%20individual,can%20be%20accessed%20concurrently%20by%20thousands%20of%20clients

Top URLs in Tweet in G3:
[1] https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16
[1] https://twitter.com/JohannesVink/status/1573174896649199616/photo/1

Top URLs in Tweet in G4:
[1] https://twitter.com/Estella79020908/status/1571023004536311809/photo/1

Top URLs in Tweet in G5:
[1] https://register.gotowebinar.com/register/1508091673188195342
[1] https://twitter.com/Idera_Software/status/1572378624761929729/photo/1

Top URLs in Tweet in G6:
[1] https://twitter.com/Tw__ee__ty/status/1573792478855155713/photo/1
[1] https://brentozar.com/archive/2009/12/i-need-sqlhelp/

Top URLs in Tweet in G10:
[1] https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-audit-file-transact-sql?view=sql-server-ver16

Top Domains
Top Domains in Tweet in Entire Graph:
[12] twitter.com
[6] microsoft.com
[1] brentozar.com
[1] gotowebinar.com

Top Domains in Tweet in G1:
[7] twitter.com

Top Domains in Tweet in G2:
[4] microsoft.com
[1] twitter.com

Top Domains in Tweet in G3:
[1] microsoft.com
[1] twitter.com

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

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

Top Domains in Tweet in G6:
[1] twitter.com
[1] brentozar.com

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

Top Hashtags
Top Hashtags in Tweet in Entire Graph:
[48] sqlhelp
[20] php
[19] java
[19] javascript
[19] html
[19] python
[16] bolhadev
[16] kotlin
[3] sql
[1] sqlassignments



Top Hashtags in Tweet in G1:
[20] php
[19] java
[19] javascript
[19] html
[19] python
[19] sqlhelp
[16] bolhadev
[16] kotlin
[1] estagio

Top Hashtags in Tweet in G2:
[10] sqlhelp

Top Hashtags in Tweet in G3:
[5] sqlhelp
[1] mssql
[1] sql
[1] azuredevops
[1] sqlserver

Top Hashtags in Tweet in G4:
[2] sqlhelp
[1] sql
[1] sqlassignments
[1] assignmenthelp

Top Hashtags in Tweet in G5:
[4] sqlhelp
[1] sql

Top Hashtags in Tweet in G7:
[3] sqlhelp

Top Hashtags in Tweet in G8:
[2] sqlhelp

Top Hashtags in Tweet in G9:
[1] sqlhelp

Top Hashtags in Tweet in G10:
[2] sqlhelp

Top Words
Top Words in Tweet in Entire Graph:
[48] #sqlhelp
[20] #php
[20] isso
[19] #java
[19] #javascript
[19] #html
[19] #python
[19] sseramemes
[16] #bolhadev
[16] #kotlin

Top Words in Tweet in G1:
[20] #php
[20] isso
[19] #java
[19] #javascript
[19] #html
[19] #python
[19] #sqlhelp
[19] sseramemes
[16] #bolhadev
[16] #kotlin

Top Words in Tweet in G2:
[10] #sqlhelp
[7] server
[6] azuresupport
[6] sql
[5] azure
[5] hashtag
[5] please
[5] backup
[4] jdanton
[4] good

Top Words in Tweet in G3:
[5] #sqlhelp
[3] columns
[3] table
[2] trace
[2] sql
[2] managed
[2] instance
[2] server
[2] source
[2] data

Top Words in Tweet in G4:
[2] best_experts
[2] #sqlhelp
[2] assignment
[2] order

Top Words in Tweet in G5:
[4] user
[4] #sqlhelp
[3] hash
[3] tag
[2] machine
[2] account
[2] idera_software
[2] keep

Top Words in Tweet in G7:
[4] clustered
[3] #sqlhelp
[2] table
[2] indexes
[2] index
[2] first
[2] created

Top Words in Tweet in G8:
[2] object
[2] schema
[2] dbo
[2] #sqlhelp
[2] rules
[2] name

Top Words in Tweet in G9:
[2] parent
[2] pipeline
[2] child
[2] pay

Top Words in Tweet in G10:
[4] audit
[3] file
[2] view
[2] #sqlhelp

Top Word Pairs
Top Word Pairs in Tweet in Entire Graph:
[19] #java,#javascript
[19] #javascript,#html
[19] #html,#php
[19] #php,#python
[19] #python,#sqlhelp
[19] #sqlhelp,sseramemes
[16] sseramemes,#bolhadev
[16] #bolhadev,#kotlin
[10] duvido,não
[10] não,sentir

Top Word Pairs in Tweet in G1:
[19] #java,#javascript
[19] #javascript,#html
[19] #html,#php
[19] #php,#python
[19] #python,#sqlhelp
[19] #sqlhelp,sseramemes
[16] sseramemes,#bolhadev
[16] #bolhadev,#kotlin
[10] duvido,não
[10] não,sentir

Top Word Pairs in Tweet in G2:
[2] jdanton,azuresupport
[2] azure,sql
[2] sql,community
[2] azuresupport,azuresql
[2] azuresupport,yes
[2] yes,stop
[2] stop,answering
[2] answering,questions
[2] questions,sqlhelp
[2] sqlhelp,hashtag

Top Word Pairs in Tweet in G3:
[2] managed,instance

Top Word Pairs in Tweet in G5:
[3] hash,tag

Top Word Pairs in Tweet in G7:
[2] clustered,index

Top Replied-To
Top Replied-To in Entire Graph:
@jdanton
@gbargsley
@azuresupport
@estella79020908
@brento
@tw__ee__ty
@tonio_morales
@itsmealimm
@marlonribunal
@kurdt88

Top Replied-To in G2:
@jdanton
@gbargsley
@azuresupport
@marlonribunal
@itsmealimm

Top Replied-To in G4:
@estella79020908

Top Replied-To in G5:
@idera_software
@interflextech

Top Replied-To in G6:
@brento
@tw__ee__ty

Top Replied-To in G7:
@tonio_morales

Top Replied-To in G8:
@kurdt88

Top Replied-To in G10:
@ktpooh77

Top Mentioned
Top Tweeters