Handling the SQL Server bigint data type in Access 2007 using ADO

Today’s guest blogger is Vinny Malanga. Vinny is the CTO of IMI Software, Inc. , which specializes in software development for the property management industry.

See the original post here:
Handling the SQL Server bigint data type in Access 2007 using ADO

Sample: Identity and Access Strategies for SharePoint Server 2007

Learn how Windows SharePoint Services 3.0 and SharePoint Server 2007 use membership and role providers and how to automatically configure providers into SharePoint Server so it can manage the configuration settings.

Here is the original post: 
Sample: Identity and Access Strategies for SharePoint Server 2007

SQL Server 2008 Enterprise Evaluation VHD

This download comes as a pre-configured VHD. This download enables you evaluate the SQL Server 2008 Enterprise Evaluation Edition VHD for 60 days.

Original post: 
SQL Server 2008 Enterprise Evaluation VHD

Synchronize with SharePoint under the hood

Recently I was asked the following question: I am looking to get an understanding of the internal operations during an Access 2007 synchronize execution. I have just been exposed to a SharePoint MOSS and Access 2007 environment where at times the normal sync time goes from 7-minutes to around an hour. I am taking the side of “network bandwidth” as the reason and not the side of “data quantity” as the root cause for the increased time.

The rest is here:
Synchronize with SharePoint under the hood

Microsoft SQL Server 2008 Books Online (May 2009)

Download the documentation and tutorials for Microsoft SQL Server 2008.

See original here:
Microsoft SQL Server 2008 Books Online (May 2009)

Paul Stubbs : SharePoint 2010 and SQL Server better together

Today the SharePoint team announced that SQL Server will be a prerequisite for SharePoint 2010.

Read more:
Paul Stubbs : SharePoint 2010 and SQL Server better together

SQL Server 2008 Developer Training Kit

The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008.

View original here: 
SQL Server 2008 Developer Training Kit

New STSADM commands with SharePoint SP2

Use the variationsfixuptool operation    This article describes how to use the Stsadm variationsfixuptool operation, which lets farm administrators control and perform operations against variations. Pre-upgrade scanning and reporting for future releases (Office SharePoint Server)    This article describes how to use the Stsadm preupgradecheck operation to scan farm servers before starting an upgrade to ensure that some upgrade prerequisites are met and to detect known issues that can prevent the upgrade from completing successfully

See more here: 
New STSADM commands with SharePoint SP2

Excel Services Getting Started – Pt2 UDFs

This continues my previous checklist on getting started with Excel Services. Here, I’ll append a walkthrough for creating, deploying and updating User-Defined Function assemblies with Excel Services. 4.

View post: 
Excel Services Getting Started – Pt2 UDFs

Excel Services Setup and Getting Started

As part of an internal prototype I was working on recently, I had to set up a machine for Excel Services – and do this repeatedly as my prototype messed up the installation in various ways. I found lots of MSDN documentation that covered all aspects of setting up the base server OS, setting up MOSS, and configuring MOSS for Excel Services in a multitude of possible configurations – but what I wanted was a nice concise checklist so that I could reliably setup an E/S box whenever I needed to

Here is the original:
Excel Services Setup and Getting Started