SQL Server Business Intelligence (BI) and Data Warehousing

New & Notable

Download this free guide

Free Guide: DBMS Features Overview for 3 New Popular Options

IT expert Michael Otey, explores 5 trends for SQL Server environments, what to expect in SQL Server 2019 and why it might be time to update SQL Server skills. Also, compare the key features of Google Cloud Spanner and Oracle Database 19c.

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 Business Intelligence (BI) and 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 Business Intelligence (BI) and 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
FileMaker (FMP)

FileMaker is a relational database application in which an individual may design -- and easily share on the Internet -- a database file by starting with a blank document or implementing ready-made and customizable templates. Continue Reading
pivot table

A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report. 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.

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
A quick tutorial on SQL Server maintenance plans

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
Common Data Service for Analytics eases Power BI integration

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.

How to integrate Power BI and SharePoint via embedded reports

Expert Brien Posey explains two methods for including Power BI reports on pages in SharePoint Online's cloud service: publishing a link to a report, or embedding one. Continue Reading
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
The ins and outs of using R in SQL Server 2016 and 2017

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

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.

The top three SQL Server third-party tools

Basit Farooq presents his top three SQL Server third-party tools for identifying and resolving SQL Server bottlenecks. Continue Reading
Using Power BI to enhance SQL Server self-service business intelligence

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
Managing data with Enterprise Integration Management and SQL Server

Microsoft tools for SQL Server can help build a comprehensive enterprise integration management platform. Continue Reading