Get started

SQL Server Data Warehousing

• columnstore index

  A columnstore index is a type of index used to store, manage and retrieve data stored in a columnar format in a database.Continue Reading

• In-memory from xVelocity to the memory-optimized columnstore index

  Robert Sheldon explains the history of in-memory technology from the xVelocity in-memory analysis engine to the memory-optimized columnstore index.Continue Reading

• Five SQL Server 2012 business intelligence features

  The BI Semantic Model and Data Quality Services: These are two of the five SQL Server 2012 BI features that highlight this database release.Continue Reading

• 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.Continue Reading

• Using SQL Server Management Studio Table Designer to create a table

  Creating a table correctly in SQL Server can be pretty tricky, but using SQL Server Management Studio Table Designer makes it easier.Continue Reading

• Definitions to Get Started

  • columnstore index
  • AlwaysOn Availability Groups
  • Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW)

  • database
  • relational database management system (RDBMS)

  View All Definitions

• 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.Continue Reading

• Why BI? Business intelligence concepts defined

  Don't let the value of BI get lost in technical jargon. This tip explains the purpose and components of a business intelligence system -- in plain English.Continue Reading

• Building a data warehouse in SQL Server: Eight tips to get started

  When building a data warehouse using SQL Server technologies, there are some challenges you may face. SQL Server database expert Baya Pavliashvili addresses some of the most common issues.Continue Reading

• 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.....Continue Reading

• relational database management system (RDBMS)

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