(Mahesh Chand) In this step-by-step tutorial, you will learn how to create reports from an XML document using the ReportViewer control and Visual Studio 2005.
Author: SSWUG Research
Predicate Pushing
(Shraddha Pandya) Oracle supports the pushing of predicates into a given view.
Convert a Hexadecimal to int using Microsoft SQL
(topcatalpha) I’ve been looking around to convert a string containing a hexadecimal value to an integer value using Microsoft SQL and indeed found some articles on the internet. Some of the articles convert an Hexadecimal value and not a string. Some of them do convert a string but use loops that co
Mixing the bill of materials formula with SQL Server
(Arthur Fuller) Most DBAs are familiar with the classic bill of materials (BOM) problem: Given quantities of x, y, and z, how many units can you build? This SQL Server tip is a variation on the BOM problem; it tells you what recipes you can make with the ingredients you have on hand. The technique a
Upscaling Your Database Application Performance: Cursor Management
(Greg Rahn) In my previous post, Bind Variables, I discussed why using bind variables is one of the most important fundamentals in engineering scalable database applications. I briefly touch on the point that cursor management is also very important. In this post I will go into why this is important
SQL Server 2005 Integration Services – Maintenance Plan Tasks – Part 47
(Marcin Policht) In the previous installment of our series dedicated to SQL Server 2005 Integration Services, we introduced the concept of Maintenance Plans and presented a brief overview of three methods that can be used for their implementation. We also described in more detail the most straightfo
Emulating tables with PL/SQL (Part III)
(René Nyffenegger) With PL/SQL, it’s possible to create functions that return a nested table type of an object type. If the return value of such a function is given as the argument to the table() operator, it behaves like an ordinary table. I have already written about this in On emulating tables wi
Preventing and exposing errors in Ajax Applications
(Dan Morrill) Ajax.sys-con is running a good article on Ajax and application security that is a good read. While it starts slow with background info, the rest of it is well worth reading. =
Working with .NET files via the Path class
(Tony Patton) Developers often need to know certain aspects of a file such as the name, full path, drive, and file extension. The .NET Framework provides easy access to these details via the Path class contained in the System.IO namespace. This article examines the various pieces of information avai
DB2 for z/OS Administration Tools for Enhanced Change Management
(Paolo Bruni, Lucy Krantz, Frank Nikodem, Guenter Pfann and Marc White) A database administrator (DBA) has a challenging job trying to maintain databases in today’s nonstop 24×7 environments. This challenge is compounded by the complexity of database structures and the time pressure of trying to be