SQL White Papers Archives - Page 4 of 13 - SQL Authority with Pinal Dave

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

September 18, 2011

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…

SQLAuthority News – Automation of Data Mining Using Integration Services

September 18, 2011

Pinal Dave

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…

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

September 5, 2011

Pinal Dave

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…

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

June 25, 2011

Pinal Dave

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…

SQLAuthority News – Download Whitepaper Using SharePoint List Data in PowerPivot

June 19, 2011

Pinal Dave

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,…

SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide

March 5, 2011

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.

SQL SERVER – IO_COMPLETION – Wait Type – Day 10 of 28

February 10, 2011

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL White Papers

For any good system three things are vital: CPU, Memory and IO (disk). Among these three, IO is the most crucial factor of SQL Server. Looking at real-world cases, I do not see IT people upgrading CPU and Memory frequently. However, the disk is often upgraded for either improving the…