Solved

Data Warehouse Day to Day Tasks

Posted on 2014-11-24
3
83 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 32

Expert Comment

by:Stefan Hoffmann
Comment Utility
Short question, short answer: System health.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
Comment Utility
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 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Are you one of those front-line IT Service Desk staff fielding calls, replying to emails, all-the-while working to resolve end-user technological nightmares? I am! That's why I have put together this brief overview of tools and techniques I use in o…
Email signature management is something that is often overlooked in many organizations or is simply not implemented effectively. Let's take a look at what methods are available for managing this important piece of corporate branding.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

728 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now