blog vs author main page

Question

Post reply

blog vs author main page

Solomon Rutzky

SSCoach

Points: 16430
More actions
April 2, 2019 at 1:55 pm

#2510706
Hi there. There are a few issues (or at least differences that may or may not be intentional) surrounding blog / author main pages:
1. The old site distinguished between blog-specific posts and content authored specifically on SSC.com. Meaning, there used to be both "https://www.sqlservercentral.com/blogs/sql-quantum-leap/" (with just my blog posts) and "https://www.sqlservercentral.com/Authors/Articles/Solomon_Rutzky/294002/" (with just my SSC.com-specific content). Now there is only "https://www.sqlservercentral.com/author/solomon-rutzky" (with combined blog posts and SSC.com-specific content). Is this intentional? I kinda liked having the blog-specific page, but I can also see a benefit to having everything mixed together as it is the same author. Not necessarily a bug, was mainly curious if this was intentional or oversight, and to see what others thought about the change as well.
2. Even if it's intentional to combine blog and SSC.com content into a single author main page, the old blog-specific URL (e.g. "https://www.sqlservercentral.com/blogs/sql-quantum-leap/") is now a custom 404 page. I'm sure there are several sites out there with links to those blog-specific pages, and they need to automatically redirect to the new author main-page URL (e.g. "https://www.sqlservercentral.com/author/solomon-rutzky").
3. The old SSC.com-specific author page URLs also result in the custom 404 page (e.g. "https://www.sqlservercentral.com/Authors/Articles/Solomon_Rutzky/294002/"). I'm sure there are several sites out there with links to those author-specific pages, and they need to automatically redirect to the new author main-page URL (e.g. "https://www.sqlservercentral.com/author/solomon-rutzky").
4. The old SSC.com-specific Author pages and old Blog-specific pages used to show rating and number of reads per each article / post. Neither are shown anymore. Is this intentional or oversight or just low-priority backlog item?
Take care, Solomon..

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 1

Ditto that.

--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)

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

The new system combines the way that blogs and articles are handled. In the old system, the blogs were bolted on and never integrated. While we didn't intentionally make a decision to include blogs, they somewhat come as a part of the change.

Bug filed for redirection, as this should be fixed. The authors page shows rating if there is one, or an option for this. Added a bug to add stats (oversight)

Solomon Rutzky SSCoach Points: 16430 More actions · Answer 3

Hi Steve. Thanks for that info, and for filing those two bugs.

Related to the request to show number of reads, please also see: Add tool-tip with "Total Votes" and actual avg. to star rating in article lists

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

Solomon Rutzky SSCoach Points: 16430 More actions · Answer 4

To clarify point #2 in the original post of this thread/topic: with regards to the old blog-specific URLs (e.g. https://www.sqlservercentral.com/blogs/sql-quantum-leap/ ) that now result in the custom 404 page, I just noticed that there are still blog-specific URLs in the new site (e.g. https://www.sqlservercentral.com/blogs/source/sql-quantum-leap ). As far as I can see, the only difference is the additional "/source" added to the path in the new URLs. So, instead of redirecting the old blog URLs to the new author URLs (our previous discussion above), would it be possible to redirect them to the new blog URLs? If nothing else, that is a much simpler URL-rewrite rule to add to the web server config than translating all of those old blog URLs into their respective new author URLs 🙂

Of course, doing that (i.e. redirecting to new blog URLs) probably requires re-linking the blogs to their actual blog name instead of linking to "SQLServerCentral Blogs", else those new blog-specific pages will be empty. As of right now, my blog-specific page only shows the 2 most recent posts as those are the only ones tagged with my blog names. The rest are linked to "SQLServerCentral Blogs" and only appear in my author-specific URL.

Take care, Solomon..

This reply was modified 5 years, 7 months ago by Solomon Rutzky.

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