Sample: Creating a .NET Connectivity Assembly for Business Connectivity Services by Using Visual Studio 2010

Explore the code as you learn to create a BDC model that uses BCS entities in Visual Studio to access a matrix in SQL Server. Author: Martin Harwar (Other)

Read the original here:
Sample: Creating a .NET Connectivity Assembly for Business Connectivity Services by Using Visual Studio 2010

Create SQL Server Compact Edition Database with VBA

In a previously post I wrote about how we can retrieve data from a SQL Server Compact Edition (SSCE) database with ADO and Excel.

Here is the original post:
Create SQL Server Compact Edition Database with VBA

Microsoft® SQL Server® 2008 R2 Feature Pack

The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2.

Read more here: 
Microsoft® SQL Server® 2008 R2 Feature Pack

SQL Server 2008 R2 Express Database Size Limit Increased to 10GB

Great news for SQL Server Express users today! We increased the maximum database size in SQL Server 2008 R2 Express from 4GB to 10GB . You can try it out today – just go to SQL Server 2008 R2 Download Page and select “SQL Server 2008 R2 Express” from the menu on the left side of the page: http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx   FAQ Is the database size limit increased in all editions of SQL Server 2008 R2 Express? Yes, SQL Server 2008 R2 Express with Tools and SQL Server 2008 R2 Express with Advanced Services will allow 10GB databases as well.

Read more from the original source: 
SQL Server 2008 R2 Express Database Size Limit Increased to 10GB

Power Tip: Become an early Business Intelligence adopter or fall behind

Today’s guest blogger is Access MVP Garry Robinson, who offers the Smart Access collection of articles at http://www.vb123.com/kb . Excel 2010 is coming and your boss and peers might soon start asking questions about Business Intelligence and Data Mining. This leaves the Access professional looking a little behind the times unless you adapt to this new area.

Original post:
Power Tip: Become an early Business Intelligence adopter or fall behind

Walkthrough of enabling CRUD for SharePoint 2010 external lists using Visual Studio 2010

In our last blog of this series Walkthrough of creating a SharePoint 2010 external list using Visual Studio 2010 Beta , we introduced how to create a simple “Hello world” external list in SharePoint 2010 Beta using Business Data Connectivity Designer in Visual Studio 2010 Beta. In this blog, we will show you how to pull data from an external database into an external list and enable Create, Read, Update and Delete (CRUD) functions to the external list.

Here is the original: 
Walkthrough of enabling CRUD for SharePoint 2010 external lists using Visual Studio 2010

SharePoint 2010 Beta Installation Roundup

Many bloggers are posting their SharePoint 2010 Beta installation experiences, and I have collected all the posts that I could find for my reference as I setup my SharePoint 2010 development rig :  Jie Li’s SharePoint 2010 Pre-Requisites Download Links and  Installation Notice for SharePoint 2010 Public Beta Eric Kraus’ Automated SharePoint 2010 Install with PowerShell Tom Resing’s A SharePoint 2010 Install Experience George Khalil’s Installing SharePoint 2010 Beta on a Windows 2008 R2 Server Alpesh Nakar’s SharePoint 2010 Installation UK SharePoint Team blog’s Installing SharePoint 2010 beta 2 on a single machine Sahil Malik’s SharePoint 2010 Development Environment – Practical Tips Dave McMahon’s SharePoint 2010 – A First Install using Local Accounts SharePoint Team Blog’s Path to User Profile Synchronization success in SharePoint 2010 Beta Geoff Varosky’s SharePoint 2010 Beta 2 Installation and Configuration Visual Tour Travis Nielson’s SP2010: Fixing User Profile Application Service Connection Error René Hézser’s Installing SharePoint 2010 on Windows 7 Anthony Grace’s Install SharePoint 2010 on Windows 2008 Kylie Richardson’s Installing Office Web Apps in a Standalone SharePoint 2010 environment Àlex Peláez’s Installing SharePoint 2010 Beta 2 If you are still deciding between Windows Server or Windows 7, then make sure you read OS Environment Comparison for SharePoint Server 2010 Beta Evaluation . Also don’t forget to read the Installation notice for the SharePoint Server Public Beta on Microsoft Windows Server 2008 R2 and Microsoft Windows 7 from the MS SharePoint Team Blog and SharePoint 2010 Beta Release Known Issues . I’ll also point out all the Microsoft links as well: TechNet’s Installation and Deployment Resource Center for SharePoint Server 2010 (Beta) MSDN’s Setting Up the Development Environment for SharePoint Server TechNet Links Deploy a single server with a built-in database Deploy a single server with SQL server Quick start: Deploy single server in an isolated Hyper-V environment Please comment below if you have know of another Installation walkthrough that I might have missed

Read more: 
SharePoint 2010 Beta Installation Roundup

Linked Tables

Read more here:
Linked Tables

In our previous blog post, we discussed how easy it is to use the Copy/Paste feature of the PowerPivot [aka Gemini] add-in to bring in data from virtually any external source that cannot otherwise be accessed by means of an ODBC, OLEDB or Managed .NET provider. In these scenarios, business users are free to copy new or updated data at any time, but the source of the data is not retained in the model itself, and so multiple copies may need to be manually performed over the model’s life span in order to reflect changes to the sources. Now consider the following business scenario: an analyst needs to produce a forecast of their company’s sales by product over the next year.

The New Package; Windows 7, VS.NET 2010 and Office 2010

To create a workable structure I have always grouped individual new versions of Windows, VS.NET, VSTO and Office together.

Continued here: 
The New Package; Windows 7, VS.NET 2010 and Office 2010

SharePoint 2010

This is my third and final post as part of our disclosure of SharePoint 2010 today. The previous posts covered the SharePoint History and how we Engineer SharePoint

Original post:
SharePoint 2010