(Ashish Kaushal) How many times, we as a SQL developer or DBA, find ourselves shuffling through objects in Enterprise Manager, or expanding the left pane of Query Analyzer, trying to find a table or view for which we have no clue, except a nearly correct name, and the only way we would know that it
Other News
Accessing DB2 UDB for iSeries data from AIX Applications – Optimize AIX access to your DB2 UDB for iSeries database
AIX 5L is quickly becoming the preferred commercial implementation of UNIX operating system. The recently announced IBM eServer i5 servers can run AIX 5L in as many as 160 separate logical partitions (LPARs). This gives iSeries customers a very rich portfolio of business applications that are curren
Using the New MODEL Clause in Oracle Database 10g
(Anthony Molinaro) One of the great new features of Oracle’s flagship database software, Oracle Database 10g, is its new MODEL clause, which you can use in SELECT statements. In this article we’ll look at some examples of the MODEL clause in action, and show how you can use MODEL to manipulate your
Report Authoring: Designing Efficient Queries (Sample Chapter)
(Rodney Landrum and Walter J. Voytek II) SQL Reporting Services provides a platform for developing and managing reports in an environment that includes multiple data sources of information. Standards such as ODBC, OLE DB, and .NET facilitate obtaining the data from these disparate data stores. B
Linux Grid Implementation from DB2 on z/OS
(Hong Min) This IBM Redpaper describes an implementation that routes CPU-intensive parts of an application from DB2 UDB on z/OS to a Linux grid environment and returns the results to the requesting stored procedure in DB2. (pdf)
Learning ASP.NET for the ASP Developer, Part 1
(Nihal J. Mehta) The combination of the .com boom of the ’90s and the success of Microsoft’s ASP technologies created a huge number of ASP programmers. The weaknesses of ASP are now well known, and the ability to translate ASP knowledge into a new platform is often the desire of many of these AS
Monitor Blocking in SQL Server 2000 – Part II
(Muthusamy Anantha Kumar) Part I of Monitor Blocking in SQL Server 2000 described how to get detailed information on blocking. Blocking is unavoidable in most types of applications. In this article, instead of collecting information every 5, 10 or 15 minutes, I am going to discuss how to collect det
Dynamic XML with the ASP.NET XmlTextWriter() object
In this article, we’ll show you how to use ASP.NET code to dynamically build an XML file, and then apply that knowledge to create an RSS-compliant news file that you can publish on your site (or even decipher with the RSS reader you created last time). (R)
Combining Symmetric and Asymmetric Encryption
(larryjf) This article describes symmetric and asymmetric encryption, then shows how to combine them.
Microsoft Computing: Active Server Pages
(Chris Peters) It seems that whenever solutions for a programming problem are discussed, a Web-based application is among them. ASP.NET, with all its capabilities, can be a real workhorse for you.