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.
Microsoft recently released Team Foundation Server 2013 Power Tools which includes best practices analyzer, check-in policies, process template editor, storyboard shapes, command line tool, Windows PowerShell Cmdlets, Windows Shell extension and work item templates.
The Microsoft.Bcl.Build package has been updated with support for conditional import and several improvements to those projects which are built using Visual Studio.
Microsoft has had several big announcements for developers: Visual Studio 2013RC is available for download now. Accompanying this release is the availability of Windows 8.1 RTM for developers that subscribe to MSDN or TechNet. This reverses the previous Microsoft position that app developers would have to wait until general availability to get access to a production system.
Microsoft and Google are working together in a fight for greater transparency on Foreign Intelligence Surveillance Act (FISA) orders. Not satisfied with the limited out of court agreement that’s already been reached with the US government to disclose summary data relating to national security requests, the two companies are now taking legal action and lobbying for support from Congress.
Within days of each other, Microsoft and Amazon Web Services (AWS) released mobile-friendly notification services aimed at developers. Both services make it possible to quickly and cheaply broadcast millions of messages to devices of all kinds. While similar on the surface, each service offers their own unique capabilities.
T4 Editor 2.2.0 enables you to create a library of reusable snippets in addition to an ability to make use of project properties with include and assembly directives, which works not only in the standard IDE but also in the msbuild host. It also includes support for Visual Studio 2013 Preview, new template gallery and F1support for directives.
NuGet 2.7 release was announced this week, with several performance improvements, new extensibility APIs, command-line restore, configuration defaults and several other features. In addition, a package recommendation service, called NuGet Concierge has been launched.