SQL Server Data Warehousing

Data Warehousing

+ Show More

July 09, 2015 09 Jul'15
Limited public preview opens for Azure SQL Data Warehouse

Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.
May 12, 2015 12 May'15
SQL Server 2016 preview announced for summer 2015

Microsoft CEO Satya Nadella announced the SQL Server 2016 preview for this summer. Its new features model the ethos of "mobile first, cloud first."
March 24, 2015 24 Mar'15
Vendors introduce three new SQL Server appliances

If SQL Server appliances are on your radar, you have options, but the price tag is high. Do your homework before buying. Here are the current offerings.
January 31, 2014 31 Jan'14
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.

Bring yourself up to speed with our introductory content

SQL Server, Hadoop both part of Analytics Platform System

A need for data warehouses designed for large-volume data loading and complex analytical workloads led to Microsoft's Analytics Platform System. Continue Reading
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

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

Microsoft SQL Server 2014 relational DBMS overview

Microsoft SQL Server 2014 for Windows can be used for building, deploying and managing on-premises and cloud applications. Continue Reading
SQL Server 2016, Azure SQL Data Warehouse lead Microsoft cloud hopes

Microsoft is working on yet another computing transformation, and its SQL Server and Azure SQL products are central thereto. But the company faces stiff competition in the cloud from Amazon. Continue Reading
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

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

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

Examining SQL Server 2012 data warehouse appliances

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
In data warehousing, cost-benefit’s the issue with backup compression

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
Microsoft tailors BI capabilities for users, IT in SQL Server 2012

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