SQL Server Data Warehousing News
October 21, 2015
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
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.
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.
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
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
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: ...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
Powered by IT Central Station
Valuable Features: Smart Scan Smart Flash Cache High Availability Consolidation Robust Storage Computing • Improvements to My...Continue Reading
Manage SQL Server Data Warehousing
Learn to apply best practices and optimize your operations.
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
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
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