(Thuan Bui) This is the first part of the two-part video demo where we’ll learn about the IBM Optim Performance Manager, the Version 4.1.0.1 packaging, and how to install the product.
Other News
DB2 Data Warehouse Table Space Design
(Dave Beulke) In the previous weeks we talked about getting started with a DB2 temporal table and the DB2 DSNZPARMs that will affect your DB2 data warehouse performance. This week we’ll start to design the implementation of the DB2 temporal table with a discussion of the type of table space and tabl
Integrating cloud applications with WebSphere Cast Iron Cloud Integration
(Lars Besselmann-Hamandouche) Learn how WebSphere Cast Iron Cloud Integration enables you to synchronize accounts between a database (such as mySQL) and a cloud application (such as Oracle CRM on Demand), and how this integration between different business applications can be done within days and wi
How to create a non-rectangular image in Silverlight, WPF and WinForms
(Ged Mead) In Windows Forms, it’s quite hard to create a display like this one without doing a lot of work:
Sparse columns do not take any space – Using Sparse Columns in SQL SERVER
(Sagitariusmzi) Sparse columns are the new feature in SQL SERVER 2008. Sparse columns are better, when dealing with NULL in SQL SERVER. Sparse columns do not take any space. Defining the column as sparse can save a significant amount of disk space but at the cost of more overhead to retrieve non nul
How To Create a Database in MS SQL Server 2008
(wubayou) In this tutorial you will learn how to create a databases and tables in MS SQL Server 2008.
Using the StyleVision Combo Box to Support Data Visibility Requirements
(Beth O’Brien) Altova is always on the lookout for ways to help software developers and architects meet the challenges presented by the increasingly complex collection, storage and retrieval requirements of end users. In fact, we recently enhanced the functionality of the combo box in StyleVision to
Microsoft SQL Azure just pie in the sky? Think again
(Don Jones) Here’s a fun joke heard at a recent conference: “What color is the sky when you have no clouds? Azure.” Cue big laughs at Microsoft’s expense.
Restricting memory using Resource Governor
(Tibor Karaszi) You might know that Resource Governor (RG) can be used to allow you to affect resource allocation inside SQL Server. RG was introduced with SQL Server 2008 and requires Enterprise Edition or similar/higher. There are two things you can govern using RG: cpu and memory.
The curse of the cursor
(Tony Andrews) For some reason, many Oracle developers avoid SELECT INTO as if it were dangerous, preferring to “have more control” over their code by using cursors for everything. This morning I spent over an hour debugging some code written by one such developer, only to find that the issue I was