Nov 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQLAuthority News – Implementing a Microsoft SQL Server Parallel Data Warehouse Using the Kimball Approach

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download, SQL White Papers
This white paper explores how the Kimball approach to architecting and building a data warehouse/business intelligence (DW/BI) system works with Microsoft’s Parallel Data Warehouse, and how you would incorporate this new product as the cornerstone of your DW/BI system. For readers who are not familiar with the Kimball approach, we…
Read More

SQLAuthority News – Automation of Data Mining Using Integration Services

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download, SQL White Papers
This article is a walkthrough that illustrates how to build multiple related data models by using the tools that are provided with Microsoft SQL Server Integration Services. In this walkthrough, you will learn how to automatically build and process multiple data mining models based on a single mining structure, how…
Read More

SQLAuthority News – Whitepaper – Running SQL Server with Hyper-V Dynamic Memory Best Practices and Considerations – Consolidating Databases Using Virtualization Planning Guide

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download, SQL White Papers
I was recently looking for best practices for Hyper-V and SQL Server and I ended up whitepaper which was published in July earlier this year. I really wish I had come across this whitepaper earlier but any way still it is better to be late then never. Download Running SQL…
Read More

SQLAuthority News – Download Whitepaper – SQL Server 2008 R2 Analysis Services Operations Guide

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download, SQL White Papers
SQL Server Analysis Service (SSAS) has been always interesting subject for research. Analysis Services cubes are a very powerful tool in the hands of the business intelligence (BI) developer. They provide an easy way to expose even large data models directly to business users. Microsoft has published very informative white…
Read More

SQLAuthority News – Download Whitepaper Using SharePoint List Data in PowerPivot

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL White Papers
One of the many features of Microsoft SQL Server PowerPivot is the range of data sources that can be used to import data. Anything, from Microsoft SQL Server relational databases, Oracle databases, and Microsoft Access databases, to text documents, can be used as data sources in PowerPivot. In this paper,…
Read More

SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide

Pinal Dave
SQLAuthority News
Business Intelligence, Data Warehousing, SQL Documentation, SQL Server, SQL White Papers

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/gg605238(v=msdn.10)?redirectedfrom=MSDN I am very excited that Fast Track Data Warehouse 3.0 reference guide has been announced. As a consultant, I have always enjoyed working with Fast Track Data Warehouse project as it truly expresses the potential of the SQL Server Engine. Here are a few details of the enhancement of the Fast Track Data Warehouse 3.0 reference architecture.

Read More