When you register for a shared hosting plan you are
typically provided with the IP address of the Remote SQL Server that you can
connect to using your own SQL Server Studio Management tool. Sometimes your ISP
might not have given you access to the port that is used to connect to a remote
SQL Server! You have two choices: Either send your scripts or database backup
to the support guys and ask them to run your scripts on your live database or
you could use an Administrative tool if provided by your hosting company to
manage your database, where not all do this!
Don’t you wish you could have your own administrative tool
that you could use to manage your remote database and have full control of your
database objects without the need to contact your support guys and be queued to
modify anything in your database?
Well the wish has come true with the myLittleAdmin Web-Based
Management tool for SQL Server 2005. This tool is the first web-based management
tool found in the market these days that allows you to manage almost all
objects of your SQL Servers and databases, including the new SQL Server objects
(database snapshots, synonyms, credentials, etc …).
We will not be focusing on explaining the use of these new features
in SQL Server 2005 or how to do stuff, but rather give you an overview of all
the possible features and functionalities embedded inside the myLittleAdmin
tool!