MS SQL Farm

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi all, thank in advance for your help.

The company I work for have been predominately using Oracle and IBM DB2. We
do use Sql Server on case by case basis, but there is no well implemented
infrastructure that will help us leverage MS Sql server. There has been
initiative between us (developers) to implement a structured proactively
managed Sql farm, so that we could continue developing MS Sql reliant
solutions. Unfortunately, there is not full time DBA and most of the
implementation and design will be done by us developers. More over we would
have to sell the idea to the management.

Would anyone be able to point to any source of documentation or study cases
that we could learn from? Products that will help implement and manage some
aspects of the environment such as monitoring/notification agents, backup
agents.

We were looking at implementation a solution that will be comprised of the
development/test and production servers with stand by servers . All data for
both the production and test environments will placed on the Network
Appliance storage (Filer iSCSI attached storage).

Regards,
Dominic
.

Relevant Pages

  • Re: Question on conversion to ADP
    ... parameters through VBA/pass-through queries. ... help/guidance coming from Microsoft for Access developers trying to ... Microsoft Access or SQL Server 2005: ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Can relational alegbra perform bulk operations?
    ... Unlike in most other fields that are so expensive to participate in, the ironic aspect in IT is that the "free software" developers usually mimic what the commercial ... Many people recoil in horrors regarding its apparent disregard for transactions and foreign key support, but to me this makes perfect sense: If it's not needed, then the developer should be able to choose to not need it. ... Basically, they used SQL Server as a reporting server, loading data from Oracle DSS. ... The users just needs to aggregate data upon filters of their choosing and generate reports; no updates except to dump the data and load new dataset from Oracle on a regular interval. ...
    (comp.databases.theory)
  • Re: How to create views with SQL-NS
    ... >> What programming language are you using for your Wizard? ... all of our developers have EM and QA. ... >>>creation within our security model that sits atop SQL Server. ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Is TFS a Dev or Production System?
    ... you give the developers rights to TFS through the TFS bits only. ... Backup is primarily on the TFS SQL Server database, as that is where everything is stored. ... it is production. ... As stated, this is not an issue, as developers cannot directly access the system; they work through tools to check in/out source, update work items. ...
    (microsoft.public.vstudio.general)
  • Re: Future of ADPs
    ... "Developers", that really started in Access and continued with Access ... Ms Access ADPs and SQL Server 2005 Express ... SQL Server 2005 Express and ASP.Net, ... Reports to design your reports. ...
    (microsoft.public.access.adp.sqlserver)