Browse by Tags - SQL Azure Team Blog - Site Home - MSDN Blogs

Browse by Tags

Tagged Content List
  • Blog Post: PowerPivot for the DBA: Part 2

    In this article I am going to continue to tie some simple terminology and methodology in business intelligence with Transact-SQL – bring it down to earth for the DBA. This is a continuation in a s eries of blog posts that I started that equates Transact-SQL to PowerPivot. Measure If you’re not an OLAP...
  • Blog Post: PowerPivot for the DBA: Part 1

    In this article I am going to tie some simple terminology and methodology in business intelligence and PowerPivot with Transact-SQL – bring it down to earth for the DBA. You don’t need to know Transact-SQL to build awesome reports with PowerPivot, however if you already do these articles will attempt...
  • Blog Post: Security Considerations with SQL Azure and PowerPivot

    In this former blog post I discussed how to enable access to SQL Azure from PowerPivot. Now that access is enabled and the data is available to you, let’s examine how PowerPivot and SQL Azure work from a security perspective. Accessing the Data In order to use PowerPivot against your SQL Azure data you...
  • Blog Post: Managing Connections in PowerPivot

    A good friend of mine that analyzes databases with business intelligence for a living has told me that the majority of his job is knowing the data. PowerPivot makes it very easy to add additional tables, and bring together multiple data sources –allowing you to discover your data as you build reports...
  • Blog Post: Getting Started With PowerPivot and SQL Azure

    PowerPivot is a powerful, downloadable extension to Microsoft Excel 2010 that allows you to perform business intelligence and analytics against known data sources. One excellent data source you can use is your SQL Azure database. This article will talk about getting started with SQL Azure as a data source...
Page 1 of 1 (5 items)