[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 97
  • Last Modified:

Data Warehouse Day to Day Tasks

Hi

I have been tasked with putting some bullet points together.

This is on the day to day tasks of looking after a data warehouse.

Any help would be appreciated
0
halifaxman
Asked:
halifaxman
1 Solution
 
ste5anSenior DeveloperCommented:
Short question, short answer: System health.
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Too big a question - I would suggest getting a book on it, but I don't know where you are in your training or what stage the data warehouse is at, so maybe Microsoft's book 70-463 "Implementing a Data Warehouse with Microsoft SQL Server 2012" would be your best bet.

If you just want bullet points, look at this link: http://technet.microsoft.com/en-us/library/aa905992(v=sql.80).aspx
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
A data warehouse (DW) is not more than a very large database so the tasks are basically the same as the tasks you'll perform on a generic database. Big difference is being a very large database it will need more resources so keep a special attention on RAM and storage.
Also a DW have other components (BI and Cubes) so you can't forget about checking them as well. And the processes that are used to feed the DW.
0

Featured Post

Will You Be GDPR Compliant by 5/28/2018?

GDPR? That's a regulation for the European Union. But, if you collect data from customers or employees within the EU, then you need to know about GDPR and make sure your organization is compliant by May 2018. Check out our preparation checklist to make sure you're on track today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now