(Sven Cipido) Why do you need them? We could give you a short answer about this. When developing several projects in a company, you want them to have the same look. So, just like me, for every new project you copy files, code, etc from a previous project. The danger is that in the first place you
Author: SSWUG Research
Use SQL Parameters to Overcome Ad Hoc Performance Issues
(Mark J. Miller) I work for a small web company which over the last year or two has experienced a large amount of growth in both terms of staff as well as web site traffic. As part of that growth we have been forced to spend a large amount of time focusing on our database. And since we lack a […]
Serialization in Databases
(Bhuban Mohan Mishra) Serialization is the process of converting an object into a stream of bytes which is easily transferable over the network and storing its current state on any permanent storage media like file or database for later use. De-serialization is the reverse process of Serialization,
To Create PDF from SQL stored procedure
(Gopinath Bhagavathul) How to create a a stored procedure that will in turn create a simple column based report in PDF without using any external tools or libraries (and their associated licensing costs!). (pdf)
An introduction to SQL Server Management Objects
(David Jeavons) Before we can perform any operations against an SQL Server we must first connect to an instance of an SQL Server. To do this, we can either connect directly to a known instance or we can browse for all available SQL Servers that are on the network. Fortunately, retrieving a list of a
XForms tip: Call JavaScript from an XForms form
(Nicholas Chase) Because XForms controls are part of a namespace separate from the HTML and page, you cannot use the usual methods for calling JavaScript in response to user events, such as the onclick handler. So what are you to do if you need to call JavaScript from an XForms form? This tip shows
Recursive XSL Templates
(kirang) XSL is a declarative programming language. Variables, once declared, cannot be reassigned. It is often difficult for programmers coming from a procedural languages background to do advanced tasks. By using XSL, you can solve complex problems that at first glance often seem to be difficult o
Viewing Albums with WPF/E and ASP.NET AJAX
(Dan Wahlin) So many technologies and so little time! It’s hard to keep up with all of the great new technologies being released but over the holiday break I made some time to play around with the December CTP of WPF/E from Microsoft. I was really interested in WPF/E when I first heard about it si
Product Review: EMS SQL Manager
(Steve Callan) SQL Manager for Oracle is a “high performance tool for Oracle Database Server administration and development.” Developed by EMS, a company primarily based in Chelyabinsk, Russia with other offices located in Europe and the United States, SQL Manager for Oracle is an affordable comprom
Unleashing the power of WebSphere Portal V6 Search with the Portal Search Toolbox
(David Konopnicki and Eitan Shapiro) Do you want to empower your portal users with productive and advanced search capabilities such as suggested links or faceted search navigation? You can do just that with the Search and Indexing API (SIAPI) , published for IBM WebSphere Portal V6.0. This article d