SQL Server Data Warehousing
New & Notable
SQL Server Data Warehousing News
-
February 12, 2019
12
Feb'19
Talend Stitch tools load data to Azure SQL Data Warehouse
Cloud data warehouses see serious data transformation work moving to the cloud. Talend's first integration with Stitch, which it recently bought, reflects the trend.
-
November 27, 2018
27
Nov'18
Microsoft Azure SQL Database and Oracle 19c start to rev
A new Microsoft Azure SQL Database Managed Instance service seeks to span the gap between cloud and on-premises systems. Meanwhile, Oracle also has cloud plans of the data kind.
-
November 12, 2018
12
Nov'18
Enterprise Power BI platform advances with SSRS, 'dataflows'
Microsoft embeds its SSRS reporting software and more-advanced data preparation tools in Power BI, part of a plan to blend self-service and enterprise BI for users.
-
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.
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
-
database (DB)
A database is a collection of information that is organized so that it can be easily accessed, managed and updated. 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
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
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
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
-
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
-
Using SQL Server Management Studio Table Designer to create a table
Creating a table correctly in SQL Server can be pretty tricky, but using SQL Server Management Studio Table Designer makes it easier. Continue Reading