(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.
Other News
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
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
Automating mantenance tasks on MySQL
(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:
Using the javax.xml.bind annotations to convert Java objects to XML and XSD
(Jeroen van Wilgenburg) Did you know that when you put the @XmlRootElement annotation on any class you can have an XML representation of that class?
Reducing Database Size by Using Vardecimal Storage Format
(Sunil Agarwal and Hermann Daeubler) Learn about the new storage format for storing decimal and numeric data in SQL Server 2005 SP2. Details include when and how to enable vardecimal storage format, restrictions, space savings, and its impact on the performance of your workload.
When Information Flows Better, Organizations Work Better
(Richard Blahunka) Improving the flow of information and knowledge within and organization doesn’t necessarily produce immediate, dramatic and observable changes; rather, the business just operates better in many subtle ways over time.
Let’s continue our discussion on CLONE tables in DB2 9 for z/OS
(Willie Favero) Back on March 23, 2007, before DB2 9 officially went GA, I had a short post that discussed CLONE tables in DB2 9 for z/OS. I didn’t want to go in to a lot of detail at that time because DB2 9 wasn’t available yet. However, now that it has been out for a few months, I would […]
Oracle Session Tracing Part II
(James F. Koopmann) Read on and learn how to set the module and action names.
Partition pruning tip: Use comparisons of column, not of partitioning function value
(Sergey Petrunia) A customer issue has drawn my attention to this this pecularity: if partitioning is done by the value of some function, then partition pruning module will make use of comparisons of the partitioning column(s), but not of comparisons of the value of the partitioning function.
