Consider the following scenario. In SQL Server 2000, you use the BACKUP statement to back up up a database, a transaction log, files, or filegroups. Additionally, you specify a password in the BACKUP statement. You run the BACKUP statement. In this scenario, the statement does not run. When you open
Other News
Find It
(Alan Joch) For organizations that depend on high-quality information at every level of the company, having people find what they need—and what they are allowed to see—can be a problem. Now, Oracle Secure Enterprise Search provides a way for users to search secure content inside the enterprise, whil
Mondrian cache control
(Julian Hyde) One of the strengths of mondrian’s design is that you don’t need to do any processing to populate special data structures before you start running OLAP queries. More than a few people have observed that this makes mondrian an excellent choice for ‘real-time OLAP’ — running multi-dimen
Using XML
(J. David Eisenberg) During my second lecture to an XML class at a local community college, I explained how XML lets you define your own markup language with custom tags and attributes. I had finished defining a simple markup language for use with a list of amateur sports clubs, and had displayed a
Getting Physical with Subtypes
(Steve Hoberman) Subtyping is a powerful communication tool on the logical data model because it allows the modeler to represent similarities that may exist between distinct business concepts to improve integration and data quality.
Performance tuning RMAN backup and recovery operations (Sample Chapter)
(Matthew Hart and Robert Freeman) RMAN actually works pretty well right out of the box, and you generally will find that it requires very little tuning. However, there are a number of other pieces that fit into the RMAN architectural puzzle. When all those pieces come together, you sometimes find th
Table partitioning with SQL Server 2005
(Baya Pavliashvili) Performance tuning is the ultimate responsibility of every valuable SQL Server administrators. Although ensuring data security and availability are our topmost goals, if the applications don’t perform to the users’ expectations, DBAs often get the credit, or blame, for poor desig
Update all database statistics with a single command
(David) As with all RDBMS implementation, DB2 UDB uses the statistics information in the catalog table to derive the best execution plan. We, as DBAs, should regularly run the RUNSTATS command to keep our database statistics updated for optimal query performance.
MySQL: Transactions and Autocommit
(Roland Bouman) Some people believe that the ability to commit or rollback multiple statements as a single unit is a defining characteristic of the concept of transactions. They draw the -false- conclusion that enabling autocommit is the same as disabling transactions. It is easy to demonstrate why
Building Workflow Applications with XML and XQuery
(Michael Kay) In my previous articles, I introduced some of the mechanics of coding with XQuery and XSLT 2.0 — in a rapid progression from novice to advanced level I started with a brief ten-minute introduction to XQuery, went on from there to explore FLWOR expressions in some depth, and then expose