(Nathaniel Brown) Bruce Perens, a very public Open Source advocate, and a co-founder of Software in the Public Interest, says Open Source could prove to be even more attractive in the future, as commercial software looks to protect company interests over those of the user. But, to take advantage of
Other News
Performance (hit ratios, sorts, dynamic queries)
(Chris Eaton) So now we are ready to get into some SQL scripts to actually monitor your database (hooray). For the monitoring equivalent of “hello world” let’s look at the DB2 buffer pool hit ratios (yes I’m aware that many folks know that BP hit ratios can be deceiving but it’s the monitor thing th
Sending SMTP-Authenticated Email From ASP.Net
(Brad Kingsley) I wrote an article in May 2005 on how to send email via ASP.Net v2.0 http://www.wwwcoder.com/main/parentid/435/site/5103/68/default.aspx. This is a quick follow-up to that article with additional information specifically addressing the issue of SMTP-Authentication against a remote ma
Vista Point
(Don Kiely) It’s September 8, 2005, some 60 days and counting to the final release of Visual Studio 2005, SQL Server 2005, and version 2.0 of the .NET Framework and ASP.NET, all scheduled for release the week of November 7. Up to now in this column I’ve stuck to writing about security issues in
OASIS Standardizes Emergency Data Exchange Language (EDXL) Specifications
Two specifications developed by the OASIS Emergency Management Technical Committee have advanced toward standardization, while work commences on a third XML-related standard for messaging.
Automating Stylesheet Creation
(Bob DuCharme) Since the early days of XSLT, many have asked whether it was possible to automate the creation of XSLT stylesheets. The general idea of filling out a form or dragging some icons around, then clicking a button and seeing a productive stylesheet generated from your input has always appe
Microsoft SQL Server Cluster Versus a Standby Server
(Bilal Ahmed) The concept of high availability is not limited to the enterprise world anymore. It has already sneaked through the doors of the SMB market, which brings up new potential challenges for DBAs. This paper discusses specifically two out of the many various options available for SQL Server
‘TOP’ Clause in SQL Server 2005
(Muthusamy Anantha Kumar) We all know the “TOP” clause returns the first n number of rows or percentage of rows thereby limiting the number of resulting rows displayed when we are selecting rows in a table.
Worst practices for SQL Server backup and recovery
(Greg Robidoux) A backup and restore process is critical to protecting your data when a failure occurs. The author identifies common SQL Server backup and recovery worst practices. (R)
Override Default Optimizer Behaviour for SQL in PL/SQL blocks
(Garry Robinson) Oracle’s default behaviour dictates that SQL statements embedded in a PL/SQL block are always executed with the ALL_ROWS optimization method. For OLTP applications that rely on packaged stored procedures, this can be bad news for response times. OLTP queries need to return results b