New & Notable
SQL Server Data Warehousing News
January 31, 2014
The BI Semantic Model and Data Quality Services: These are two of the five SQL Server 2012 BI features that highlight this database release.
March 25, 2013
Microsoft platform architect Mark Kromer says in this Q&A that DBAs need to start focusing on SQL Server big data technologies to stay up-to-date.
January 08, 2013
Author Brian Larson shares his wisdom and insight regarding SQL Server business intelligence and makes some suggestions for companies new to BI.
November 07, 2012
Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server.
SQL Server Data Warehousing Get Started
Bring yourself up to speed with our introductory content
SQL-on-Hadoop is a class of analytical application tools that combine established SQL-style querying with newer Hadoop data framework elements. Continue Reading
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
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.
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 adds options for the clustered and the nonclustered columnstore index. Robert Sheldon shares the good and the bad. Continue Reading
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 ReviewsPowered by IT Central Station
Powered by IT Central Station
The first version of Microsoft’s Parallel Data Warehouse is out for a while, now I had the chance to get my hands on it during a customer POC....Continue Reading
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
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
Manage SQL Server Data Warehousing
Learn to apply best practices and optimize your operations.
In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints. Continue Reading
Creating a table correctly in SQL Server can be pretty tricky, but using SQL Server Management Studio Table Designer makes it easier. Continue Reading
This Essential Guide offers expert advice for improving enterprise data management and quality with SQL Server tools and services. Continue Reading
Problem Solve SQL Server Data Warehousing Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Take a look at some HP and Dell SQL Server 2012 data warehouse appliances to see if any might fit your business needs. Continue Reading
Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider. Continue Reading
Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management. Continue Reading