New & Notable
SQL Server Business Intelligence (BI) and Data Warehousing News
September 25, 2018
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
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
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
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.
SQL Server Business Intelligence (BI) and Data Warehousing Get Started
Bring yourself up to speed with our introductory content
A data warehouse is a federated repository for all the data collected by an enterprise's various operational systems, be they physical or logical. Continue Reading
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
From SQL Server Machine Learning Services to the SQL Server Operating System, there's a lot to know about SQL Server. Test your SQL Server knowledge with our quiz. Continue Reading
Evaluate SQL Server Business Intelligence (BI) and Data Warehousing Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
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
SQL Server maintenance plans get a bad rap, but for DBAs who need a simple way to maintain databases, Microsoft's built-in tools are a good place to start. Continue Reading
Integrating data into Power BI for analysis can be a challenge, but Microsoft's Common Data Service for Analytics technology is designed to simplify the process for users. Continue Reading
Manage SQL Server Business Intelligence (BI) and Data Warehousing
Learn to apply best practices and optimize your operations.
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
What does the R analytics language offer to users, and how does it fit into SQL Server 2016 and 2017? Get answers to those questions and details on Microsoft's various R technologies. Continue Reading
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
Problem Solve SQL Server Business Intelligence (BI) and Data Warehousing Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Basit Farooq presents his top three SQL Server third-party tools for identifying and resolving SQL Server bottlenecks. Continue Reading
SQL Server DBAs and developers should be familiar with Power BI for Office 365. Here's an overview of what it does and how to use it. Continue Reading
Microsoft tools for SQL Server can help build a comprehensive enterprise integration management platform. Continue Reading