SQL Server Business Intelligence (BI) and Data Warehousing News
September 30, 2016
The big data movement has frozen out many data professionals who are versed in SQL. Microsoft's U-SQL programming language tries to get such folks back in the data querying game.
July 21, 2016
As Azure SQL Data Warehouse reaches general availability, it brings massively parallel processing to a wider audience, and augers more competition in the cloud data space.
May 13, 2016
SQL Server 2016 is on the launch pad for a June 1 release with a number of notable built-in features along with improvements to some long-neglected capabilities.
October 21, 2015
Microsoft announced that it had enabled an auditing feature for the Azure SQL Data Warehouse. The new feature has many benefits, but storing audit logs won't be free.
SQL Server Business Intelligence (BI) and Data Warehousing Get Started
Bring yourself up to speed with our introductory content
A need for data warehouses designed for large-volume data loading and complex analytical workloads led to Microsoft's Analytics Platform System. Continue Reading
A data warehouse is a central repository for all or significant parts of the data that an enterprise's various business systems collect. Continue Reading
Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool that is built into Microsoft's SQL Server database. Continue Reading
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Evaluate SQL Server Business Intelligence (BI) and Data Warehousing Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Like other cloud services, cloud data warehouse platforms can offer potential savings, faster rollouts and the ability to scale up or down easily -- but there are challenges, too. Continue Reading
Microsoft SQL Server 2016 will be released next year. But in 2015, we've already had a glimpse into improved in-memory OLTP, security features, analytics and Stretch Database. Continue Reading
With PolyBase, when you use SQL Server 2016 as your data source, you have easy access to Hadoop and Azure Blob Storage data from whatever environment you're working in. Continue Reading
Manage SQL Server Business Intelligence (BI) and Data Warehousing
Learn to apply best practices and optimize your operations.
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
Microsoft has added Distributed Transaction Coordinator support, optimized log transport and other features to AlwaysOn Availability Groups in SQL Server 2016. Continue Reading
Community Technology Previews show the creation process for Microsoft SQL Server 2016. SQL Server experts Denny Cherry and Joey D'Antoni share what they've learned in beta testing. 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