(Mike Chapple) One of the major advantages that enterprise-class databases offer over their desktop counterparts is a robust backup and recovery feature set. Microsoft SQL Server provides database administrators with the ability to customize a database backup and recovery plan to the business and te
Other News
Use table-valued parameters for SPs in SQL Server 2008
(Eric Johnson) Since the release of SQL Server 2000, we have had the table data type at our disposal. But, its major weakness is that it could not be passed in or out of a stored procedure as a parameter. Well, Microsoft has heard and answered the cries of database administrators and developers. SQL
Informix DBA: The IDS 11 Sysmaster Database
(Lester Knutsen) The Sysmaster database, a pseudo-database that’s part of the Informix Dynamic Server (IDS) installation, provides a peek into the shared memory structures of an IDS server. It’s a great tool for monitoring server status and performance. I’ve given several talks and written many arti
Database Platform Choices – The Results
Just Posted: SelectViews 86 This show is an interview with Kim Tripp and Paul Randal. We got together at DevConnections in Las Vegas and talked about everything from the famous board game to SQL Server 2008. > Watch Here Converting Mainframe Data to SQL Server? Do you need expert conversion of complex EBCDIC (mainframe) data into ready-to-import ASCII files? Greenview’s […]
Weaving WebSphere: IT Starts with an ‘i’
(Joe Pluta) I speak every year at iSeries DevCon, and every year I try to get to the keynote address because I never know what I’m going to hear, but I know it will be interesting. This year in particular I’m glad I made it, because Mike Smith, IBM Distinguished Engineer and i5/OS Chief Architect, g
Executing XQuery statements with XQLPlus
(Andrej Koelewijn) Oracle’s xquery implementation contains a sqlplus like tool which you can use to run simple xquery statements. You can find the xquery implementation in %JDEV_HOME%/lib. To run it, use the following statement:
ASP.NET MVC Framework (Part 1)
(Scott Guthrie) Two weeks ago I blogged about a new MVC (Model View Controller) framework for ASP.NET that we are going to be supporting as an optional feature soon. It provides a structured model that enforces a clear separation of concerns within applications, and makes it easier to unit test you
Adding Table Row Highlighting to ADF Faces pages
(Lucas Jellema) End users of web applications like clarity. They want to know where they are in a page, what the current context of information and their actions is. Next to of course a visually appealing look & feel and a crisp performance. Part of the end user’s satisfaction with the applications
Using MySQL Table Checksum
(Ronald) The MySQL Table Checksum, part of the MySQL Toolkit (having to be renamed soon) is an invaluable community tool for use with MySQL. Most sites or installations of any volume will use MySQL Replication for one purpose or another, be it for read scalability, backups, testing, upgrading etc.
Benchmarking Disk I/O Performance: Size Matters!
(Linchi Shea) If you use a tool such as IOMeter or sqlio.exe–both of which are freely downloadable–to benchmark the I/O performance of a disk, you typically would configure the tool to generate I/Os against a test file that is placed on the disk.