SQL Server Data Warehousing

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Top three SQL Server Denali features to watch

    This issue’s feature article provides a guided tour of some of the features that make Denali so intriguing — ultra-fleet column-store indexes, a new high-availability component and data visualization technology that looks more sci-fi than real life. ... 

  • Data warehousing 101

    The preference of a transactional database vs. Data Warehousing depends on the depth of the query being performed. SQL Server Development Expert Joe Toscano details the pros and cons. 

  • The pros and cons of data warehousing

    SQL Server expert Eric Brown explains the pros and cons of data warehousing. 

  • AlwaysOn Availability Groups

    AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together. 

  • Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW)

    Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW) is a pre-built data warehouse appliance that includes Microsoft SQL Server database software, third-party server hardware and networking components. 

  • database

    A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. (Continued...... 

  • relational database management system (RDBMS)

    A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. 

  • Ensuring high availability of SSAS databases

    In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on high availability for SSAS. 

  • Building a data warehousing and BI solution

    In part two of his series, Baya Dewald breaks down the process of creating a data warehousing and business intelligence solution, with details on the SSAS objects and processing options involved. 

  • An introduction to SQL Server data warehousing concepts

    New to data warehousing? In this short presentation, SQL Server expert Baya Dewald offers an introduction to the basic components of data warehousing, with details on relational and multi-dimensional concepts for SQL Server Analysis Services (SSAS).... 

About SQL Server Data Warehousing

In IT, data warehousing is a critical component of any business intelligent (BI) strategy. Not only does a data warehouse need to be adequately scalable and secure enough to house an organization's data, it also has to be equipped to assist in the reporting and analysis of that data. The BI platform included with Microsoft SQL Server is designed with an eye on data warehousing for business intelligence. Our SQL Server data warehousing topic page provides news, tutorials and best practices around the main SQL Server BI tools (Analysis Services, Integration Services, and Reporting Services) and how they fit into a SQL Server data warehousing solution. You'll also find details on Microsoft's latest BI editions – Master Data Services and the Parallel Data Warehouse edition of SQL Server 2008 R2 – with information on how and why to implement them.