SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Changing SQLServerCentral - Newsletter Layout


Changing SQLServerCentral - Newsletter Layout

Author
Message
WayneS
WayneS
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20510 Visits: 10652
Luis Cazares (8/6/2013)
The forums part is mainly useless for the purpose that is presented (Database Pros Who Need Your Help!) because most topics are already solved.
There could be some kind of outstanding topics to reduce the space used by the forums posts in the newsletter.


Hmm, I like the idea of limiting this to recently posted but outstanding topics (but without a way to say a question has been answered, how do you determine this?)

To go along with this, how about a second section of recently solved questions? Limit it to a few per forum topic - maybe the most active for the prior day?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Steve Jones
Steve Jones
SSC Guru
SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139716 Visits: 19413
WayneS (8/6/2013)

To go along with this, how about a second section of recently solved questions? Limit it to a few per forum topic - maybe the most active for the prior day?


That's interesting. Maybe I'll see if we can play with this.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
cmerrell
cmerrell
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 173
This is 2013. Surely there is a way to reformat text to suit the width of the device displaying the text? Why settle for a particular fixed width format, which will only ever suit a minority?
Steve Jones
Steve Jones
SSC Guru
SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139716 Visits: 19413
cmerrell (8/6/2013)
This is 2013. Surely there is a way to reformat text to suit the width of the device displaying the text? Why settle for a particular fixed width format, which will only ever suit a minority?


Yes and no. We can allow test to flow, but then layout looks funny at times. If we control it more, we can't easily make it work in Outlook and in other clients. Outlook is really the problem, but since so many people use it, it's a problem.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Sarus1984
Sarus1984
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 108
Hey Steve,

multiple newsletter formats to choose from could be great - and if you give the option not only to choose the format but also which block of content should be included /* with the only mandatory block of ads - you have to live on something ;-) */ it would be awesome!

But have you thought about a poll where you give the community a list of possible options and so you will get know us better...
because at the moment I would think, most of feedback you receive is asks for change or a globally thank you. The content seldom write letters ^^

//Sarus
peter.row
peter.row
SSC Eights!
SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)

Group: General Forum Members
Points: 933 Visits: 447
I never read the newsletter on anything other than desktop so for me the fixed width is a pain.
If it could have just been the old style but with less of the clutter; as others have said things like links and headlines etc.., QotD etc...
paul.knibbs
paul.knibbs
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4074 Visits: 6240
Steve Jones - SSC Editor (8/6/2013)
Yes and no. We can allow test to flow, but then layout looks funny at times. If we control it more, we can't easily make it work in Outlook and in other clients. Outlook is really the problem, but since so many people use it, it's a problem.


You could always revert back to good ol' HTML and forget all that modern CSS stuff--that should work across all platforms then. :-)
Phil Factor
Phil Factor
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4684 Visits: 3031
I love the editorials, whatever they're about. Always read 'em. Almost every day I click on a link. I even like the pictures.
I doubt if you'll ever cater for everyone with one design. Shades of Metro. Outlook users are always going to be a problem because the newsletter is rendered as a Word document so you're never going to get a responsive design to work in Outlook.
What about catering for those of us who like to spread it all out across the screen to have a web-based version of the newsletter that is fully-responsive to the size of the browser window that we can access by clicking on the link in the the current truncated version that's optimized for small screens?.


Best wishes,

Phil Factor
Simple Talk
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59173 Visits: 13297
Steve Jones - SSC Editor (8/6/2013)
WayneS (8/6/2013)

To go along with this, how about a second section of recently solved questions? Limit it to a few per forum topic - maybe the most active for the prior day?


That's interesting. Maybe I'll see if we can play with this.


It would be nice to have some feature on the forum that allows a topic to be "answered". It doesn't need to be tied to the points system, like in Stack Overflow or MSDN, but it would help to construct a very interesting newsletter.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
raadee
raadee
SSC-Enthusiastic
SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)SSC-Enthusiastic (175 reputation)

Group: General Forum Members
Points: 175 Visits: 476
Steve Jones - SSC Editor (8/6/2013)
WayneS (8/6/2013)

To go along with this, how about a second section of recently solved questions? Limit it to a few per forum topic - maybe the most active for the prior day?


That's interesting. Maybe I'll see if we can play with this.


I really like the looks of the database administrators newsletter that Stackexchange sends out that contains information
about forum threads. The choice of topics that they made makes it interesting.
They have:

Top new questions this week.
Greatest hits from previous weeks.
Can you answer these? (unanswered).


For SQL Server Central I would not have every forum represented in the newsletter, a concept like above is more appealing.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search