(Vinod Kumar) The next version of SQL Server named SQL Server 2005 is completely hyped with the integration of CLR into SQL Server. The introduction of CLR into SQL Server allows developers to write stored procedures, triggers, user defined functions, user defined aggregates and user defined types u
Other News
An Introduction to InfoPath 2003
(Dinesh Asanka) Recently I got Microsoft Office Professional Edition 2003 Installed. I found a new tool which was not in the previous versions of MS Office. Curiosity makes me want to get more information on this. Still I am learning and I would like to share my little knowledge with you all from wh
Achieving Maximum Productivity With DB2 SQL Performance Analyzer
(Frank J. Ingrassia) When programs are created to run under DB2, they are submitted to the Bind process, which creates a set of control blocks called Data Base Request Modules, or DBRMs. These modules are stored in a library and can be the subject of a rebind, if the module moves to another subsyste
Writing Managed Stored Procedures in SQL Server 2005
(Thiru Thangarathinam) With the functionality found in the .NET Framework Base Class Library (BCL), database developers now have access to thousands of pre-built classes and routines which can be easily accessed from stored procedures. The BCL includes classes that provide functionality for improved
Oracle’s Sample Schemas: Saying Goodbye to Scott
(Steve Callan) Did you know that Oracle’s “Scott” schema is slated for the bone yard? How many thousands of people have learned SQL, SQL*Plus, and PL/SQL on the back of poor old Scott? I would venture to say that the current generation of Oracle DBAs and developers are all familiar with the Scott sc
Performance Monitoring – Basic Counters
(Steve Jones) Performance tuning is something everyone needs to do and should do periodically. I recently started a new job and one of the ways I can get a handle on the SQL Servers I support is to start baselining performance. This series focuses on the methods that I used to setup monitoring and a
Cheap Tricks: Object Oriented Dynamic Linked Listboxes
A few years back, on a momentary down cycle between projects, I posted a little article about something I’d had to do at the time… which was to create a set of linked listboxes where, when the visitor made a selection from the first one, the contents of the other one automatically changed to match
Some Tips On Developing Applications for IBM’s DB2 Running on AMD64
(Alan Zeichick) Enterprise-class relational databases are one obvious application categtory that’s especially capable of leveraging the large memory space and increased performance offered by 64-bit processors. IBM has had a head start in 64-bit computing, having long offered versions of its DB2 Uni
How can I use aggregates and the group by clause with FOR XML?
Is there anyway I could return an XML with a SUM/GROUP BY clause in the select?!? This is actually fairly simple to implement. For this example I will use the pubs database. The first step is to create the query you want to use. For our example we will count how many titles each author has.
RSS Tutorial for Content Publishers and Webmasters
Think about all of the information that you access on the Web on a day-to-day basis; news headlines, search results, “What’s New”, job vacancies, and so forth. A large amount of this content can be thought of as a list; although it probably isn’t in HTML elements, the information is list-orient