Latest Microsoft Blogs

Just ran into this and thought I’d share.  If you are trying to connect to SQL Server from your Web application running on Windows 7 or Windows 2008 R2 and you’re getting a message that looks like this: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. I can probably help you out.  The IIS team made a change to the default identity of the worker process.   Starting with IIS 7.5, Application Pools run with a unique identity based on the Application Pool name, rather than NetworkService – the default identity for IIS6 and IIS7.  The primary reason for...

NOTE: This is “Misfit Data” - While I do work for Microsoft, this data is NOT “official Microsoft” data and is not endorsed or ratified by Microsoft in any way. I built and ran these tests because I was personally curious about comparative performance. If these test results cause you dizziness, vomiting, or other undesired side effects, please discontinue use immediately and consult your physician. How does IMPLEMENTATION Performance Compare ? Usually, when someone creates benchmarks, they are trying to prove that their thing is faster than someone else's thing. I’m PAID by Microsoft to write BOTH PHP and ASP.NET Code. I was doing PHP before .NET shipped. I love them both. This makes it hard for me to say anything good about either one....

The goal of this end to end walkthrough is to create a really simple ASP.NET 4.0 Web Application which uses SQL Server database and is built using Visual Studio 2010 (VS 10)…  The 11 steps in this walkthrough are: 1. Create a new ASP.NET 4.0 Web Application Project (WAP) 2. Create a simple SQL Server Database using SQL Express 3. Add Tables to the Database and set foreign key relationships 4. Add data to the tables created 5. Add a MasterPage and ContentPage to the ASP.NET 4.0 WAP 6. Modify the Master Page to provide consistent look and feel to the site 7. Add datacontrols like GridView and bind them to SQL Express database 8. Add additional web page and use DataView to display more data 9. Use QueryBuilder to fetch data from multiple tables...

Visual Studio 2010 (VS 10) Beta1 was released recently...  You can download VS 10 Beta1 from Microsoft download page …. Do check out the update on Visual Studio features for Web Developers on our team blog… We have been discussing about a bunch of deployment features previously and today we will discuss about Database Deployment with VS 10…. VS 10 will allow you to deploy your databases both while creating a web package as well as while publishing directly to a web server provided by your hoster… To catch up on the previous web deployment posts check out the below links: Web Deployment with VS 2010 and IIS Web Packaging: Creating a Web Package using VS 2010 Web Packaging: Creating web packages using MSBuild How does Web Deployment with...

This month the PDF version is FREE ! http://phparch.com/c/magazine/issue/97 There are SEVERAL articles for Developers working on the Microsoft Platform ! Installing PHP on Windows by Hank Janssen and Pierre A. Joye The Windows version of PHP has always lagged behind the other platforms in terms of features and stability, however, the situation has improved drastically during the last six or so months, with PHP on Windows reaching feature parity with other platforms. Developing with PHP on Windows is now easier than ever and, in some cases, has resulted in important PHP innovations. Learn how you can set up a development environment to compile and develop PHP on Windows within minutes. Introduction to Silverlight and the HTML DOM by Joe Stagner...

Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data. Below are the first seven parts in this series: Part 1: Introduction to LINQ to SQL Part 2: Defining our Data Model Classes Part 3: Querying our Database Part 4: Updating our Database Part 5: Binding UI using the ASP:LinqDataSource Control Part 6: Retrieving Data Using Stored Procedures Part 7: Updating our Database using Stored Procedures In my last two posts ( Part 6 and Part 7 ) I...

Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data. Below are the first five parts of my LINQ to SQL series: Part 1: Introduction to LINQ to SQL Part 2: Defining our Data Model Classes Part 3: Querying our Database Part 4: Updating our Database Part 5: Binding UI using the ASP:LinqDataSource Control In these previous LINQ to SQL blog posts I demonstrated how you could use LINQ query expressions to programmatically retrieve data from a...

Probably the biggest programming model improvement being made in .NET 3.5 is the work being done to make querying data a first class programming concept. We call this overall querying programming model "LINQ", which stands for .NET Language Integrated Query . Developers can use LINQ with any data source, and built-in libraries are included with .NET 3.5 that enable LINQ support against Objects, XML, and Databases. Earlier this summer I started writing a multi-part blog series that discusses the built-in LINQ to SQL provider in .NET 3.5. LINQ to SQL is an ORM (object relational mapping) implementation that allows you to model a relational database using .NET classes. You can then query the database using LINQ, as well as update/insert/delete...

Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to easily model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data. Below are the first four parts of my LINQ to SQL series: Part 1: Introduction to LINQ to SQL Part 2: Defining our Data Model Classes Part 3: Querying our Database Part 4: Updating our Database In these previous LINQ to SQL blog posts I focused on how you can programmatically use LINQ to SQL to easily query and update data within a database. In today's blog post I'll cover the...

Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to easily model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data. Below are the first three parts of my LINQ to SQL series: Part 1: Introduction to LINQ to SQL Part 2: Defining our Data Model Classes Part 3: Querying our Database In today's blog post I'll cover how we we can use the data model we created earlier, and use it to update, insert, and delete data. I'll also show how we can cleanly integrate business rules and custom validation logic...