Browse by Tags

  • Blog Post: Which SQL Server 2008 R2 Edition is right for your Project Server & SharePoint 2010 Farm?

    A common question I have been hearing from some of you, hopefully these documents will help answer the question: http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx For instance for Analysis Services between the Enterprise and Standard edition, here is what you get: Also read this whitepaper...
  • Blog Post: Introducing Microsoft SQL Server 2008 R2

    As announced today Free ebook: Introducing Microsoft SQL Server 2008 R2 , a must read for all partners and customers out there. This upcoming release of SQL will definitely bring value to the EPM farms out there. Some quotes from the book to wet your appetite an will make you want to seriously consider...
  • Blog Post: Under the Table – How Data Access Code Affects Database Performance

    Just read this great article from Bob Beauchemin in MSDN Magazine: How Data Access Code Affects Database Performance . It’s a great reminder when you do customization why using stored procedure to access your database is a must compared to building queries on the fly within your C# code for instance...
  • Blog Post: SQL Server 2008 R2 CTP Released

    The Community Technology Preview (CTP) was released this morning to TechNet and MSDN subscribers. The Self-Service Business Intelligence aspect of this next SQL released due next year could be a major enhancement to Project Server reporting. To learn more: http://www.microsoft.com/sqlserver/2008/en/us...
  • Blog Post: SQL Server 2008 R2

    Announced today at TechEd: SQL Server 2008 R2 , will be a great enhancement to Project Server deployment from a reporting perspective, why? Check the following preliminary resources (more info here: R2 Benefits by Workload ): Self Service Analysis with “Project Gemini” Self Service Reporting with SQL...
  • Blog Post: SQL Server 2008 Service Pack 1 (SP1)

    SQL Server 2008 Service Pack 1 (SPI) is available and ready for download here (includes a pointer to the Release Notes ). Related links: Why consider SQL Server 2008 for your EPM farm? Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports
  • Blog Post: Inventory of SQL Databases in a Typical Project Server Deployment

    I have recently seen this question on how many databases are created once the Project Server and Project Portfolio Server are installed? My first answer was: “it depends!” Here is why. Assume we are installing both Project Portfolio Server and Project Server on a SharePoint Server farm and that they...
  • Blog Post: How to upgrade your existing Microsoft Project VPC running on SQL 2005 to SQL Server 2008

    I’m sure you have seen these cool SQL Reporting Services 2008 reports: Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports and would like to do the same in your favorite EPM demo VPC or you just have plenty of free time during this time of the year and you are looking for a fun...
  • Blog Post: Announcing the release of SQL Server 2005 SP3

    Microsoft released today SQL Server 2005 Service Pack 3 (SP3). SQL 2005 version should now be 9.00.4035 . Microsoft SQL Server 2005 Service Pack 3 (SP3) contains hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack 2 from cumulative update package 1 to cumulative...
  • Blog Post: Microsoft SQL Server Reporting Services 2008 – Sample Project Server Reports

    Following the release of this sample SQL Server Reporting Services 2005 report pack: New SQL Reporting Services Sample Reports for Project Server , I have just updated two sample reports ( Risks and Portfolio Status , attached below) to illustrate the use of the Gauge which comes with SQL Server Reporting...
  • Blog Post: Running SQL Server 2008 in Hyper-V Environment

    The SQL has just released the following article: Running SQL Server 2008 in a Hyper-V Environment , Best Practices and Performance Considerations Summary: Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering...
  • Blog Post: Microsoft SQL Server 2008 Upgrade Technical Reference Guide is Live!

    This 490-page white paper covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online...
  • Blog Post: How to configure Project Server 2007 Cube Building Service with SQL Server 2008 Analysis Services

    A lot of you have been asking for it, the TechNet team just published it :) Requirements for using SQL Server 2008 Analysis Services with the Project Server 2007 Cube Building Service and yes Project Server 2007 is supported on SQL Server 2008 as stated here (bottom of the page): http://technet.microsoft...
  • Blog Post: How to secure your Project Server Reporting Services Reports

    It seems SQL Server Reporting Services (SSRS) is broadly used today in Project Server deployments to build custom reports and extract all the gold nuggets from our relational and decisional data stores (SQL Server Analysis Services cubes), specially when I see the success on this post: Services Sample...
  • Blog Post: Newly published content for Office Project Server 2007, week of September 15, 2008

    Key content has just been published on TechNet : Database maintenance plans for Project Server 2007 This chapter describes best practices for creating database maintenance plans for Project Server 2007 databases. Project Server 2007 Hyper-V guide This downloadable, 37-page document provides IT administrators...
  • Blog Post: Recommended number of Project/SharePoint Workspace

    A partner recently asked me the following question: Is there a recommended limit on how many workspaces can be created at one level? First please refer to the following SharePoint documentation on TechNet : Plan for software boundaries (Windows SharePoint Services) Site object Guidelines for acceptable...
  • Blog Post: Project Server and PerformancePoint Server 2007 session at Business Intelligence Conference

    William Brown from Symmetry Corporation and I will be giving the following session at the upcoming Business Intelligence Conference next October in Seattle: Performance Management for Projects using Microsoft Project and Office PerformancePoint Server 2007 Microsoft Enterprise Project Management (EPM...
  • Blog Post: Announcing the release of SQL Server 2008

    It’s official: http://www.microsoft.com/presspass/press/2008/aug08/08-06SQLServer2008PR.mspx Check out the official site: Why consider SQL Server 2008 for your EPM farm? Before upgrading your EPM production farm please wait for the official supportability statements (will also blog about it as usual...
Page 1 of 1 (18 items)