(Ed Wilson) In this guest blog post, you will learn how to create a Windows PowerShell parser to parse the XML file generated using ExBPAcmd.exe.
Other News
ORA-31603: object ‘XYZ’ of type CONSTRAINT not found in schema …
(Flavio Casetta) Here is a classical situation where I don’t know if I am staring at a bug, at a feature or I am simply drunk. I am executing DBMS_METADATA.GET_DDL in an Oracle XE (10g) instance, in order to get the DDL for the table constraint as an ALTER statement, but the function throws a weird
What you need to know about Column-Oriented Database Systems
(Conor O’Mahony) Column-oriented database systems (Column Stores) have attracted a lot of attention in the past few years. Vendors have quoted impressive performance and storage gains over row-oriented database systems. In some cases, vendors have even claimed as much as 1000x performance improvemen
Finding tables without primary keys
(Giuseppe Maxia) I was checking a third party server, and I needed to find if there were tables without primary keys. This is important to know, not only because the lack of primary keys affects performance and data accuracy in general, but also because in row-based replication performance can degra
General Formatter for .NET 3/4: Implementation
(Zoran Horvat) This is the third of four parts this article consists of:
SQL Server Virtualization Advantages and Disadvantages (Part 2 of 5)
(Scott Shaw) Your previous tip helped define the VM environment and discussed some of the advantages and disadvantages of virtualization. What about virtualizing SQL Server? Is this always a good idea? What are some things I need to think about? Check out this tip to learn about the advantages and
SQL*Plus Formatting Commands
(Barry McGillin) Since the last post on SQL*Plus commands was completed, we have also added more functionality to the SQL Developer’s SQL*Plus support.
Web Forms Model Binding Part 1: Selecting Data (ASP.NET vNext Series)
(Scott Guthrie) The next releases of .NET and Visual Studio include a ton of great new features and capabilities. With ASP.NET vNext you’ll see a bunch of really exciting improvements with both Web Forms and MVC – as well as in the core ASP.NET base foundation that both are built upon.
SQL Server Myth – Table Name cannot be same as Database Name
(Nakul Vachhrajani) Microsoft SQL Server is home to many myths and legends, and I have developed an interest in knowing about them. It is really a very interesting exercise to know about these myths, and prove them incorrect if the situation permits.
APAR Friday: WLM information comes to a DB2 DISPLAY command
(Willie Favero) Every once in while magic happens and cool stuff just falls form the sky. This is what in a way happened to me this morning. You see, the other day, I was actually talking to someone about how I can find out the service being used by a DB2 task. We were able to discover it. Howeve