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.
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 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
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
Manage SQL Server Data Warehousing
Learn to apply best practices and optimize your operations.
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
Microsoft has added Distributed Transaction Coordinator support, optimized log transport and other features to AlwaysOn Availability Groups in SQL Server 2016. Continue Reading
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
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.
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
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 addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints. Continue Reading