shanewelgama.com | Shashane Welgama’s Blog – Sharing what I learn about SQL and Azure Data

Robots.txt Information

Robot	Path	Permission
GoogleBot	/	✔
BingBot	/	✔
BaiduSpider	/	✔
YandexBot	/	✔
# If you are regularly crawling WordPress.com sites, please use our firehose to receive real-time push updates instead. # Please see https://developer.wordpress.com/docs/firehose/ for more details. Sitemap: https://shanewelgama.wordpress.com/sitemap.xml Sitemap: https://shanewelgama.wordpress.com/news-sitemap.xml User-agent: * Disallow: /wp-admin/ Allow: /wp-admin/admin-ajax.php Disallow: /wp-login.php Disallow: /wp-signup.php Disallow: /press-this.php Disallow: /remote-login.php Disallow: /activate/ Disallow: /cgi-bin/ Disallow: /mshots/v1/ Disallow: /next/ Disallow: /public.api/ # This file was generated on Tue, 31 Jan 2023 19:48:37

Meta Tags

Title	Shashane Welgama’s Blog – Sharing what I learn about SQL and Azure Data
Description	Sharing what I learn about SQL and Azure Data
Keywords	N/A

Server Information

WebSite	shanewelgama.com
Host IP	192.0.78.24
Location	United States

Related Websites

                        Site
                        Rank
                    

More to Explore

shanewelgama.com Valuation

US$790,720

Last updated: 2023-05-15 05:48:07

shanewelgama.com has Semrush global rank of 13,385,662. shanewelgama.com has an estimated worth of US$ 790,720, based on its estimated Ads revenue. shanewelgama.com receives approximately 91,237 unique visitors each day. Its web server is located in United States, with IP address 192.0.78.24. According to SiteAdvisor, shanewelgama.com is safe to visit.

Traffic & Worth Estimates

Purchase/Sale Value	US$790,720
Daily Ads Revenue	US$730
Monthly Ads Revenue	US$21,897
Yearly Ads Revenue	US$262,763
Daily Unique Visitors	6,083
Note: All traffic and earnings values are estimates.

DNS Records

Host	Type	TTL	Data
shanewelgama.com.	A	299	IP: 192.0.78.24
shanewelgama.com.	A	299	IP: 192.0.78.25
shanewelgama.com.	NS	86400	NS Record: ns2.wordpress.com.
shanewelgama.com.	NS	86400	NS Record: ns1.wordpress.com.
shanewelgama.com.	NS	86400	NS Record: ns3.wordpress.com.

HtmlToTextCheckTime:2023-05-15 05:48:07

Shashane Welgama’s Blog Sharing what I learn about SQL and Azure Data Services Menu About Me Blog SQL Server Speaking Engagements Contact Me Difference between CAST and CONVERT September 7, 2022 September 7, 2022 ~ Shane Welgama ~ Leave a comment Recently I’ve been writing quite a bit about CAST and CONVERT on my Instagram page (@sql.handbook). Here I will highlight the differences in more detail. As we know by now, both functions can be used for converting an expression of one data type to another data type. However, they do have distinct differences. The differences: – CAST is ANSI-SQL. CONVERT is not. – CONVERT has a ‘style’ parameter. This allows CONVERT to change the format of the data. CAST cannot do that. CONVERT’s ‘style’ parameter can be quite powerful. It allows you to reformat data. For example, date and time styles vary across countries. So we can use the CONVERT function to change the format of a column with data in the datetime data type into other date formats. As seen

HTTP Headers

HTTP/1.1 301 Moved Permanently
Server: nginx
Date: Fri, 24 Dec 2021 19:10:38 GMT
Content-Type: text/html
Content-Length: 162
Connection: keep-alive
Location: https://shanewelgama.com/
X-ac: 3.ewr _dca 

HTTP/2 200 
server: nginx
date: Fri, 24 Dec 2021 19:10:39 GMT
content-type: text/html; charset=UTF-8
strict-transport-security: max-age=31536000
vary: Accept-Encoding
vary: Cookie
x-hacker: If you're reading this, you should visit automattic.com/jobs and apply to join the fun, mention this header.
host-header: WordPress.com
link: ; rel=shortlink
x-ac: 3.ewr _dca

shanewelgama.com Whois Information

Domain Name: SHANEWELGAMA.COM
Registry Domain ID: 2264667989_DOMAIN_COM-VRSN
Registrar WHOIS Server: whois.sawbuck.com
Registrar URL: http://www.wordpress.com
Updated Date: 2021-09-27T02:02:16Z
Creation Date: 2018-05-18T09:30:12Z
Registry Expiry Date: 2023-05-18T09:30:12Z
Registrar: Automattic Inc.
Registrar IANA ID: 1531
Registrar Abuse Contact Email: domainabuse@automattic.com
Registrar Abuse Contact Phone: +1 877 273-3049
Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited
Name Server: NS1.WORDPRESS.COM
Name Server: NS2.WORDPRESS.COM
Name Server: NS3.WORDPRESS.COM
DNSSEC: unsigned
>>> Last update of whois database: 2021-12-29T07:45:34Z <<<

shanewelgama.com valuation and analysis