Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2006-02-22 : 18:22:49
|
| Hi people,first of all; I don't know if this topic belongs in the developer forum but since it's about database developer tools I thought this was the right place. I've been sailing around in the Caribbean for quite some time now and one huge problem I've had is that when people call me with some sort of database problem, I rarely have the tools I need accessible. So I came up with this idea for a website that I've now created and I wanted to hear if you have had similar problems to mine and if you think my website could help out in these situations. It will cost me a little bit of money to publish it, so I would really appreciate any thoughts you might have. The website is thought to be sort of an online version of query analyzer where the user 100% anonymously can access his/her database using regular ADO connections and some sort of DML and do the modifications needed to solve their database problem. One enters an ADO connection string in to a form field along with some DML (i.e. transact sql) and run it against their database. I have made a beta of the website and you can find it and try it out at the following adress:http://www.braplan.no/queryanalyzer/If you try it, please be aware that it is not SSL encrypted and that there are quite a few security issues involved in testing this right now!I am aware that queryanalyzer.com is not an available domain but that's the name that first came to my mind when I started creating it. I'll find something different when/if it comes in to production.Is this website worth publishing and would any of you ever consider using it?--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-23 : 02:57:12
|
So lets get this right: You are from Norway and spending most of your time sailing round the Caribbean and you want all us folk locked in dark, wintry, offices to help you out?  1) MS do a web site Enterprise Manager / Query Analyser thingie (ASP.NET I think) - wouldn't folk just install that on their own web sites to achieve this objective?2) What would we do about our firewalls - which won't be expecting "inbound" from your IP address(s). We could add them ... but not sure our security boffins would like that over-muchly.Kristen |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-23 : 03:12:06
|
| what the heck are you doing taking calls from clients when you are sailing in the Caribbean?-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-23 : 05:19:01
|
| You know how it is when you get bored ... you think up some sort of Quiz and post it on SQL Team ... |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-02-23 : 07:22:03
|
| Hehe, to tell you the truth I actually created most of the site when I was crossing the Atlantic. The trip took 25 days so I had to fill my days with something ;) And beeing a geek has it's price you know, just can't that let that little thingy called a computer rest all by itself, hehe.1) Never heared of such an app, is it like an "plug'n'play website" than MS provides? 2) This is one of the major problems I've come to think of and the only solution I guess (allthough probably not acceptable for most professional users) is to add the sites IP to their firewall. Maybe you could do it at night while none of the "security boffins" are watching There are also quite a few people that are on shared database servers which usually are wide open.But what do you think? Is the site totally useless? Maybe I should create it as a plug'n'play downloadable website instead and sell it for a few bucks and be a millionaire. Hmm...food for thought...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-23 : 10:05:27
|
"downloadable website instead"Nah, not "instead". That sounds like the Enterprise Version to me ... Megabucks!Online sounds handy - you are right about the shared hosting folk. Plus you could probably add some cool features that help them manage their systems way WAY better. And they are always wanting to do "How do I get a backup from my shared hosting, I have no file access ...." solutions.Plus you could offer a "How crap is my shared hosting" and look for whether xp_cmdshell is open and stuff like that.That'll be 10% of your first 1,000 years profit, in advance please!See also:http://www.aspenterprisemanager.com/ - Open Source even - you could add all your features to an Altruistic module!quote:
ASP Enterprise Manager is a web-based interface for Microsoft SQL Server and MSDE written using ASP.Net, VB.Net and C#.Net. This project was developed to allow many SQL Server and MSDE design and administration tasks to be performed from any computer with a web browser.
And also Google!!Kristen |
|
|
|
|
|
|
|
|
Online queryanalyzer