(Coskan Gundogar) Fantastic feature called guaranteed restore point came with Oracle 10G R2. By this feature, you can set a restore point which will remain until you drop it. The best part of this feature is, it uses db_file_recovery_dest to keep the changed blocks, even if flashback logging is not
Other News
Windows Forms – Aligning Two Forms
(Ged Mead) This tip barely qualifies as a Gotcha! but I have seen some people get stuck with it, so thought it worth a mention.
SQL Tip::Comparing pure DATE component of DATE field.
Normally when we need to compare DATE type where only DATE (i.e DD/MM/YYYY) component holds the significant, we need to convert DATE into VARCHAR2 or use TRUNCATE as follows so that only date component is compare(not time):
How to extend the native MessageBox dialog in .NET
(Yifeng Ding) In this article, I will explain how to extend native message box in managed code. There’re two functions that I will add to the message box. –Displays a countdown message, automatically closes the message box when specified timeout expired, and returns the default selection of the
Overloading and Overriding in Visual Basic.NET 2005
(Jagadish Chaterjee) This article gives you an in-depth understanding of the differences between overloading and overriding in Visual Basic.NET 2005. It is assumed that the reader knows something about object-oriented programming in Visual Basic.NET.
Creating Custom NUnit Assertions
(Brian Mains) NUnit is an excellent utility in supporting application development. Based on JUnit, NUnit tests .NET applications by making assertions about the code, allowing you to compare properties within your objects for certain values. For the unit test to succeed, all of the assertions must ev
XML AUTO vs. T-SQL commands in SQL Server
(Michelle Gutzait) As a DBA, I tend to look at performance issues and therefore would like to make sure that performance will not be affected by the use of XML (Extensible Markup Language). In this first article of a series, I’ll show performance implications by comparing the XML AUTO function with
Close These Loopholes in Your Database Testing
(Alex Kuznetsov) Incorrect or incomplete database unit tests may run successfully, but they may not expose all the problems in your application – they can only give you a false sense of security. The following guidelines will help you improve your database unit tests.
mysql query cache
(Jayant Kumar) Mysql 4+ has a feature known as query cache. Here mysql caches the result set. So suppose a query is run and it takes 5 seconds to run and query cache is enabled, so results are cached in the cache. Next time if the same query is run again (remember – exactly same query that is strcmp
U.N. Site Hacked with SQL Server Injection…
Webcast Tomorrow – Register Now Day 30 as DBA This follow-on to the Day 1 as DBA show will go into the things you can do now that you’re semi-established in your routines. Daily maintenance, auditing, security checks, best practices and more. There is a lot to consider and think about when you’re putting a good foundation in place for […]