(Eric Landes) For many Crystal Report creators, there has not been a good way to distribute your reports without additional programming. You can programmatically export to PDF then in your program email it or use BusinessObjects Enterprise to set up your report to a distribution list using a particu
Other News
Sending e-mail from an Oracle database with utl_smtp
(Rex Baldazo) If you’re running Oracle 10g or later, you can use the nice modern utl_mail package to send e-mails from your PL/SQL applications. Even though the application I maintain is now running on Oracle 10g, it was built back on an Oracle 8i database, so it sends e-mails via the older (and mor
Using Parameters with ADO.NET to Update Data in ASP.NET 2.0 Pages
(Michael Youssef) As promised in the previous article, this article will discuss in detail how to create and use Sqlparameter objects with parameterized queries and stored procedures. You will use these queries and procedures to retrieve and update information in a database.
Ruby on Rails Proves It Deserves the Hype
(Francis Wong) With the multitude of programming languages out there such as Fortran, Java, C++ and C#, you may wonder why Ruby on Rails has suddenly become such a hot topic in the development world. Created in the late 1990’s by an individual in Japan, the Ruby programming language had a cult follo
Database Security
(Susan Visser) We all know how important database security is — no one wants to hear that their precious data was hacked or compromised in anyway. According to the article The Job of Securing the Database published on DATE: 21-SEP-2007 by Deborah Perelman, a Forrester Research study shows that DBAs
Blogging about 11g – Part 10 – Enhanced Optimizer Statistics Maintenance
(Yuri van Buren) In Oracle 11g you now can modify gather_database_stats default values with set_global_prefs, set_database_prefs, set_schema_prefs, set_table_prefs in the dbms_stats package.
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 8
(Muthusamy Anantha Kumar) This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.
Index related DMVs and DMFs
(Dinesh Priyankara) SQL Server 2005 introduced three new index-related dynamic management views and functions. All these views and functions are information rich and allowing to analysis of indexes.
SQL Server and SANs: The QueueDepth Setting of a Host Bus Adapter (HBA)
(Linchi Shea) Too many DBAs tend to view a drive presented from a Storage Area Network (SAN) as something of a monolithic nature. They look at the drive as if it had some intrinsic performance characteristics. This view doesn’t help one appreciate the true performance characteristics of such a drive
MySQL: what read_buffer_size value is optimal?
(Peter Zaitsev) The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand I have to less believe in common sense or common sense of documentation writers and do more benchmarks and performance research. I just recently wrote about rather surp