SQLAuthority News – Download Whitepaper Using SharePoint List Data in ...

SQLAuthority News – Download Whitepaper Using SharePoint List Data in PowerPivot

6/19/2011

One of the many features of Microsoft SQL Server PowerPivot is the range of data sources that can be used to import dataAnything, 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, I explain one of the [...].

Full story: Journey to SQL Authority with Pinal Dave

Similar articles

Journey to SQL Authority with Pinal Dave

SQLAuthority News – Microsoft WhitePaper on PowerPivot Data Refresh I was recently working at customer location on PowerPivot project. It was quite complected as this is relatively new technology and we all are exploring what this technology can do and what it can bri...

Journey to SQL Authority with Pinal Dave

SQLAuthority News – Whitepaper Download – Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries Size of the database is growing every day. Many organizations now a days have more than TB of the Data in their system. Performance is always part of the issue. Microsoft is really paying attention to...

Journey to SQL Authority with Pinal Dave

SQLAuthority News – Whitepaper – Using the Resource Governor SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on...

Journey to SQL Authority with Pinal Dave

SQLAuthority News – Download Whitepaper – Enabling and Securing Data Entry with Analysis Services Writeback SQL Server Analysis Service have many features which are commonly requested and many already exists in the system. Security Data Entry is very important feature and SSAS supports writeback feature. A...

DotNetShoutout - Latest published stories

Using PowerPivot for SharePoint 2010 | TechBubbles PowerPivot applications are created using Excel 2010 using PowerPivot add-in, You can read my post on configuring PowerPivot in SharePoint 2010 here. After creating a PowerPivot application then you ...

Journey to SQL Authority with Pinal Dave

SQLAuthority News – TechDays Session at Infosys Mysore 2009 – Change Data Capture and PowerPivot It has been a great pleasure to visit Infosys Mysore for an MSDN session. I had previously visited Infosys Bangalore for Technical session. Please read the details of earlier visit SQLAuthority News –...

Comments on this article

Add your comment

Report

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle Part 2 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value Before continuing this blog post – please read the first part of the SEQUENCE Puzzle here A Puzzle – Fun with SEQUENCE in ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value Yesterday my friend Vinod Kumar wrote excellent blog post on SQL Server 2012: Using SEQUENCE. I personally enjoyed reading the c...

Journey to SQL Authority with Pinal Dave

SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117 During my 8 years of career, I have been many times interviewer and quite often interview candidate myself. If I am interviewer ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use th...

Journey to SQL Authority with Pinal Dave

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion Some confusion never go away. Here is the one of the ancient one. Precision of the SmallDateTime is the one concept/confusion I...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Renaming Index – Index Naming Conventions If you are regular reader of this blog, you must be aware of that there are two kinds of blog posts 1) I share what I learn rece...

Journey to SQL Authority with Pinal Dave

SQL SERVER – New Look for CodePlexProject – Hosting for Open Source Software Codeplex is my favorite site. CodePlex is Microsoft’s free open source project hosting site. You can create projects to sh...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST Note: I have used SQL Server 2012 for this small fun experiment. Here is what we are going to do. We will run the script one at ...

Journey to SQL Authority with Pinal Dave

SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server 2012 – Guest Po Nakul Vachhrajani is a Technical Specialist and systems development professional with iGATE having a total IT experience of more...

Journey to SQL Authority with Pinal Dave

SQLAuthority News – SQL Server 2012 Upgrade Technical Guide – A Comprehensive Whitepaper – (454 pages – 9 MB) Microsoft has just released SQL Server 2012 Upgrade Technical Guide. This guide is very comprehensive and covers the subject of ...

SQLAuthority News – Download Whitepaper Using SharePoint List Data in PowerPivot

Similar articles

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

DotNetShoutout - Latest published stories

Journey to SQL Authority with Pinal Dave

Comments on this article

Latest from Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Journey to SQL Authority with Pinal Dave

Sign In