(Morgan Brown) So you’ve started out with .NET Native and you’re seeing great performance gains, but you’ve run into a MissingMetadataException. MissingMetadataExceptions happen in certain reflection scenarios because of new optimizations in the .NET Native compiler.
Other News
ORE Getting Connected: ore.connect and other commands
(Brendan Tierney) After you have installed I ORE on your client and server (see my previous blog posts on these), you are not ready to start getting your hand dirty with ORE. During the installation of ORE you setup a test schema in your database to test that you can make a connection.
Adding an outline hint to a PS/Query
(Bobby Durrett) I just finished working with a coworker on speeding up a PS/Query. It was running well in a development environment but not in production. I tried to find a simple hint or two to make production run like development but didn’t have any luck.
DB2 for z/OS: the Functional Advantages of Native SQL Procedures
(Robert Catterall) I have been a big fan of DB2 for z/OS native SQL procedures ever since the functionality was introduced with DB2 9, back in 1997. I have posted quite a few blog entries on the topic, the first in 1998 (written while I was working as an independent consultant) and the most recent j
3 Critical Storage Performance Architecture Considerations
(Dave Beulke) Architecture matters and storage architecture is being optimized from many different directions to make it faster and cheaper, as detailed in the recent Baron’s article “Tech Vets Vie for New Storage Supremacy.”
Oracle GoldenGate Data Transformation
(Natik Ameen) Oracle GoldenGate Replication supports data transformation of data as it is read from the trail file and before it is put inside the database. This data mapping and manipulation is enabled by using the MAPPING parameter options.
Using Synonyms to Extend SSIS
(Jason Brimhall) There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality is, not all of those uses are good for you nor for your data nor for your database.
SQL 2014 Cardinality Estimator: Why You Should Care – Part 2
(Thomas LaRock) In the previous post I talked about how query optimization works, the role the Cardinality Estimator (CE) plays, and why you should care. Today I am going to break down some of the details about the differences between the old and new CE, as well as show some examples and scenarios.
Project Navigation and File Nesting in ASP.NET MVC Projects
(Rick Strahl) More and more I’m finding myself getting lost in the files in some of my larger Web projects. There’s so much freaking content to deal with – HTML Views, several derived CSS pages, page level CSS, script libraries, application wide scripts and page specific script files etc. etc.
SQL Server WHERE clause wildcards
(Steve Endow) This morning I was working on a SQL query used to create to create new Dynamics GP customer IDs.