DatabaseDevelopment

SQL Server Data Tools – September 2012 update is now available!

New updates are now available for SQL Server Data Tools (SSDT). The latest update is called SQL Server Data Tools – September 2012. You can get the update from here:

SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015

SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014

As posted on the following blog post, here is a recap of what’s new:

“What’s New?

Visual Studio 2012

In keeping with our goal of supporting the most recent version of Visual Studio, this release of SSDT supports the Visual Studio 2012 shell. SSDT – September 2012 contains several bug fixes to the SSDT version that shipped in Visual Studio 2012 and this release can be applied as an update on top of Visual Studio 2012 Professional, Premium, and Ultimate Editions. If one of these SKUs is not present on the box, running the SSDT installer for Visual Studio 2012 will lay down a standalone version of SSDT for the Visual Studio 2012 Integrated Shell.

Keep in mind that the underlying engine and functionality for SSDT – September 2012 is the same for both Visual Studio 2010 and Visual Studio 2012, so you don’t need to upgrade to Visual Studio 2012 to use the latest version of SSDT. If you wish to have both shells of SSDT in your environment, they can exist side by side and SSDT projects will successfully round-trip between both shells.

LocalDB Configuration Improvements

We received feedback that SSDT’s policy of creating a new localdb instance for each SSDT solution was too verbose, so we created a single localdb instance called Projects to host all the project debug databases. We’ve also enhanced SQL Server Object Explorer by surfacing the default localdb instance and enabling the deletion of localdb instances.

Support for ANSI_NULLS and QUOTED_IDENIFIER Properties

In previous releases, SSDT didn’t support database objects with non-standard ANSI_NULLS or QUOTED_IDENTIFIER properties. SSDT – September 2012 has enabled this scenario by adding support for ANSI_NULLS and QUOTED_IDENTIFIER properties on project and script files.

Updated Data-Tier Application Framework

SSDT – September 2012 includes the latest redist of SQL Server Data-Tier Application Framework (DACFx), which contains several feature enhancements and bug fixes. Most notably, the updated DACFx version enables packaging and deploying data using SqlPackage.exe. You can learn more about the new DACFx release here.

Updated SSDT Power Tools

The September 2012 update is compatible with updated Power Tools that include new features and support for both Visual Studio 2012 and Visual Studio 2010 shells.

SSDT Power Tools for Visual Studio 2012

SSDT Power Tools for Visual Studio 2010

Bug fixes to customer-reported issues

This release includes many bug fixes for issues reported by customers using SSDT RTW or Visual Studio 2012 RTM. Here are some of the most impactful bugs that this release addresses:

· Unable to override Publish Profile properties when using the msbuild command line

· Slow performance on "Add New Item" from SSDT project

· Absence of debugger functionality due to errors in assembly registration

· Publish fails with no message when "extended verification" is disabled

· SSDT overwrites Visual Studio shortcut on Windows8

· Steps to edit and save a Publish Profile editor aren’t intuitive”

CloudDatabaseDesignDevelopment

Top 12 of Visual Studio 2012

I’ve been using Visual Studio 2012 for just over a week now and I’m really liking all the new features and functionality that comes with it. However I’m still not a huge fan of the new light/dark themes. I would like to use the Dark theme, but find it’s just too dark. It would be nice if they made it a few shades lighter.

Anyway I came across the following blog post on Jason Zander’s blog about the Top 12 of Visual Studio 2012 and I thought I would share it.

In summary, with Visual Studio 2012 you can:

  1. Develop for Windows 8
  2. Develop for the Web
  3. Developer for Windows Phone 8
  4. Develop for Windows Azure
  5. Develop Business Applications
  6. Develop Games and other 3D Applications
  7. Take advantage of the latest language enhancements
  8. Performance, Reliability and Compatibility Improvements
  9. New IDE Productivity Features
  10. Improve your code quality with enhanced testing tools
  11. Reduce cycle times using tools for agile practices
  12. Deliver Cloud-Based Services with Smoother Collaboration between Operations and Engineering

Checkout Jason Zander’s blog post for the full article the Top 12 of Visual Studio 2012.

If you have access to Visual Studio 2012, I highly recommend you give it a try. You can always work in both Visual Studio 2010 and 2012 as they are backwards compatible with one another.

Happy Coding!

AviationGames

C-46 Comes to Microsoft Flight

