(Frank Ohlhorst) Not every business can completely shift over to become an Oracle-only shop. There are usually applications outside of the Oracle ecosystem that must be maintained and, better yet, integrated into Oracle platforms.
Other News
A Match Made in Http Heaven – ASP.NET Web Forms and WebAPI
(Joshua Holt) With the introduction of MVC 4 Microsoft has created a fantastic new way for developers to expose data via HTTP service. WebAPI is extremely easy to configure when compared to WCF services, and can send content in a multitude of formats.
DB2 10: Using locally defined types and procedures
(Serge Rielau) Recently I discussed the motivation behind using anonymous blocks.
Load columnar text file into MySQL table
(Kedar) Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column!
New SQL Server Functions – First_Value and Last_Value
(Rajendra Gupta) SQL Server 2012 introduces new analytical functions FIRST_VALUE and LAST_VALUE. These new functions allow you to get the same value for the first row and the last row for all records in a result set. In this tip we will explore these functions and how to use them.
Will Metro Style Apps Take Off?
Will Metro Style Apps Take Off? Personally, I’m torn about the prospect. Microsoft has moved from powerful, efficient GUI applications to simplistic, intuitive applications. I used to be able to do so much more in Excel without using the keyboards, or constantly switching between function buttons in the toolbar. For example, to switch windows from one spreadsheet to another all […]
Custom strongly-typed HtmlHelpers in ASP.NET MVC
(Daniel) The original release of ASP.NET MVC used HTML helpers with a syntax like the following:
Managing the Report Content Using Report Manager: Caching
(Franco Lopes) In the Managing the Report Content Using Report Manager: Part I we saw how to go about setting the security for the Report Manager report items. In this article we will be focusing on caching SSRS reports.
8 Useful (and Free) SQL Server Downloads
(Michael Otey) In this age of the ubiquitous Internet, finding downloads for SQL Server is fairly easy. However, finding downloads that are useful and practical is often another story altogether. Here are my top eight practical and useful downloads for SQL Server.
The 3 DBA Mistakes You Don’t Know You Are Making
(Thomas LaRock) You have no idea that what you are not doing is causing you pain.