SQL Server Data Warehousing
Data Warehousing
SQL Server Data Warehousing News
-
November 18, 2016
18
Nov'16
Microsoft previews SQL Server on Linux, opens features across editions
Microsoft looks to broaden the horizons of SQL Server, as it moves some Enterprise features to Standard Edition and introduces SQL Server on Linux.
-
September 30, 2016
30
Sep'16
Azure Data Lake Analytics gets boost from U-SQL, a new SQL variant
The big data movement has frozen out many data professionals who are versed in SQL. Microsoft's U-SQL programming language tries to get such folks back in the data querying game.
-
July 21, 2016
21
Jul'16
Azure SQL Data Warehouse brings MPP to Microsoft cloud
As Azure SQL Data Warehouse reaches general availability, it brings massively parallel processing to a wider audience, and augers more competition in the cloud data space.
-
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.
SQL Server Data Warehousing Get Started
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
Shining a light on SQL Server storage tactics
Database administrators must attend to SQL Server storage needs. This guide provides tips on doing just that.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
Evaluate SQL Server Data Warehousing Vendors & Products
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
Manage SQL Server Data Warehousing
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
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.
-
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