(Bryan Avery) I will take you through how to deploy your own Custom Data Process Extension for SQL Server Reporting Servers 2005, both on the server and for use within your development environment.
Other News
Verbose SQL Agent Logging
(Tim Ford) How often have you reviewed a SQL Server Agent Job’s history to determine why a job failed only to be confronted with a minimal level of detail? When a job failure occurs it is imperative to be able to quickly identify the root cause in order to determine the correct remediation. As suc
On Open Source Going Mainstream
SelectViews SQL Server Show [Watch Now] A SQL Server problem triage plan and approach, a pet peeve about open source, public domain software, current release versions and more. Also on the show, the 60-second SQL Server tip of the day, upcoming events, the newsletter and discussion list watches and other goodies. Also Available [Watch Now] SQL on Call – answering […]
MySQL Acquisition, Sun and The Realities of Business
Featured Article(s) Remove Time from a DateTime Column (Vadivel Mohanakrishnan) This article explains the way to get rid of ‘TIME’ part in a dateTime column. The target audience of this article are ‘beginners’. MySQL Acquisition, Sun and The Realities of Business On Friday, I wrote about my initial thoughts on the whole Sun/MySQL acquisition thing. I did receive some good […]
XML Programming in Visual Basic 9.0
(Jonathan Aneja) By now you’ve probably heard of LINQ (or Language Integrated Query), the new query technology coming in Visual Studio 2008. LINQ-enabled languages like Visual Basic give you a rich set of query operators that can be applied to various data sources, such as in-memory collections, dat
Cool New Features in DB2 for LUW V9 : Part 1 : Dropping Columns
(Philip Nelson) I’ve been working away on a Ruby on Rails project, with DB2 (Linux) at the back end. I’ve learnt a lot as I’ve went along, especially as this is my first serious foray into the world of DB2’s pureXML (I am indebted to Matthias Nicola from the IBM Silicon Valley Lab for the help he ha
MySQL Proxy: reusing connections
(Jan Kneschke) Some time ago I have shown that the proxy can do connection pooling and can keep server-side connections open to be reused by another client later. The keepalive tutorial shows how this can be implemented.
Accessing DB2 UDB with PHP (Part 2)
(Deepak Vohra) As mentioned in the previous tutorial on PHP/DB2, PHP is widely used in web applications and most web applications have a database component. The PHP extension for DB2 database provides access to one particular widely-used database from a PHP script.
Capture an Oracle 10g audit trail in XML format
(Bob Watkins) The Oracle database has long had the ability to audit selected types of operations against the database, storing the audit trail in a system table. This table, SYS.AUD$, resides in the data dictionary. On some operating systems, you can also write audit records to the operating system’
Working with .NET Remoting Under IIS Server and Using ASP.NET as Remote Client
(Abhishek Kumar Singh) Remoting is a technology based on communication between one or more different application domains in a distributed environment. It means this enables objects residing on the same domain or computer, else spread among different domains or computers worldwide, to be accessible b