(Eddie Awad) Here is the set up: The host is a Windows 7 machine, 64 bit with Oracle client. the guest is a Windows XP Virtualbox VM running Oracle Database 11.2.0.2. All default installations and configurations.
Other News
More Flexible Routing For ASP.NET Web Pages
(Mike Brind) The built-in Web Pages routing system offers a fair degree of freedom in terms of how friendly URLs can be constructed and managed. However, the major limitation with the standard routing mechanism is that it relies on matching segments of the URL to files on disk. ASP.NET MVC and Web F
SQL Server Power View (aka Project Crescent)
(Bryan Group) I remember when creating reports were a daunting task and one that I generally left for last to complete. I think almost every developer I’ve come in contact with throughout the years is under the same impression (although there are exceptions to every rule) however with the release of
POISED: A systematic six-step method for solving database performance problems (and every other problem)
(Iggy Fernandez) POISED stands for “Problem Observation Implication Solution Execution Documentation.” It is the name I like to use for the systematic six-step troubleshooting method described by Chris Lawson in The Art and Science of Oracle Performance Tuning. Here is an example.
Google reCAPTCHA in ASP.NET MVC 3 using the Razor engine
(Thomas Glaser) After my last post I found that OpenCaptcha.com can be unreliable which leads to the captcha image not being displayed.
Using MongoDB with ASP.NET Web API
(Henrik F Nielsen) MongoDB is a popular NoSQL database that makes it a great backend for Web APIs which lend themselves towards a document store rather than a relational store. In this blog we show how you can use MongoDB with ASP.NET Web API to build an ApiController with support for HTTP GET, PUT,
Do I really want to get rid of SQL_MODE?
(Anders Karlsson) I recently wrote about SQL_MODE, and Ronald Bradford was quick to reply with his view on things. Although my post was a bit of a rant, and I think it was a necessary rant, it seems that Ronald and I largely agree on the overall matter of things.
APAR Friday: Sparse index potential performance degradation
(Willie Favero) Are you using or are you considering using sparse index scan? If yes, then you may want to keep this HIPER on your radar: APAR PM49154.
IBM Cognos Proven Practices: IBM Cognos BI – Create a Custom Schedule Using Calculations and Parameters in Event Studio
(Selvakumar Gunasekaran) This document describes an approach to schedule a report which can be delivered to users on multiple, non-recurring dates using an IBM Cognos Event Studio agent.
Querying Active Directory Data from SQL Server
(Brady Upton) My boss is asking for a list of email addresses and phone numbers for all users in the company. I know this data exists in Active Directory, so how can I access this data from SQL Server? In this tip we walk through how you can query Active Directory from within SQL Server Management