Visual Studio 2012 & 2013 both receive new enhancements. Visual Studio Tools for Git hits the 1.0 milestone and is now available for VS2012. And a couple of IDE enhancements help VS2013 RTM evolve.
The recently released Visual Studio 2013 includes new project templates with several improvements which enables developers to build projects and applications faster.
The arrival of VS2013 RTM brings several performance enhancements to production. Microsoft intends for these to benefit all developers using larger solutions. Complementing this are several more refinements for C++ developers over what was found in VS2012.
Microsoft has released Visual Studio 2013. All versions are available for download to MSDN subscribers and the general public.
Windows 8.1 ships with new features and improvements with which XAML developers will be able to build unique and responsive applications using Visual Studio 2013. It also adds several new controls and enhancements to project templates.
Patrick Smacchia has recently announced NDepend 5.0, the latest version of his .NET code analyzer coming with a number of enhancements: support for VS 2013, trend monitoring, new dashboard and a major UI facelift.
Telerik has released Visual Studio extension for Icenium which enables developers to build iOS and Android cloud based apps from within the IDE. It also includes simulators which can be accessed directly from within Visual Studio.
One of the biggest challenges when researching a new technology is determining where to start. A typical SQL Server installation could easily have hundreds of tables. Examining each one by hand to determine which would benefit from conversion, is a daunting challenge. This is where the AMR Tool comes into play.
In this report we look at the internals of SQL Server’s In-Memory OLTP to see how it uses timestamp-like transaction ids in lieu of locks.
SQL Server 2014 will offer Clustered Columnstore Indexes. These will offer the performance and compression benefits of column-oriented storage without the need to restrict the underlying table to read-only access.
PowerShell Tools for Visual Studio has been released with features such as syntax highlighting, IntelliSense, code folding, function navigation, script Output in addition to support for breakpoint, locals, stack frame and project system.
Originally this report was titled “Natively Compiled Queries”, but that doesn’t do justice to how deep this runs. When a memory optimized table is created, SQL Server will create a DLL specifically for that table. All data access for the table, including indexes, occurs through this DLL.
SQL Server 2014’s Memory Optimized Tables handle indexes very differently than traditional tables. First and foremost, you must have at least one index and cannot have more than eight indexes. Only the primary key can be marked as unique and don’t even think about foreign keys or filtered indexes.
Visual Studio 2013 is integrating a revised Notification Center to inform when updates are available and quickly prioritize their importance.
In SQL Server 2014 Microsoft will be unveiling its lock-free technology known as Memory Optimized Tables. Using a new storage and query subsystem, these represent a radical departure from traditional database design.