Website Technology Profiler

{
  "PageContent": "TSQL Programming What is Collation is SQL Server and how it worksGUID in Sql ServerPIVOT, Multi Pivot & Dynamic Pivot in SQL ServerMutex in Sql ServerRecursive CTEBookmark lookup tipping pointConditional branching and OPTION(Recompile)Statistics used in the cached execution plansPivoting with Python in Sql ServerTemporary tables statistics when used in stored proceduresAdding non-NULL value columns ONLINEORDER BY – Changes everythingSemi Joins, anti-joins and Nulls in Sql ServerThree valued logic – NULL in Sql ServerShort–Circuit evaluation in Sql Server Security Orphaned DB Users and SQL Server logins Data Layer Data providers and User OptionsClient Requests & Sql events in Sql ServerXACT_ABORT and Query Timeout in Sql Server High Availability and Disaster Recovery Read Only Routing in Sql Server Quick TSQL Thoughts Its time for DatetimeSysname datatype and NULL column constraint  ",
  "Url": "https://sqlchitchat.com",
  "IpAddress": "66.102.132.214",
  "ReverseDns": "sh-cp5-au.yyz2.servername.online",
  "Asn": null,
  "Http2": false,
  "Http3": false,
  "ResponseTimeMs": 2189,
  "StatusCode": 200,
  "ServerHeaders": [
    "Apache"
  ],
  "Ssl": {
    "Issuer": "CN=R12, O=Let's Encrypt, C=US",
    "Subject": "CN=*.sqlchitchat.com",
    "NotBefore": "2025-12-28T11:51:37-08:00",
    "NotAfter": "2026-03-28T12:51:36-07:00",
    "SubjectAltNames": [
      "DNS Name=*.sqlchitchat.com",
      "DNS Name=sqlchitchat.com"
    ],
    "Hsts": false,
    "Ciphers": [],
    "Protocol": "Tls13",
    "DaysUntilExpiry": 57
  },
  "Cdns": [],
  "HostingHints": [],
  "Cms": [
    "WordPress",
    "WordPress (robots.txt)"
  ],
  "Frameworks": [
    "jQuery"
  ],
  "JsLibraries": [],
  "Analytics": [
    "Google Analytics UA",
    "Google Analytics GA4",
    "Google Tag Manager",
    "Segment"
  ],
  "AdsAndMarketing": [],
  "PaymentGateways": [],
  "EcommerceHints": [
    "PrestaShop"
  ],
  "SocialSignals": [
    "LinkedIn"
  ],
  "MediaProviders": [],
  "SeoTags": [
    "content-type: text/html; charset=UTF-8"
  ],
  "HtmlLanguage": "en-AU",
  "HasRobots": true,
  "HasSitemap": true,
  "SecurityHeaders": [],
  "CookiesObserved": [],
  "XhrApiHints": [],
  "SitemapCounts": {
    "total_urls": 3
  },
  "ChatWidgets": [],
  "ABTesting": [],
  "PrivacyConsent": [],
  "EmailMarketing": [],
  "WebFonts": [
    "Google Fonts"
  ],
  "DynamicJs": [
    "jQuery (script Resource)",
    "Web Server: Apache",
    "Bootstrap (CSS Classes)",
    "ES6+ JavaScript Features",
    "jQuery (CDN Detection)",
    "jQuery (Script Analysis)",
    "Google Analytics (Script Analysis)",
    "Google Tag Manager (Script Analysis)",
    "Hotjar (Script Analysis)",
    "React (Script Analysis)"
  ],
  "ResourceHosts": [
    "www.googletagmanager.com",
    "sqlchitchat.com",
    "platform-api.sharethis.com",
    "gmpg.org",
    "fonts.googleapis.com",
    "fonts.gstatic.com",
    "static.licdn.com"
  ],
  "CssFrameworks": [],
  "BuildTools": [],
  "ServerTech": [
    "Generator: WordPress 6.9",
    "PHP (inferred from WordPress)"
  ],
  "DatabaseHints": [],
  "PageTitle": "SQL CHIT CHAT … Blog about Sql Server & Snowflake | In Codd We Trust .. It's Ted or bust",
  "MetaDescription": null,
  "ImageCount": 2,
  "ScriptCount": 19,
  "LinkCount": 21,
  "Errors": [],
  "UiFrameworks": [
    "Bootstrap (Class Names)",
    "Vuetify (Class Names)"
  ]
}