Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / January 2006

Tip: Looking for answers? Try searching our database.

Improving the Sql environment at our Place ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Colin Robinson - 28 Jan 2006 21:26 GMT
I need to improve the sql setup at my current location (long term contract)

Currently there are

100+ msde installations  (1 gb average running a retail back end processes)
Backup to disk and tape locally only.
10+ other servers  Running HQ apps including Accouts, Payroll, Credit
Control, Property Management. (same Backup routine)
Other 3rd party SQL databases running one either HQ servers or Msde
instances that I dont know much about yet.
Intranet Running from IIS6 connecion to one of the HQ boxes
DTS Server in the DMZ responsible for communicating/syncronising Batch
processes and shared data  to and from  the Retail Servers.
An Active-Active cluster running  as a central reporting repository (not
wharehouse or analysis Services)
There is a simple UAT environment with another couple of servers.
Development is ongoing Both Front end and SQL development.
Visual Sourcesafe as the code repository for db development has been put in
place already

I need to improve this situation and provide a clear structure to move
forward. We are currently win2003,  SQL 2000, MSDE 2000 and on Microsoft
Select. The general structure for the environment is  HQ : DMZ :
RetailEnvironment (512k Outsourced)

General Direction is:

Sql 2005:
Reporting Services
Analysis Services
Notification and Alerting
Staging Servers
UAT/Testing
Deployment
Resiliance

Any suggestions how / what SQL strategy to put in place here ? Development
to unrealistic timescales in the live environment is the norm here at the
moment.  The good part is the  requirement to change this is understood by
management.

Anyone here been through this and care to share their experiences before I
make the same mistakes ?

Colin Robinson


Michael Cheng [MSFT] - 30 Jan 2006 03:28 GMT
Hi Colin,

Welcome to use MSDN Managed Newsgroup!

To keep the integrity of newsgroup, we encourage you post only one post in
the newsgroup so that other communities may also benefit from this. I will
reply the post in microsoft.public.sqlserver.programming and follow up your
any questions there.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Signature

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.