SQL Server Data Warehousing

New & Notable

Download this free guide

Download: 60-Page Expert RDBMS Guide

Trends come and go, but your DB strategy shouldn’t be a flavor of the month. Learn why you shouldn’t get distracted by new DB technology, how Facebook is using a RDBMS to do the data slicing and dicing they can’t in Hadoop, and more.

Corporate E-mail Address:
You forgot to provide an Email Address.
This email address doesn’t appear to be valid.
This email address is already registered. Please login.
You have exceeded the maximum character limit.
Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

SQL Server Data Warehousing News

September 25, 2018 25 Sep'18
SQL Server 2019 preview brings Hadoop, Spark and AI into DBMS

A SQL Server 2019 preview brings Hadoop and Spark into the fold, positioning the database as an all-purpose data portal. Azure Cosmos DB also gets an update.
August 29, 2018 29 Aug'18
Talend tool targets Azure data integration for analytics use

Talend released software that does bulk data uploads to Microsoft's Azure SQL Data Warehouse. The goal is to streamline data integration and support real-time analytics.
June 11, 2018 11 Jun'18
Proposed Microsoft-GitHub buy confirms open source role in cloud

The looming Microsoft-GitHub pairing confirms the company's rebirth as an open source friend. Data tools on the Azure cloud are part of the motivation.
November 21, 2017 21 Nov'17
Microsoft Azure cloud database activity takes off at Connect();

Microsoft Connect(); 2017 saw the addition of MariaDB and Cassandra to the Azure cloud database lineup. Also discussed: A set of Spark-based analytics services called Azure Databricks.

View All News

SQL Server Data Warehousing Get Started

Bring yourself up to speed with our introductory content

RDBMS (relational database management system)

A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. Continue Reading
U-SQL

U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments. Continue Reading
How to use a SQL Server create database script to set up databases

You can create SQL Server databases manually, but knowing how to do a scripted database setup is valuable. Here are the steps involved in executing a create database script. Continue Reading

View All Get Started

Evaluate SQL Server Data Warehousing Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

How Azure SQL DW Gen2 boosts cloud data warehouse's performance

The Gen2 version of Azure SQL Data Warehouse gives Microsoft's cloud data warehouse a shot in the arm on performance, making it more competitive with rival technologies. Continue Reading
Microsoft Cosmos DB takes Azure databases to a higher level

Azure Cosmos DB brings a new element to the database lineup of Microsoft's cloud platform, offering multiple data models and a scalable environment for distributed applications. Continue Reading
Expect big data doings at upcoming Microsoft Ignite conference

Ignite 2017 and the Microsoft data portfolio are the topics of this edition of the Talking Data podcast. On tap is a closer look at Azure Cosmos DB. Continue Reading

View All Evaluate

Manage SQL Server Data Warehousing

Learn to apply best practices and optimize your operations.

New SQL Server 2017 features give good reasons for fast upgrades

The new SQL Server 2017 adds support for Linux and a variety of other new features that could justify upgrades to the revamped database platform, even coming so soon after the 2016 release. Continue Reading
Conquer real-time operational analytics in SQL Server 2016

Analytics helps improve business operations, and SQL Server 2016 users can master it -- in real time, using operational data in a transactional database. Continue Reading
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

View All Manage

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

View All Problem Solve