(Ben Thompson) Oracle database processes are to many systems administrators just another service that runs on the machines they look after. Understandably sys admins like to be able to put some controls in to prevent these processes from consuming too many CPU resources, filling up the disks or hogg
Other News
What are these dollar signs doing in my code?
(Gary Myers) I’ve had the good fortune, in my current role, to be doing a fair amount of PL/SQL development in 11gR2. Boy, it feels good to be actually using up-to-date versions. Being picky, we are on Apex 4.0, rather than 4.1 but that’s not a biggie.
APAR Friday+ : This is bonus APAR based on a slide in John Campbell’s excellent webinar Feb 21-22
(Willie Favero) John did a 2-part webinar February 21-22 on DB2 10 migration (DB2 10 Migration Planning and Very Early Experiences – PART 1 & PART 2 ).
Memory usage is high when you create several XmlSerializer objects in ASP.NET
In Microsoft ASP.NET, the memory usage increases unexpectedly when you create several XmlSerializer objects.
X-ray of SQL Server timeout and user cancel
(Guillaume Fourrat) We’re going to take a close look at how SSAS and SQL Server implement execution timeout and user cancellation, and we’ll discover a few noticeable differences.
Multi-Insert and LAST_INSERT_ID()
(Gavin Towey) Using a multi-insert to save rounds trips to the database can be a great time saver, but what if you want to also retrieve all the auto-increment values from those rows you just inserted?
Installing/Enabling .Net 3.5 SP1 on Windows 2008 R2 for SQL Server 2008 R2/SQL Server 2012 RC0 Install
A junior team member ran into this issue so thought it was worth a post. While installing SQL Server 2012 RC0 on a new VM of Windows Server 2008 R2, it complained about installing or enabling .Net Framework 3.5 SP1 which is a pre-requisite for the SQL Server install. Here are the steps to validate
Using ASP.NET Web API with ASP.NET Web Forms
(Henrik F Nielsen) Several of the ASP.NET Web API tutorials (see for example “Your First ASP.NET Web API”) show how you can use ASP.NET Web API with MVC applications. However, you can equally well add a Web API to a Web Form enabling the same Web API support as in MVC applications.
The Strategy Pattern in .NET
(Eric Vogel) Developers often run into similar problems when architecting software. To help tackle this problem, software design patterns have become quite popular. The Strategy Pattern is a common design pattern that allows an application to dynamically pick an appropriate method at runtime based o
5 Steps to Making SharePoint Information Architecture Work for You
(Robert Bogue) Information architecture shouldn’t be a big scary thing: it’s simply about creating the same elegance you see in the Golden Gate Bridge or the Eiffel Tower, only instead of being built with steel, it is built with information.
