Links in earlier posts not working

• Jeff Moden

  SSC Guru

  Points: 1004363

  More actions

  April 4, 2019 at 12:15 am

  #2729368

  Any word on fixing links?  Hits on Google and Bing are dropping like flies.

   

  I'm no front-end expert by any means but here's a thought for a possible fix.  Rumor has it that, given a link, sites can redirect to updated links.  If you were to scan the old website data (presumably in a table) by article title and author and match that up with article title and author on the new site, you could build a redirection table containing both the old and new URLs and "simply" redirect requests for the old URL to the new one.  That would make the old hard-code links that people have posted on other sites over the last near 2 decades still work.

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Solomon Rutzky

  SSCoach

  Points: 16430

  More actions

  April 4, 2019 at 3:49 pm

  #2785482

  Steve, in another thread, has asked for specific examples of non-working URLs, so here is my list:

  1. https://www.sqlservercentral.com/articles/Stairway+Series/104406/  (should redirect to: https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-1-what-is-sqlclr )
  2. https://www.sqlservercentral.com/articles/Stairway+Series/105841/  (should redirect to: https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-2-sample-stored-procedure-and-function )
  3. https://www.sqlservercentral.com/articles/Stairway+Series/109905/  (should redirect to: https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-3-security-general-and-safe-assemblies )
  4. https://www.sqlservercentral.com/articles/Stairway+Series/112888/  (should redirect to: https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-4-security-external-and-unsafe-assemblies )
  5. https://www.sqlservercentral.com/articles/Stairway+Series/119429/  (should redirect to: https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-5-development-using-net-within-sql-server )
  6. https://www.sqlservercentral.com/articles/SQLCLR/138154/  (should redirect to: https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-6-development-tools-intro )
  7. https://www.sqlservercentral.com/articles/SQLCLR/138155/  (should redirect to: https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-7-development-and-security )
  8. https://www.sqlservercentral.com/articles/SQLCLR/138156/  (should redirect to: https://www.sqlservercentral.com/steps/stairway-to-sqlclr-level-8-using-visual-studio-to-work-around-ssdt )
  9. https://www.sqlservercentral.com/articles/Data+Modeling/72814/  (should redirect to: https://www.sqlservercentral.com/articles/restructure-100-million-row-or-more-tables-in-seconds-srsly )
  10. https://www.sqlservercentral.com/articles/SQL+Server+2008/66554/  (should redirect to: https://www.sqlservercentral.com/articles/streaming-data-into-sql-server-2008-from-an-application-1 )
  11. https://www.sqlservercentral.com/articles/SQL+Server+2005/63300/  (should redirect to: https://www.sqlservercentral.com/articles/exporting-and-versioning-lookup-data-a-real-world-use-of-the-clr )
  12. https://www.sqlservercentral.com/articles/Stored+Procedures/62975/  (should redirect to: https://www.sqlservercentral.com/articles/searching-objects-for-text )
  13. https://www.sqlservercentral.com/articles/SQL+CLR/3208/  (should redirect to: https://www.sqlservercentral.com/articles/getting-the-most-out-of-sql-server-2005-udts-and-udas )

   

  That is most, but not all, of my articles. The pattern appears to be that old URLs with a "+" in them do not redirect. There are a few in the list above that are just "SQLCLR" with no "+" in the URL, but those are also part of the "Stairway to SQLCLR" series, and most of those have "Stairway+Series" in the URL, so I assume that is how those other 3 were seen.

   

   

  SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
  Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
  Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
  Info sites — Collations     •     Module Signing     •     SQLCLR