December 26, 2018 at 9:05 pm
Comments posted to this topic are about the item Porting SQLServerCentral
December 27, 2018 at 4:36 am
Fingers crossed this all goes smoothly! Let me know if I can help with testing
Thomas Rushton
blog: https://thelonedba.wordpress.com
December 27, 2018 at 7:57 am
This is a nice project to read about. Thanks,
412-977-3526 call/text
December 27, 2018 at 8:54 am
Glad to see you moving forward on this migration. Let us know if we can help!
December 27, 2018 at 9:00 am
Steve,
Have you ever published an architectural overview for SQL Server Central, similar to what other websites like Stack Overflow and Netflix do?
Also, while the hood is up, have you considered using a document store database like Azure DocumentDB for archiving and indexing the content ?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 27, 2018 at 9:07 am
We've published things a few times, but not anything in awhile. Our system is fairly simple, but it's probably worth documenting. We do have the stats live at monitor.red-gate.com, where the actual data is replicated from our internal systems to a publicly visible demo version of SQL Monitor.
Not sure what CosmosDB (formerly DocumentDB) would do to help us. If we removed data, we'd likely archive to another SQL Server database, and we could use distributed views to do that, but the amount of data is really small (GBs), so not sure what we'd get from CosmosDB.
That being said, I'd like to set up some project with that and experiment.
December 27, 2018 at 11:31 am
Steve Jones - SSC Editor - Thursday, December 27, 2018 9:07 AMWe've published things a few times, but not anything in awhile. Our system is fairly simple, but it's probably worth documenting. We do have the stats live at monitor.red-gate.com, where the actual data is replicated from our internal systems to a publicly visible demo version of SQL Monitor.Not sure what CosmosDB (formerly DocumentDB) would do to help us. If we removed data, we'd likely archive to another SQL Server database, and we could use distributed views to do that, but the amount of data is really small (GBs), so not sure what we'd get from CosmosDB.
That being said, I'd like to set up some project with that and experiment.
Building it all out on SQL Server does present an opportunity to showcase SQL Monitor. But here is why I raised the question about Azure CosmosDB (or more specifically, DocumentDB):
It seems that the bulk of SQL Server Central content is forum posts, editorials, summary stats, and source code. This can be modeled relationally, if you leverage blob data types. However, it's more naturally structured as documents, mostly html text with meta-data tags. Also, CosmosDB is very scalable in terms of user request throughput (~ $500 / month for 10,000 request units per second), and you can dial the RU/s up or down as needed.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 27, 2018 at 1:17 pm
There are a few things with that. First, we focus on SQL Server, so we want to host on SQL Server.
Second, there are things we do that can be modeled as documents, but aggregating those together and working in groups is better handled relationally, IMHO. I think forum posts, which are linked and cross linked, are a better relational fit than a document. Questions and answers, likely better relationally.
For the articles, sure, those are better fits for documents, like DocumentDB, but since I also need to put things together later, that might not be easy.
However, at our data volume, this is a wash, and the request count is tough to calculate and decide what's better. Ultimately I think doing this on DocumentDB would work, but there would be a learning curve, perhaps a large one, and things might not be as smooth.
It's easy to napkin scratch how things might work. Much harder to actually make them work. Perhaps even harder to port them over and deal with the issues as you get things running.
December 27, 2018 at 5:00 pm
Awesome. I cannot speak for others but the ability to simply copy and paste code from SSMS without something wonky going on with the format would be key to me. Second to that would be the ability to simply paste graphics from a tool like the "old" windows snipping tool a drag'n'drop that actually worked.
And, yeah... I'll be happy to test the dickens out of both of those things for you.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 28, 2018 at 7:55 am
A couple things I'd like to see are the ability to link multiple email accounts. I liked the change from the prior version, looking forward to the new version.
https://www.sqlservercentral.com/Forums/1884151/Link-account-to-multiple-email-adresses
If you are making changes how about changing the view of your 'Replies', so it has a 'Date of Last Change'.
I brought this up in this thread: https://www.sqlservercentral.com/Forums/1930136/Need-simpler-way-to-see-a-list-of-my-posts-and-possible-replies-to-them#bm1967227
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 1, 2019 at 6:05 am
This will be an interesting project and WordPress is certainly very popular although I have seen it being the target of a lot of hacks but I suppose the same is true of any popular platform.
I had never heard of NHibernate and having a look at the documentation I was wondering what the main advantage of this would be over something like .NET Core. It looks quite complex but it may be because it is not something I am used to. What would be the main advantage of using that just out of interest - or has .NET Core and Entity Framework sort of taken over from this now as it looks similar in some ways - mapping tables to objects?
January 1, 2019 at 7:02 am
Have used WordPress for all my blogs. I like them. The only issue I hate with it is how complicated it can be to customize as well secure as WordPress is popular, so is the vulnerabilities to cracking it. I'm to the point now where I pay my host to completely manage my WordPress installation because of how many times it's been compromised over the years.
January 2, 2019 at 10:18 am
I asked them to post data about the SQL Server type, and tweeted them to see if they would add the data for version (2008 R2, 2016, 2017)
https://projectnami.org/sql-edition-usage-stats-for-2018/
412-977-3526 call/text
January 2, 2019 at 6:07 pm
robert.sterbal 56890 - Wednesday, January 2, 2019 10:18 AMI asked them to post data about the SQL Server type, and tweeted them to see if they would add the data for version (2008 R2, 2016, 2017)
We've updated the link above with some version data.
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply