The official SQL Server AlwaysOn team blog.
Matt Neerincx from the SQL Server Data Programmability team discusses installing thelatest AlwaysOn features for ADO.NET. Demonstrates how to install the ADO.NET updatesand use the features with SQL Server Management Studio and Visual Studio.
Sorry the current video is corrupted at about 3 minutes, I'm working to get this fixed.
Hi folks, I fixed the video. Note that we just released the .NET Framework 4.0.3 and I recommend you install this update versus the 4.0.2 mentioned in the video. The .NET Framework 4.0.3 has some additional fixes for the MultiSubnetFailover feature to support connecting to clustered named instances as well as some performance improvements for failover.
where do you download 4.0.3 from? and do you need to install on Web servers only? is there a VS2010 also?
The URL is here msdn.microsoft.com/.../hh854775
Likewise you can search by KB number, the numbers are below:
Download the Design-time Update; for more information, see KB2600214
Download the Run-time Update; for more information, see KB2600211
Download the Multi-Targeting Pack; for more information, see KB2600213
To answer your other question:
To update VS2010, install the Design-time update. This enables intellisense for ApplicationIntent and MultiSubnetFailover keywords as well as 4.0.3 targeting ability for VS.NET.
The run time update has to be installed anywhere you run code that uses the ApplicationIntent or MultiSubnetFailover keywords. So for example if you have a Reporting Server you would need to apply this patch to the Reporting Server host to enable uploading reports that use these connection string keywords.
Likewise, if you have an IIS web application you need to apply run time update to get IIS applications to use the keyword.
You would also install this on your development box or any machine that you want to use SSMS to connect using these keywords. The Design-time Update only has to be applie