(Thiru Thangarathinam) In Part 1 of this series on LINQ, you learned all the basics of LINQ including type inference, Lamda expressions, extension methods, and anonymous types. You also discussed the use of standard query operators for querying in-memory objects, and collections. With that backgroun
Author: SSWUG Research
Oracle 10gR2 Adaptive Thresholds, Part 2: Implementation
(Jim Czuprynski) Oracle 10g Release 2 (10gR2) has improved significantly the methodology for tracking performance metrics within the database. This article – the last in this series – demonstrates how to implement adaptive thresholds and use their metrics to effectively detect significant performanc
Stored procedures: Who is running backups and restores and when
(Greg Robidoux) Backup and restore commands can be issued by running T-SQL, Enterprise Manager or Maintenance Plans. However, it’s still not easy to determine who issued backups and restores — and when. (R)
Pivot Table Data in SQL Server 2000 and 2005
(Jerry Dixon) I’ve been asked many times, by clients and friends alike, how to "pivot" a SQL resultset from a set of rows to a set of columns. This is something that many people do once a blue moon, and then forget how to do it. So, I decided to place an example on my blog for easy reference.
CLR Hosting APIs
(Alessandro Catorcini and Piotr Puszkiewicz) Suppose you are developing a large application in native C++ and you want to allow your customers to extend this app so they can mold it to their needs. Allowing your customers to write the extensions in managed code inside the Microsoft .NET Framework wo
Business processes for Web Services: Principles and applications
(R. Khalaf, A. Keller and F. Leymann) The Business Process Execution Language for Web Services (BPEL4WS or BPEL for short) is an XML-based language for defining business processes that provides an interoperable, portable language for both abstract and executable processes and that was designed from
Creating a Treeview Menu in ASP.NETwith C#
(Rohit Kukreti) Most Web sites/Web applications have menus to navigate the site, but either you have to use complex DHTML or a third-party tool to provide the menu. Instead, you can use the Treeview control shipped with Internet Explorer’s Web controls to solve this problem.
Boosting the Performance of an ASP.NET Application Using StringBuilder Class
(Brett Burridge) Improving the performance of applications can be a complex and time consuming operation. Thankfully, there are a few development techniques that are relatively straightforward to implement and can result in significant application performance benefits.
The CLRUD Design Pattern for CLR Stored Procedures (C#, VB.Net)
(Payton Byrd) Using CLR Stored Procs is a decision to be made for a multitude of reasons, not the least of which is the ability to apply object oriented methodologies to your data access code. Object oriented methodologies lend themselves to encapsulating the operations of an object into coherent e
DB2 security, Part 8: Twelve DB2 security best practices
(Ted J. Wasserman) A number of reports detailing wide-ranging system security breeches have been at the forefront of the news in the past couple of years. Typically, sensitive personal data such as Social Security Numbers (SSNs), credit card numbers, and bank account numbers are stolen from insecure