SQL Server Business Intelligence (BI) and Data Warehousing
New & Notable
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
-
data mining
Data mining is the process of sorting through large data sets to identify patterns and establish relationships to solve problems through data analysis. Continue Reading
-
data preprocessing
Data preprocessing describes any type of processing performed on raw data to prepare it for another processing procedure. Continue Reading
-
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
Evaluate SQL Server Business Intelligence (BI) and Data Warehousing Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
Evaluate Grafana vs. Kibana for IT data visualization
Take a deep dive into how Grafana and Kibana can help IT admins visualize critical system data through this database monitoring example. Continue Reading
-
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
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.
-
Forget monitoring alerts, turn to IT root cause analysis
Alerts get your attention, but they don't always tell you where the core of a problem is to be found. Maybe it's time to shift your IT management strategy. Continue Reading
-
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