SQL Server Data Warehousing News
July 09, 2015
Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.
May 12, 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
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
The BI Semantic Model and Data Quality Services: These are two of the five SQL Server 2012 BI features that highlight this database release.
SQL Server Data Warehousing Get Started
Bring yourself up to speed with our introductory content
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 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
Evaluate SQL Server Data Warehousing Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Microsoft SQL Server 2014 for Windows can be used for building, deploying and managing on-premises and cloud applications. Continue Reading
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
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
Product ReviewsPowered by IT Central Station
The out-of-the-box performance and data compression allows us to manage larger volumes of data more easily.Powered by IT Central Station
Valuable Features: The extreme performance and data compression that comes straight out of the box. • Improvements to My Organization: With...Continue Reading
For a free product, it has a relatively fast load. However, the Enterprise Edition is too expensive for something that won't replace our Oracle DWH database.Powered by IT Central Station
Valuable Features: The high compression and the relatively fast load for a free product. • Use of Solution: I used the Community...Continue Reading
A single consulting resource can patch/upgrade the entire stack because patching and maintenance has become reliable and simplified.Powered by IT Central Station
Valuable Features: My top 4 most important features of Exadata are: 1. Smart Scan, the ability to offload intensive SQL workloads to the...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