Solved

Data Warehouse Day to Day Tasks

Posted on 2014-11-24
3
87 Views
Last Modified: 2014-12-22
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
Comment
Question by:halifaxman
3 Comments
 
LVL 33

Expert Comment

by:ste5an
ID: 40463970
Short question, short answer: System health.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40464011
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
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40464028
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

774 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question