(Ashish Kumar Mehta) Like most organizations, we are planning to upgrade our database server from SQL Server 2005 to SQL Server 2008. I would like to know is there an easy way to know in advance what kind of issues one may encounter when upgrading to a newer version of SQL Server? One way of doing t
Other News
Policy Based Management and BCP
New SelecTViews Show Available! More, smaller databases? Manage your checklists, our featured blog of the week for business intelligence…Also, the hotmail outage and SQL Server, 3rd party tools and more. [Watch The Show Here] Featured Article(s) Improving .NET Application Performance and Reliability with Managed Database Connectivity (Part 1 of 3) Whether your .NET applications are built using C# or VB.NET, […]
VS 2010 SP1 (Beta) and IIS Express
(Scott Guthrie) Last month we released the VS 2010 Service Pack 1 (SP1) Beta. You can learn more about the VS 2010 SP1 Beta from Jason Zander’s two blog posts about it, and from Scott Hanselman’s blog post that covers some of the new capabilities enabled with it.
New book: Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture
(Susan Visser) A complete best-practice data integration blueprint for reducing data warehouse costs and improving results
Changed Catalog Tables in DB2 10
(Troy Coleman) With DB2 10 comes many changes in the catalog. In last week’s blog, I wrote about how some tables have been split out into new table spaces, which may have an impact on your catalog utility maintenance jobs such as imagecopy, runstats or reorgs.
Building an iPhone chat app from the ground up
(Jack D Herrington) In this article, work through the entire process of building an iPhone chat application from the server all the way to the user interface on the front end.
A favourite application: Microsoft XML Notepad 2007
(M3 Sweatt) A shout out on a new, refound favourite application: Microsoft XML Notepad 2007, a simple intuitive user interface for browsing and editing XML documents.
Adding CLOB values to XML as CDATA
(Samet Basaran) Adding large CLOB values into an XML structure using XMLDOM package in PL/SQL is challenging because XMLDOM methods do not accept CLOB data type.
Hash Joins – What is Wrong with this Statement?
(Charles Hooper) I started reading the book “Pro Oracle SQL” a couple of days ago, and I am having trouble putting it down. Other than a couple of minor word substitutions and intended, but not specified, qualifying words, the first 100 pages of the book are fantastic (I suspect that many of these
Basic Apex scripting – show/hide & labels
(Scott Wesley) Sometimes the scripting requirements for an Oracle Apex page are fairly simple, yet determining the required modifications can be frustrating, particularly for a beginner in either Apex or HTML behaviours.