c-46The C-46 has arrived! I know I know I know, how is it possible that new content has appeared for Microsoft Flight after development was discontinued? Well it seems as though this aircraft was complete, but they still needed to do the paperwork to get it released.

You can read more about the release of the C-46 on Microsoft Flight here and here.

This plane was originally built as a cargo and troop transport during WWII. This twin engine aircraft can carry up to 17,000 lbs of fuel and cargo to almost any remote and rugged landing strip. It has a relatively high cruising speed of 200 kts and a maximum range of 1500 miles. This makes it the perfect cargo aircraft for Alaska.

Features

  • Authentic Model: Beautifully rendered exterior of the C-46 and its Pratt and Whitney R-2800 engines give you a realistic experience.
  • Great Cargo-Carrying Capability: Over 17,000 pounds of fuel and cargo capacity allows flexibility and efficiency in completing jobs.
  • No cockpit view is included.

Final Thoughts

I think this is a great addition to Microsoft Flight and is an aircraft I look forward to flying. It’s too bad that there is no cockpit view.

I know I’ve mentioned this in the past, but I really wish there was a way for the community and 3rd party vendors to create additional content (aircraft, maps, etc) for Microsoft Flight.

Happy Flying!

References

Development

Visual Studio 2012 Now Available

IC611657

Today Microsoft has made Visual Studio 2012 and all it’s related products available to download. You should note that with the 2012 edition, Team Foundation Server Express is available. Sweet!

Download and try it today

Attend the launch event on September 12

Development

Visual Studio 2012 Completed! Launches Sept 12!

vs2012Logo
Today Microsoft signed off on the final version of Visual Studio 2012 and the .NET Framework 4.5. In a blog post on the official Visual Studio blog, Microsoft said Visual Studio 2012 will be made available to MSDN subscriptions on August 15 and that it comes with a free one year developer account for the Windows Store in Windows 8.

Microsoft plans to launch Visual Studio 2012 in a virtual event on September 12. Details are to come, so mark your calendars and check the website for further details.

MS_VS2012LaunchBanner

Here is a sample screenshot of the final build of Visual Studio 2012. Notice that the menu bar text is still in uppercase. I read somewhere that there is supposed to be an option to configure this and use mixed case instead. Either way I’m happy. I firmly believe in the Metro design, so will be leaving it as is. I may however use the dark theme.

vs2012 RTM

I’m looking forward to getting the bits on August 15th and turning my ideas into software.

Technology

Windows 8 and Windows Server 2012 RTM

Today was a big day for Microsoft. They officially released Windows 8/RT and Windows Server 2012 to manufacturing and as expected, the final build number is 9200.

dd566ae7-132c-4db0-9e76-277a67f37a66

Availability

The OS launches to the general public on October 26, which is also the same day you can get your hands on a Windows Surface tablet. I can’t wait to try one out.

As with this announcement, the Windows Store is also open for submission of paid applications.

If you’re a developer, then you will be able to get Windows 8 from your MSDN or TechNet subscription starting on August 15.

Pricing

You can either upgrade for $39.99 (US) or with a purchase of a new PC. If you happen to buy a new PC from now until January with Windows 7, you will have the opportunity to upgrade to Windows 8 Pro for $14.99 (US).

I’m looking forward to trying the final version of Windows 8.

Development

Clean Project–Cleans Visual Studio Solutions

How many times have you tried to upload or email your Visual Studio solution, only to find out that your zip file contains files and folders that you didn’t mean to include, like the bin, obj and other folders. What about source control bindings? Yes that too will get included.

Well I came across a great utility called Clean Project from Ron Jacobs that cleans your Visual Studio solutions so you can quickly upload or email.

This functionality is available inside Visual Studio and also from the Windows Shell.

Getting Started

You can install CleanProject from Tools –> Extensions Manager in Visual Studio. Then search for CleanProject. In the References section below I listed links to other locations you can download the project from.

sshot-278

Emailing A Solution

If you want to email your solution:

  1. Select Tools –> Clean, Remove Source Bindings and Zip Solution
  2. Attach the zip file to your email and send

CleanProjVS

Windows Shell Folder Command

You can also run CleanProject from the Windows Shell. Just right click the folder you want to clean and select Clean, Remove Source Binding and Zip Solution from the context menu.

sshot-279

Resources

 

Thanks Ron Jacobs for your hard work on this utility. I look forward to further enhancements and/or other tools in the future.