Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)
Wednesday, August 19, 2009 2:03 AM

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
Posted by chrisfie | 0 Comments
Monday, August 10, 2009 11:53 PM

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
Posted by chrisfie | 0 Comments
Wednesday, May 13, 2009 8:13 PM

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
Posted by chrisfie | 0 Comments
Filed under: , ,
Wednesday, April 08, 2009 11:48 PM

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
Posted by chrisfie | 0 Comments
Friday, January 16, 2009 9:28 PM

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
Posted by chrisfie | 2 Comments
Wednesday, December 17, 2008 12:29 AM

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
Posted by chrisfie | 0 Comments
Tuesday, December 16, 2008 10:24 AM

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
Posted by chrisfie | 1 Comments
Tuesday, December 09, 2008 9:15 AM

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
Posted by chrisfie | 3 Comments
Attachment(s): ProjetcServer07_SSRS08.zip
Wednesday, November 26, 2008 4:59 PM

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
Posted by chrisfie | 0 Comments
Wednesday, November 26, 2008 4:47 PM

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
Posted by chrisfie | 2 Comments
Friday, November 21, 2008 12:49 AM

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
Posted by chrisfie | 1 Comments
Wednesday, October 22, 2008 6:33 AM

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
Posted by chrisfie | 0 Comments
Saturday, September 20, 2008 1:08 AM

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
Posted by chrisfie | 1 Comments
Tuesday, September 16, 2008 5:50 AM

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
Posted by chrisfie | 0 Comments
Thursday, August 07, 2008 11:35 PM

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
Posted by chrisfie | 1 Comments
More Posts Next page »
 
Page view tracker