It’s been a bit longer than a month, back when I posted “A Month with BlueMetal”. I’m going on several months now and have started a building process in my own professional development that is down a path that fits right into where I wanted for all the goals I’ve made. Standing by my own quote of, “The last month has done nothing but solidify the fact that joining BlueMetal was, to say the least, a great decision” the feeling is as strong as ever.

Introduction I already wrote about making custom errorpages in Nancy a few months ago. And I used some static htm pages for those and a stream to get them to show on your screen. This was all fine and dandy but I’m sure I can do better. Using RenderView First of all I can make use of the Nancy View Rendereing and make my errorpages RazorViews like the rest of them.

Despite having worked with SQL Server clusters for years, I didn’t pick up the book Pro SQL Server 2008 Failover Clustering and read it cover-to-cover until recently. This is the most comprehensive look at Windows and SQL Server failover clustering that exists. In this book, Allan Hirt (b | t), a clustering expert and Microsoft MVP, lays a solid foundation for all aspects of clustering. The book covers four main areas – the basics of failover clustering, clustering Windows Server 2008, clustering SQL Server 2008, and administration of a clustered SQL Server 2008 instance.

Here is a nice image of all the cool new programmability features and T-SQL enhancements in SQL Server 2014 CTP1, there are no Hekaton (In-memory OLTP) features in this list What, there is nothing there? That is right, besides the Hekaton related stuff there seems to be almost nothing. Some people seems upset about this, I think we will get new programmability features and T-SQL enhancements in the next SQl Server 2014 CTP.

I have been playing around with SQl Server 2014 Hekaton tables and stored procedures. I have noticed that native compiled stored procedures are between 20 and 40% faster than regular stored procedures If you want to test for yourself, then run the following code The codeblock below will create a database with a filegroup where we will store Hekaton tables CREATE DATABASE HekatonDB ON PRIMARY(NAME = [HekatonDB_data], FILENAME = 'C:DBTestHekatonDBHekatonDB_data.mdf', size=500MB), FILEGROUP [HekatonDB_fs_fg] CONTAINS MEMORY_OPTIMIZED_DATA (NAME = [HekatonDB_hk_fs_dir], FILENAME = 'C:DBTestHekatonDBHekatonDB_hk_fs_dir') LOG ON (name = [HekatonDB_log], Filename='C:DBTestHekatonDBHekatonDB_log.

If you are ready to use Hekaton then you need to know that there are some limitations, not all data types are supported. The following list contains the set of supported data types in both Hekaton tables and stored procedures: bit All integer types: tinyint, smallint, int, bigint All money types: money, smallmoney All floating types: float, real Date/time types: datetime2, date, time, datetime, smalldatetime numeric and decimal types All non-LOB string types: char(n), varchar(n), nchar(n), nvarchar(n), sysname

There are 26 new Dynamic Management Views in SQl Server 2014 CTP1. Here is a list of these DMVs in alphabetical order sys.dm_db_merge_requests sys.dm_db_xtp_checkpoint sys.dm_db_xtp_checkpoint_files sys.dm_db_xtp_gc_cycle_stats sys.dm_db_xtp_hash_index_stats sys.dm_db_xtp_index_stats sys.dm_db_xtp_memory_consumers sys.dm_db_xtp_object_stats sys.dm_db_xtp_table_memory_stats sys.dm_db_xtp_transactions sys.dm_io_cluster_shared_volumes sys.dm_os_buffer_pool_extension_configuration sys.dm_resource_governor_resource_pool_volumes sys.dm_xe_database_session_event_actions sys.dm_xe_database_session_events sys.dm_xe_database_session_object_columns sys.dm_xe_database_session_targets sys.dm_xe_database_sessions sys.dm_xtp_consumer_memory_usage sys.dm_xtp_gc_queue_stats sys.dm_xtp_gc_stats sys.dm_xtp_memory_stats sys.dm_xtp_system_memory_consumers sys.dm_xtp_threads sys.dm_xtp_transaction_recent_rows sys.dm_xtp_transaction_stats The DMVs that start with sys.dm_db_xtp or sys.dm_xtp are Hekaton (In-Memory OLTP) specific DMVs The DMVs that start with sys.dm_db_xtp return information about individual Hekaton enabled databases, The DMVs that start with sys.

Microsoft has made available for download CTP1 of SQl Server 2014 Be aware of the following important information Installing side-by-side with other versions of SQL Server is NOT supported. Upgrade from other versions of SQL Server is NOT supported. Only use the SQL Server Management Studio that ships as a part of this build to manage this build. This build does not work with or support side-by-side installations with any client redistributables of SQL Server such as Data Tools, Data Tier Application Framework, etc.

Microsoft Corp. and Oracle Corp. today announced a partnership that will enable customers to run Oracle software on Windows Server Hyper-V and in Windows Azure. Customers will be able to deploy Oracle software — including Java, Oracle Database and Oracle WebLogic Server — on Windows Server Hyper-V or in Windows Azure and receive full support from Oracle You can read the rest of the press release here: http://www.microsoft.com/en-us/news/Press/2013/Jun13/06-24WSNewsPR.aspx Zdnet also reported this today here: http://www.

TinyIoC, the default IoC container for Nancy, does not autoregister multiple instances for the same interface. So the following code will give you two 0’s. using System; using System.Collections.Generic; using System.Linq; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { var container = new TinyIoC.TinyIoCContainer(); container.AutoRegister(); Console.WriteLine(container.Resolve<C3>().NumberOfElements); Console.WriteLine(container.Resolve<IEnumerable<I1>>().Count()); Console.ReadLine(); } } public interface I1 { } public class C1:I1 { } public class C2:I1 { } public class C3 { private int _count; public C3(IEnumerable<I1> list) { _count = list.