(Troy Coleman) The SQL enhancements that have been delivered in recent DB2 releases is amazing. To answer some business questions, programs must be written to process multiple SQL statements. However, with each release of DB2, more and more processing can be pushed into SQL, removing the need to wri
Other News
Extending the Existing CLR Type
(Naresh Rohra) Yes, you read that right. With .NET 3.0, you can extend any existing CLR type by adding one or more public methods to it—without recompiling the library. These new members are available only to the assembly that defines the methods, a feature known as “extension methods.”
Introducing LINQ to SQL Designer using Visual Studio 2008
(Jagadish Chaterjee) This is an introductory article that focuses on designing LINQ to SQL objects using the LINQ to SQL Designer in Visual Studio 2008. Apart from designing, we will concentrate on fetching and updating databases using the model created with Designer.
Document Sarbanes-Oxley compliance with SQL Server 2005
(Tim Chapman) As the DBA for revenue-generating applications, I am frequently invited by my CIO to meetings with Sarbanes-Oxley auditors to discuss the security and integrity of corporate data. In a nutshell, we’re expected to answer any number of questions, via appropriate documentation, about who
Set Functions: The StripCalculatedMembers() Function
(William Pearson) In this lesson, we will introduce StripCalculatedMembers(), a basic set function which is often “just what the doctor ordered” in the context of the specific need. The general purpose of StripCalculatedMembers() is to retrieve the members of a specified set, after removing any calc
Creating Agile Project Reports with TFS and Reporting Services – Part 2
(Eric Landes) This series introduces the reader to creating custom reports for TFS utilizing Reporting Services. In Part 1 of our series we covered 2 reports: A Story details report to allow you to print out your stories to post up in your war room and a current iteration report to report the statu
GROUP BY, HAVING, SUM, AVG, and COUNT(*)
(Kenneth Downs) You can use a SQL SELECT to aggregate data. Aggregation combines rows together and performs some operation on their combined values. Very common aggregations are COUNT, SUM, and AVG.
.NET Performance Issue: What if I suspect that my performance problem is in SQL server?
(Graham Kent) Very often when investigating ASP.NET or other .NET performance issues we find threads stuck waiting for SQL Server or some other database to respond.
Play the Innov8 game to learn business process management
(Abdelilah Lali) Your mission, should you choose to accept it, is to learn the fundamentals of business process management (BPM). Play the strategic IBM BPM-simulation game, Innov8, in which you focus entirely on BPM activities. Interact with other virtual employees, participating in their daily act
Oracle BI EE 10.1.3.3/2 – Changing Sort Order of Dashboards
(Venkatakrishnan J) I have seen this question floating around in many of the forums and thought i shall blog about it. The question is how do we change the sort order of the dashboards that is shown in the Dashboards Banner. Well, currently there is no out of the box way to change the default sortin