SQL Server Data Warehousing

Data Warehousing

+ Show More

October 21, 2015 21 Oct'15
The Azure SQL Data Warehouse gains an auditing feature

Microsoft announced that it had enabled an auditing feature for the Azure SQL Data Warehouse. The new feature has many benefits, but storing audit logs won't be free.
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.

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.

Cloud data warehouse guide: Using Redshift, rival platforms

Like other cloud services, cloud data warehouse platforms can offer potential savings, faster rollouts and the ability to scale up or down easily -- but there are challenges, too. Continue Reading
Microsoft SQL Server 2016: Previews show promise for next year

Microsoft SQL Server 2016 will be released next year. But in 2015, we've already had a glimpse into improved in-memory OLTP, security features, analytics and Stretch Database. Continue Reading
How to get started with PolyBase in SQL Server 2016

With PolyBase, when you use SQL Server 2016 as your data source, you have easy access to Hadoop and Azure Blob Storage data from whatever environment you're working in. Continue Reading

Learn to apply best practices and optimize your operations.

Shining a light on SQL Server storage tactics

A good storage plan is key to proper database management no matter what system database administrators are working in. Without a sufficient SQL Server storage plan, the system may run out of space or process tasks too slowly. This handbook examines ... Continue Reading
What's new in 2016's SQL Server AlwaysOn Availability Groups

Microsoft has added Distributed Transaction Coordinator support, optimized log transport and other features to AlwaysOn Availability Groups in SQL Server 2016. Continue Reading
Testers give an early view of Microsoft SQL Server 2016

Community Technology Previews show the creation process for Microsoft SQL Server 2016. SQL Server experts Denny Cherry and Joey D'Antoni share what they've learned in beta testing. Continue Reading

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

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
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
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