SQL Server Business Intelligence (BI) and Data Warehousing
New & Notable
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.
SQL Server Business Intelligence (BI) and Data Warehousing News
-
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.
-
November 09, 2017
09
Nov'17
Microsoft boosts SQL Server machine learning services
Python and R are among the tools in the SQL Server machine learning toolkit. Native T-SQL scoring is also on the agenda, as uncovered at PASS Summit 2017.
-
November 06, 2017
06
Nov'17
Power BI updates drive Microsoft's latest hybrid cloud efforts
At PASS Summit 2017, Microsoft Azure's strides were measured in steps. These include Power BI updates that bring cloud reporting services down to earth.
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
-
How much do you know about the components of SQL Server?
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
-
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 Business Intelligence (BI) and Data Warehousing Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
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
-
Power BI Report Server adds new Power BI reporting options
Updates to Power BI Report Server expand the on-premises platform's reporting functionality and increase the number of data sources users can connect to when building Power BI reports. 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
Manage SQL Server Business Intelligence (BI) and 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
-
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
-
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
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