SQL Server Data Warehousing

SQL Server Data Warehousing Get Started

Bring yourself up to speed with our introductory content

• SQL-on-Hadoop

  SQL-on-Hadoop is a class of analytical application tools that combine established SQL-style querying with newer Hadoop data framework elements. Continue Reading

• 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

Evaluate SQL Server Data Warehousing Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

• How to improve OLTP with SQL Server 2014 In-Memory

  Basit Farooq explains how to improve the performance of OLTP applications using SQL Server 2014 In-Memory. He details what makes SQL Server 2014 In-Memory different from other in-memory database engines and how to use that to your advantage. Continue Reading

• SQL Server 2014 columnstore index: the good, the bad and the clustered

  SQL Server 2014 adds options for the clustered and the nonclustered columnstore index. Robert Sheldon shares the good and the bad. Continue Reading

• Quintillion creates flash pool to escape SQL Server bottlenecks

  Quintillion runs SQL Servers on VMs, and PernixData gave them a way out of the storage bottleneck, bringing their data closer to the database. Continue Reading

Product Reviews

• 100,000x faster: gnarly queries reduced from 22 hours to 800 milliseconds

  Powered by IT Central Station

  Part I: The Pilot A/B testing is part of our company’s DNA; we test every change to our platform and games. When we were small, this was easy,...Continue Reading

  Rating:

• Vertica allows for thousands of users to run an analysis at the same time. Great aggressive compression.

  Powered by IT Central Station

  At the tech company I work , we were looking for new ways to allow end users (a couple of thousand external users)  to crunch through their...Continue Reading

  Rating:

• Needs more stability in terms of query results but we have improved our query response time.

  Powered by IT Central Station

  Valuable Features: External tables to load the data from flat files. • Improvements to My Organization: It helped us in loading millions of...Continue Reading

  Rating:

Manage SQL Server Data Warehousing

Learn to apply best practices and optimize your operations.

• Set database constraints using SQL Server Management Studio Table Designer

  In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints. 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

• Guide to SQL Server data management and data quality

  This Essential Guide offers expert advice for improving enterprise data management and quality with SQL Server tools and services. Continue Reading