(Vishal Nayan) Here you will see how to create your first CLR Trigger for SQL Server 2008 using C#.
Other News
Distributed DBA: The DB2 Problem Determination Tool
(Roger E. Sanders) One of the best ways to collect diagnostic data in DB2 for Linux, UNIX, and Windows database environments is by using the DB2 Problem Determination Tool, a utility that comes free with the product.
How to Customize the Dropdown List in a SSRS Report that Uses a SSAS Cube Data Source
(Ray Barley) I have a requirement to develop a report that uses a SQL Server Analysis Services Cube as a data source. The report must allow the user to select the desired month from a dropdown list.
Filtered Indexes
Filtered Indexes As you may or may not know there are two basic types of indexes available in SQL Server. Clustered and Non-Clustered. A table (or view) having a clustered index stores the data within the clustered index leaf nodes. A Non-Clustered index stores pointers to the location of the data within the clustered index, if one exists, or the […]
Lightswitch wrap up
SelecTViews With Stephen Wynkoop Find out the latest news involving Red Gate, IBM’s Watson supercomputer, Office 365 and more. Stephen Wynkoop discusses the benefits of "big data". An interview with MaximumASP’s Sarah Barela delves into database forensics and best practices for tracking users. [Watch the Show] Lightswitch wrap up I received some interesting Email regarding Lightswitch. I think I can […]
Transforming Ant Build XML to Groovy
(Dustin Marx) There are numerous ways in which Groovy can be applied to build Java-based applications. These building approaches range from invoking commands like javac and jar directly from Groovy code to Groovy-powered build systems like Gradle.
Anatomy of a .NET Assembly – Custom attribute encoding
(Simon Cooper) In my previous post, I covered how field, method, and other types of signatures are encoded in a .NET assembly. Custom attribute signatures differ quite a bit from these, which consequently affects attribute specifications in C#.
adrci: A survival guide for the DBA
(Uwe Hesse) Starting with 11gR1, we have a new way to deal with Oracle Errors & Tracefiles: There is now a special command line utility dedicated for that purpose called adrci (Automatic Diagnostic Repository Command Interpreter). This posting is intended to show you the (in my view) essential comma
ODI snippets: Upgrade ODI 10g to ODI 11g – Cloning repositories
(Uli Bethke) If you host your ODI repositories on an Oracle 11g database and need to clone the schemas during the upgrade process you must not use the export/import utility to do this.
Interpreting an AWR report when the ArchiveLog Dest or FRA was full
(Hemant K Chitale) It can be very interesting / challenging / confusing / misleading / wrong to attempt to interpret an AWR report for the duration when ArchiveLogs could not be generated.