(pabloj) I’m trying to automate some trivial maintenance tasks for my own MySQL server, and trying also to minimize the effort, so … Here is the recipe:
Author: SSWUG Research
Use multiple dump files for large Oracle exports
(Bob Watkins) Oracle’s Export utility (exp) is a useful part of an overall backup strategy. It allows you to restore as little as a single table, which is something that’s difficult to do with regular datafile-based backups. But as databases and individual tables have grown in size, it’s become diff
UAC for Application Developers
(James Bender) Over the past several years, the security of operating systems has become more and more important. In response to the perception that their operating systems are less secure than their Linux based competition, Microsoft has responded by integrating a new security mechanism called User
LINQ to SQL (Part 2 – Defining our Data Model Classes)
(Scott Guthrie) In Part 1 of my LINQ to SQL blog post series I discussed “What is LINQ to SQL” and provided a basic overview of some of the data scenarios it enables.
Pinning Objects to Improve Apps Performance
(Avanish Srivatsav) Keeping database packages in the Oracle database’s System Global Area (SGA) shared pool is a common practice. This is also called pinning. One common misconception is that pinning is not useful or needed in later Oracle database versions such as 10g and above, since those relea
Announcing the Microsoft Office Interactive Developer Map built with WPF
(Erika Ehrli) You never know what surprises each day will bring to you. Two days ago I didn’t know today was the day when we were finally sharing with the world our new learning tool for Office developers: The Microsoft Office Interactive Developer Map.
DB2 9 for z/OS, compression, REORG/LOAD, and a possible surprise
(Willie Favero) Today’s post is a short heads-up for those of you that have just moved to DB2 9 for z/OS and also use table space compression (did you notice I have to start identifying whether I’m talking about table space or index compression now). If you are satisfied with your compression’s dict
FIX: An access violation may occur when you try to log in to an instance of SQL Server 2000
Under high memory pressure, an access violation may occur when you try to log in to an instance of Microsoft SQL Server 2000. Therefore, you cannot log in.
Why Doesn’t MySQL support Millisecond DATETIME Resolution?
(Kevin Burton) Apparently, there’s been an outstanding bug for nearly two years for MySQL to add support for millisecond storage in DATETIME and TIME data types.
Source Control and Databases
(András Belokosztolszki) Many DBAs must have made and heard the request for a source control mechanism for SQL Server databases. It sounds like a brilliant idea. Once implemented, one could easily go back to a specific database schema version, compare it against the current version, and have plenty