(Jeff Smith) DBMS_OUTPUT is a technology that many Oracle people will just assume you already grok. It is a very basic building block for Oracle PLSQL programs. If you do not understand it, then your first attempts at scripting will likely be very frustrating.
Other News
Change management seen making, breaking SharePoint 2010 deployment
(Jonathan Gourlay) A lot has been said about the benefits of the SharePoint 2010 collaboration platform as a business process technology, but many organizations continue to run into difficulties after deploying the framework. Part of that is a lingering — if misguided — belief that once SharePoint
SQL Server 2012 new high VLFs warning: Important update
(Pedro Azevedo Lopes) If you follow this blog, this is another post on VLFs, a topic I’ve covered several times before. If you want to read more about it just click here. Also, all scripts in the VLF posts have been updated to support SQL server 2012.
Aggregate Functions and Sorts
(tonyhasler) I have been prompted to write one of my rare blogs because I have just discovered that the topic of aggregate functions is not quite as straightforward as I previously thought.
Best kept MySQLDump Secret
(Peter Zaitsev) Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it works, but did you know there are some cases when you can get table entirely missing from the backup if you use this technique?
Basics of ASP.NET MVC3 (Part-I)
(Arthanarieaswaran) This article explains the basics of MVC 3, the Razor view engine functionality, and custom helper class creation.
Virtualizing InfoSphere Optim database tools with Citrix XenApp
(Sailaja Bandlamoori and Timmy Nguyen) XenApp Citrix is becoming a common environment for delivering virtual IBM Eclipse-based tools, including IBM Data Studio full client for Windows®, as an on-demand service to any user, anywhere in the industry. There are a few challenges using XenApp. This artic
Showing Category and Subcategory Using a Nested GridView in ASP.NET
(Rohatash Kumar) This article shows you how to implement a nested GridView and also display a category and subcategory using a nested GridView. You create two tables, one for category and another for subcategory and also create a stored procedure for selecting category and subcategory from both tabl
Modern Documentation
Featured White Paper(s) Encryption & Key Management for Microsoft SQL Server 2008 Written by Townsend Security Simplify encryption and key management on … (read more) Featured Script convert_ident_to_guid.sql Script to find all ident columns in db, find out if they are in an index, (if so)drop the index, recreate the ident as guid, … (read more) Modern Documentation We had […]
Modern Modeling Strategies
Modern Modeling Strategies One current software development trend is to allow code to model as much as possible. Agile shops are the best examples of this strategy. As a result, many times a team can go to the complete extreme of not producing any models such as Class Diagrams or Database Diagrams. IMHO, these two concepts are not mutually exclusive. […]