(Willie Favero) With each new month, we are almost always getting a few of the product publications refreshed. That trend continues for December with all the active releases of DB2 getting a little something new…
Other News
Optimize data availability and resource utilization with InfoSphere Optim Configuration Manager
(Thuan Bui) Maintaining database and application uptime while improving performance and lowering costs is an important challenge for DBAs and IT organizations.
Find out the referenced tables of a table that to be added as articles in replication
(SQLZealot) In replication, we need to add objects as articles to replicate the data to different server.The important point is here that if we have any reference(foreign keys) associated with the articles(tables choosen to be replicated), then we need to consider the parant table also to add as art
WebService Attribute’s Property in Web Service
(Alok Pandey) The WebService attribute is used for giving a description (generally, about using the service ) of a web service by adding some information. Here I am describing it’s properties by which we add description to web service.
SQL Server’s Data Quality Services makes cleanup a cinch
(Denny Cherry) SQL Server’s Data Quality Services is a data-cleansing feature that will be introduced with the upcoming SQL Server 2012, but is now available in a release candidate edition. The application lets database administrators set up a standard set of values for an existing table. It then ch
More MySQL foreach()
(Shlomi Noach) In my previous post I’ve shown several generic use cases for foreach(), a new scripting functionality introduced in common_schema.
Customizing InfoSphere MDM Server using pluggable business object query and pluggable SQL framework
(Prashanta Chandramohan) IBM InfoSphere Master Data Management Server is a highly customizable product that can meet stringent performance and scalability requirements. To meet specific performance requirements of clients, the product offers a pluggable business object query and pluggable SQL framew
Determine SQL Server Date and Time with DATEPART and DATENAME Functions
(Tim Cullen) As with most applications and databases nowadays, our application retrieves data that has at least one date in the record. There are times when we need to return the name of day or retrieve the month or day from the data. What functions does SQL Server offer to assist in this area? Che
Cache is King
Cache is King When it comes to SQL Server, you can never have enough memory. Yesterday I circled back to the topic of SSD due to the upcoming release of SSD technology from the Intel and Micron partnership. As you may have guessed, all SSD implementations are not alike. And, no matter what, RAM is the fastest data access available […]
New SSD Coming to Market
New SSD Coming to Market Intel and Micron’s join venture into SSD technology is going to hit the market next year. They are already in production with 64 gig chips, and working to release 128 gig chips as well. SSD technology is great for slow changing data. This is due to the fact that the SSD read/write cycle is greatly […]