Windows Phone 8 SDK on Windows 8 32-bit?

Windows Phone 8 SDK cannot be installed on Windows 8 32-bit machines instead it requires 64 bit. This is because Hyper-V Emulator can run only on 64 bit systems. Also because of 32 bit OS cannot address more than 3GB RAM.

SFTP using SSIS 2008 & 2008 R2

SSIS doesn't have a built-in component to support SFTP but the following codeplex component can be used or create a script task and write the SFTP file retrieval.

http://ssissftp.codeplex.com/

Note:

• Copy the SSISSFTPTask100.dll to C:\Program Files(x86)\Microsoft SQL Server\100\DTS\Tasks\
• Register the SSISSFTPTask100.dll in the GAC using gacutil.exe (available under C:\Program Files(x86)\Microsoft SDKs\Windows\v7.0A\Bin)
• Open BIDS and click Tools > Choose Toolbox items > SSIS Control Flow Items > SFTP Task (Note: The SFTP Task will appear only if the SSISSFTPTask100.dll has been successfully registered in the GAC.

Your current security settings do not allow this file to be downloaded

I get the above error when trying to download files from codeplex on a VM (Windows server 2008 R2) on IE9.

Solution

• Open Internet Explorer.
• Click Tools and then options.
• Click on the security tab.
• Select the Internet Zone.
• Click on the Custom Level Button and then scroll down to Download.
• Make sure to enable File download.
• Click Apply and Ok

Pluralsight for MSDN Subscribers Worldwide

Back in June, Pluralsight announced special training benefits (Videos) for MSDN Subscribers. This was only for US MSDN subscribers.

Microsoft and Pluralsight were receiving feedback and comments from MSDN subscribers from other countries and now they have expanded the benefits to MSDN subscribers world wide.

So hurry up and get benefited by December 11, 2012 using your MSDN Subscriber ID. You can view this by logging on to your MSDN Site.

Courses that are included:

• Agile Team Practices with Scrum
• ALM for Developers with Visual Studio 2012
• ALM with Team Foundation Server 2010
• ALM with TFS 2012 Fundamentals
• Building Windows 8 Metro Apps with C# and XAML
• Building Windows 8 Metro Apps with C++ and XAML
• C# Fundamentals - Part 1
• C++ Fundamentals
• Continuous Integration
• Developing for Windows 7
• Intellitrace
• Introduction to .NET Debugging using Visual Studio 2010
• Introduction to Building Windows 8 Applications
• Introduction to Microsoft Fakes
• Introduction to Visual Studio 2010 - Part 1
• Introduction to Visual Studio 2010 - Part 2
• Introduction to Visual Studio 2012 - Part 1
• Introduction to Windows 7 Development
• Kanban Fundamentals
• Solution Modeling with UML in Visual Studio 2010
• Test First Development - Part 1
• Test First Development - Part 2
• Web Application Performance and Scalability Testing
• Windows Azure Diagnostics
• Windows Phone 7 Basics

Database Cannot be opened because it is version 706. This server supports version 661 and earlier

When I tried attaching a mdf file using SQL SERVER 2008 R2 I got the following error:

"Attach Database failed for Server "XXXXXX"

Database cannot be opened because it is version 706. This server supports version 661 and earlier

Solution

This is because the database I was trying to attach is SQL Server 2012. The only way to resolve this is to Generate Script from SQL Server 2012 then run it in SQL Server 2008 R2. This needs to be done for data too.