(Buck Woody) It usually only takes one bad experience with a database to make you realize the importance of backups and recovery. In my case I was the Database Administrator for a small development firm, and I also wrote the system installation and upgrade code. One of the clients of the software ex
Other News
SQL: Merge two ‘history tracking’ tables
(Alberto Ferrari) If you have two columns in a table that “remember” their old values in two different historical tables, as it is the case in AdventureWorks with EmployeePayHistory and EmployeeDepartmentHistory, you may need (or just wonder how) to merge these two tables into only one historical ta
Distributed DBA: DB2 Deep Compression
(Roger E. Sanders) Organizations are generating more data now than at any other time. And the need to comply with legal and governmental regulations means that they’re keeping that data around for longer periods of time. The result: Databases are growing at an astonishing rate. In fact, according to
If You Had a Database Time Machine…
Tomorrow: Kim Tripp and Paul Randal interview from DevConnections. Featured Article(s) Oracle 2-Day DBA in x Days Post 1 We just got started. Follow along as we go through Oracles 2-DBA guide. It should be fun. Cure For The Mysterious SQL Server Slow-Down As a DBA have you ever received that call from the boss asking why the database is […]
The SQL Server Commodity – Feedback…
Featured Article(s) Troubleshooting SQL Server 2005 Merge Replication (Part 2) In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 merge replication. He also tells how you can resolve these problems. Virtual Server Protection and Recovery Building out your infrastructure with virtual servers brings with it the requirement that you be […]
WLM-Managed DB2 Stored Procedure Address Spaces
(Martin Packer) I was contacted by the team updating the SG24-7083 “DB2 Stored Procedures: Through The Call And Beyond” this past week. Their question was quite straightforward: “One of the statements in the book, in the chapter on WLM address space management states: To help analyze the use
Working with DropShadow AJAX Control
(Nidal Arabi) DropShadow is an extender which applies a Drop Shadow to a Panel. It allows you to specify how wide the shadow is as well as how opaque it is, or if you would like rounded corners. This article examines this ASP.NET AJAX control with the help of a sample project.
Everything about REST web services – what and how – Part 2 – design
(Koushik Biswas) In my earlier article, I introduced the concept of REST web services. Before rushing on to how to implement or code a REST web service, first we have to stop at the design station. I know many developers who are more eager to start coding before spending some time on a proper design
Oracle BI EE 10.1.3.3/2 – Drill keys and its usage
(Venkatakrishnan J) Now that i am back from my vacation, i thought i would blog about the usage of Drill keys in BI EE. It is very simple but not a lot of users know why and where it is actually used. In fact, when i was browsing through my emails today i had 2 questions that were more or […]
Oracle Security: All your DBAs are SYSDBAs and can have full OS access
(Tanel Poder) I was doing some low-level security research on Oracle 11g and realized that combining couple little known Oracle’s features can allow anyone with DBA or IMP_FULL_DATABASE rights run any OS command under the same privileges the Oracle processes are running. This allows an attacker to e