(Usama Mosaad) During the implementation process, building applications with consistent code is considered one of the main objectives, which the development team aims to, because it affects the final product quality. Consistent code is the term that means writing code that follows the coding best pr
Other News
Accessing Subversion repository from .NET using DotSVN
(Ann Jose) This article describes the philosophy behind the Open Source DotSVN library and how the same can be used to connect to a Subversion File repository from .NET applications.
Visual Basic 2008 – Introducing Extension Methods
(Mike McIntyre) Visual Basic 2008 extension methods enable you to “add” functionality to existing types without creating a new derived type.
From MySQL to Oracle: A Few Differences
(Augusto Bott) As stated on my first post on this blog, I’m a MySQL DBA trying to draw a map of this new (to me) world called Oracle. The other day I was trying different things with Oracle, like (but not limited to) issuing kill -9 to random Oracle processes to see what would happen (on my own box
Increase productivity in Java database development with new IBM pureQuery tools, Part 2: Detect and fix SQL problems inside Java program
(Sonali Surange and Becky Nin) With IBM pureQuery technology and tools, detect various problems as you code SQL inside your Java program. Boost productivity developing database applications under different scenarios during a product development and deployment cycle, and customize SQL validation to y
One of those weird ones – ora-32036
(Dominic Brooks) I’ve mentioned before that I really like using WITH subquery refactoring. Apart from anything else, I like the way it helps me identify the proper sets involved in a query, particularly when looking at other people’s complex SQL.
Vista Versus VB
(Karl E. Peterson) Microsoft has suggested, in a somewhat backhanded way, that the VB6 development environment (IDE) will be supported for the lifetime of Vista. Here’s their latest summation of the future of Classic VB support: The Visual Basic team’s goal is that Visual Basic 6.0 applications t
Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
(Peter Zaitsev) Quite typical query for reporting applications is to find top X values. If you analyze Web Site logs you would look at most popular web pages or search engine keywords which bring you most of the traffic. If you’re looking at ecommerce reporting you may be interested in best selling
Database Storage with SQL Server – Part II
(Vinod Kumar) This is in continuation to the storage story we had at http://www.extremeexperts.com/sql/articles/StoragePractice.aspx. With that as foundation let us take a step closer to other aspects to the storage system like what needs to be taken care when working with physical files, filegroups
COPY_ONLY backups and SSMS
(Tibor Karaszi) Here’s a suprising one: SQL Server 2005 introduced the COPY_ONLY option of the BACKUP command. This is relevant for Database backups. The backup will not intervene with your differential backups (will not reset the BCM pages). Log backups. The backup will not break the log c