Creating a Data Warehouse
Plans are only good intentions unless they immediately degenerate into hard work.
When all the planning is done, it is time to create the data warehouse. SQL Server makes this task quite simple and effortless.
In this chapter, we discuss how to use the SQL Server 2012 Management Studio (SSMS) application to create a data warehouse. We look at several techniques to accomplish this, including SQL code, a table designer, and a diagramming tool that lets you visually create all of the data warehouse objects. When you have completed this chapter, you will have a working data warehouse that is ...