(Kaj Arnö) During one of the coldest days in early February, I invited the new MySQL AB CTO, Taneli Otala, for dinner to my home in Grankulla, Finland. Taneli was spending over a week with Michael ‘Monty’ Widenius, our company founder, main architect and CTO since many years.
Other News
Extended Properties
(Brian Mains) Extended properties are a new database feature with the SQL Server 2005 product. Extended properties store additional information for a wide array of database objects, such as tables or columns. For example, you could store table and column descriptions of purpose and business informat
Examining ASP.NET 2.0’s Site Navigation – Part 5
(Scott Mitchell) The site navigation features in ASP.NET 2.0 make it easy to define a site map and implement common navigation UI elements, such as a breadcrumb, treeview, and menu. Due to its use of the provide model, you can dictate how to serialize the site map. ASP.NET 2.0 ships with a default i
Undocumented DBCC: Use PSS command to view user and process information
(Serdar Yegulalp) The DBCC PSS command enables you to obtain and dump out detailed information about processes and users currently connected to a SQL Server. It has remained an undocumented feature because the type of information dumped out by PSS has changed from one SQL Server edition to the next,
SQL Performance: Abnormal Stored Procedure Recompiles?
(george.p.alexander) So application programming in .Net is one thing. But tweaking the Database part of our application is a totally different matter. Earlier we had a look at enhancing database performance by getting the right index. This was followed by a look into using indexes along with SQL Sta
Restrictions on Stored Routines and Triggers
Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. Some of restrictions apply only to stored functions, and not to stored procedures.
WebSphere for z/OS Problem Determination Means and Tools
(Rica Weller, Cleberson Calefi, Keith Jabcuga, Suresh Maddukuri and Robyn Nostalgi) For the day-to-day administration tasks for IBM WebSphere for z/OS, you need powerful and efficient tools for analyzing problems, for finding their root causes, and for solving them. (pdf)
Script to Find User Information and More
(Pankaj Borole) This script will find user information, object count (as per object_type), roles assigned, and system privileges.
Storing an XML Document in Apache Xindice
(Deepak Vohra) Apache Xindice is a native XML database in which XML documents may be stored, queried, and modified. The advantage of a native database over a relational database is that mapping of XML to SQL is not required. Instead, XPath is used to query the Xindice database and XML:DB XUpdate is
Build a Generic Range Class with .NET 2.0
(Jean-Paul S. Boodhoo) I am a big fan of objects. It’s so convenient to work with programming entities that you can ask to do something and they just do it. The shift that we developers have made from procedural style to OO style allows us to express ideas in much richer ways than were possible usin