(David Alejo Marcos) Tuning has always being good fun and something like a challenge for me.
Other News
Implementing Foreach Looping Logic in SSIS
(Robert Sheldon) One of the handiest features in SQL Server Integration Services (SSIS) is the ability to implement looping logic within your control flow. By using the Foreach Loop container, you can create a looping structure that iterates through a collection of objects or data values (the member
No-risk SQL Server upgrade for SSRS no problem
(Roman Rehak) Any time you run an in-place SQL Server upgrade, you risk something going wrong; for example, your server or application could break. When this happens, you need to revert to the previous version, uninstall the software, reinstall the previous version and restore settings and databases
Column Groups – Edge Cases
(Randolf Geist) Oracle 11g added Extended Statistics support for column groups in order to detect correlated columns for filter predicates using an equal comparison.
Adaptive Compression in DB2 10
(Chris Eaton) IBM has been focused on compression in DB2 for many years now. With 9.1, DB2 implemented table compression using a unique global table object dictionary to compress out globally repeating patterns from tables.
The coming in-memory database tipping point.
(David Campbell) In this post I want to spend some time discussing “in-memory” database technologies and Microsoft’s technical roadmap in this space. In-memory database technologies are approaching a disruptive tipping point for the database industry and we’re going to hear a lot more about them goi
Using TSA/db2haicu to automate failover – Part 1: The Preparation
(Ember Crooks) I’ve actually been hating db2haicu lately. I had 3 different environments where I had to set it up over the course of about 2 weeks, and none of them went simply and smoothly. As of the writing of this post, I’ve managed to get one working by myself and one working with the help of on
FAST Search for SharePoint 2010 Item-Level Security Using FAST Search JDBC Database Connector
(Carlos Valcarcel) When setting up an enterprise search service, it is necessary to apply specific access restrictions different parts of the crawled content. When crawling database content into FAST Search for SharePoint 2010, using the BDC framework is the preferred method for implementing item-le
NetSerializer – A fast, simple serializer for .NET
(Tomi Valkeinen) This article describes a simple method to serialize objects on .NET platforms, which, I believe, is the optimal method to do the serialization when compatibility or versioning are not a concern. The article also contains an implementation of this method, called NetSerializer, and a
Insert Value From Radio Button in MySQL in PHP
(Vineet Kumar Saini) In the previous article you saw how to insert a value from a textbox into a MySQL database in PHP. In this article you will see how to insert a value from a radio button into a MySQL database using PHP.