Showing posts with label upgrading. Show all posts
Showing posts with label upgrading. Show all posts

Sunday, March 11, 2012

Another Need Help for Choosing an SQL Server front end

Hi,
I'm just in the planning stages of upgrading a small bunch of databases
to MS SQL Server (2003). The current databases are very poorly
designed, so I'm basically starting from scratch. The databases will
grow to be quite large over time, and we have plenty of space for it.
Currently the number of users is about 15 in total. I would prefer to
web-enable it using our intranet since I have skills in programming JSP,
html, etc. But don't have time to learn ASP or ASP.Net. Am also
proficient with MS Access but have found it a little unstable in the
past.
Is there anything someone could recommend as a front-end?
AMH
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
"AMH" <anonymous@.blah.com> wrote in message
news:ukIxMAgHFHA.3244@.TK2MSFTNGP09.phx.gbl...
> I'm just in the planning stages of upgrading a small bunch of databases
> to MS SQL Server (2003). The current databases are very poorly
> designed, so I'm basically starting from scratch. The databases will
> grow to be quite large over time, and we have plenty of space for it.
> Currently the number of users is about 15 in total. I would prefer to
> web-enable it using our intranet since I have skills in programming JSP,
> html, etc. But don't have time to learn ASP or ASP.Net. Am also
> proficient with MS Access but have found it a little unstable in the
> past.
> Is there anything someone could recommend as a front-end?
There is no SQL Server 2003... 2000 is the current version. Microsoft Access
still makes a reasonably good front end. If the data is constantly being
changed by your users, you will need to learn to be proficient in multi-user
VBA coding techniques.
Steve
|||I can't see the users changing data so much. There'll be a lot of data
entry, and a lot of querying to find trends, patterns, etc.
AMH
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||When you buy sql server 2000 it comes already with a good GUI front end
called Enterprise Manager. It is very easy to use and you could control
who has access to what.
It is free too and can be installed on everybodies workstation.
|||But Enterprise Manager isn't designed to be a front end tool
for end users. It's a "quick and dirty" administration tool.
It's not necessarily free to distribute to everyone. It's
still governed by licensing.
-Sue
On 1 Mar 2005 16:41:48 -0800, thomasamillergoogle@.yahoo.com
wrote:

>When you buy sql server 2000 it comes already with a good GUI front end
>called Enterprise Manager. It is very easy to use and you could control
>who has access to what.
>It is free too and can be installed on everybodies workstation.
|||Thanks, but Enterprise Manager is more for the administrative side of
things - that's what I'll use. But I'm after a user interface that I
can build for the every-day user who can't have direct access to the raw
data.
AMH
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||"AMH" <anonymous@.blah.com> wrote in message
news:uYxTSzsHFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Thanks, but Enterprise Manager is more for the administrative side of
> things - that's what I'll use. But I'm after a user interface that I
> can build for the every-day user who can't have direct access to the raw
> data.
One solution, use Microsoft Access as your front and create custom views in
SQL Server. The users never sniff the raw data tables
Steve

Sunday, February 12, 2012

Analysis Services Architecture

We have a large cube (over 500GB) and several other relatively small cubes built using AS 2000. We are now in the process of upgrading the environment. Basically we are going to buy new infrastructure and use AS 2005. And the OS is most likly XP. The large cube is the one that is widely used in the company by at least over 200 people. Small cube has very few users. My question is what is the best architecture we can use

1. Whether to use one large machine and then have one instance of AS. All cubes are to be migrated to this instance. Issue with this option, we can not makesure we give more resources to the important cube.

2. Have multiple instances of the AS running on the server. Use MS Resource manager (new product shipped with XP server) to manage the resources. Has anyone used MS resource manager or aware of any issue with it ?

3. Use clustered environment - I do not know how use this to allocate more resources to the important cube. Any thoughts ?

Much appreciate, any pointers on what we are trying to achieve here .

Thank you

It is hard to make any suggestion based on short description only.
But if you are going to have several smaller cubes, queried not often, it probably Ok to consolidate them with the bigger cube on the same server.
Your risks are whenever smaller cubes are queried, the bigger cube will see some slowdown. Again, you might be Okay with consolidating them together. Just make sure you give it excess capacity. Try it, test it.


HTH
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.