(Ilan Hazan) I will start by defining the MySQL Many to Many relationship (Experts can skip to the next paragraph).
Other News
XML Declaration Statement and Child Elements
(Darla Ferrara) Part one of Lessons in XML provided a quick look at the declaration statement. This is the first part of any XML document and tells the computer the format and language of your file.
Configurable Global Action Filters for ASP.NET MVC
(K. Scott Allen) ASP.NET MVC 3.0 introduces global action filters – an easy way to apply an action filter to every action in an MVC application. All you need to do is register the filters during application startup:
Nested Layout Pages with Razor
(Mike Brind) Razor Layout pages are the equivalent to MasterPages in ASP.NET Web Forms and the Web Forms View Engine within ASP.NET MVC. Just as it is possible to nest MasterPages, it is also possible to nest Razor Layout pages. This article explores the process required to achieve nesting of Layout
Beware of Deferred Segment during 11.2.0.2 upgrade from 11.2.0.1
(Coskan Gundogar) We recently upgraded one of our biggest databases to 11.2.0.2 from 11.2.0.1 due to the library cache mutex related bugs on 11.2.0.1. Since I wasn’t the one who did the upgrade I have nothing to say about the process but I was the on call DBA on the next day after the upgrade.
Protecting vendor IP through obfuscation of SQL PL and SQL
(Serge Rielau) Do you write SQL or SQL PL code that you want to provide to others?
The DB2Night Show #37: DB2 LUW MDC Tables – Tech Details with IBM Guests
(Scott Hayes) In episode #37, special IBM guests Paul Zikopoulos and Pat Bates talked about how MDC tables work, some design best practices, and shared some impressive customer success stories. If you have a Data Warehouse database, this show is a “Must See”. If you have an OLTP database, there are
Understanding SQL Server 2008 R2 Fixed Database Level Roles
(Satnam Singh) To easily manage the permissions in our databases, Microsoft has provided several roles in SQL Server which are security principals that group other principals.
WCF: Error Handling and FaultExceptions
(Andrew Fenster) Suppose I write a WCF web service with no try-catch blocks and no error handling. What happens when my web service throws an exception? Since I don’t have any error handling, WCF catches the exception for me. It sends the client (the program that called my web service) a FaultExcept
db2university.com: Get started designing, configuring, and deploying on the cloud, Part 1
(Raul F Chong) This is the first in a series of articles that show you recommended techniques to design, configure, and deploy an application on the cloud. The article provides an overview of all the different steps needed to complete a 1-year long project that included enabling Moodle software to u