(Paolo Bruni, Felipe Bortoletto, Ravikumar Kalyanasundaram, Glenn McGeoch, Roger Miller, Cristian Molaro, Yasuhiro Ohmori and Michael Parbs) DB2 10 can reduce the total DB2 CPU demand from 5-20% when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requir
Other News
Implement Gzip and Deflate Compression in ASP.Net
This tutorial will teach you how to implement Gzip and deflate compression in an ASP.Net website, allowing you to save up to 70% in bandwidth transmission.
Creating Route Constraints to Restrict Requests
(Bipin Joshi) In ASP.NET MVC applications, the requests sent by the client browser are actually “routes”. Depending on the route definitions defined by the developer the requests then reach a particular controller.
SQL SERVER – Solution – Generating Zero Without using Any Numbers in T-SQL
(Pinal Dave) SQL Server MVP and my friend Madhivanan has asked very interesting question on his blog regarding How to Generate Zero without using Any Numbers in T-SQL.
ASP.NET MVC: Using ActionMethodSelectorAttribute to Handle Multiple Submit Buttons
(Malcolm Sheridan) My first article in this series focused on how to have Multiple submit buttons in the same ASP.NET MVC form, and how to differentiate them in your action method. If you missed it you can read it here.
SSRS best practices for a trouble-free deployment
(Roman Rehak) While SQL Server Reporting Services (SSRS) platform is not difficult to learn and work with, it is still a fairly complex technology. Successful utilization of SSRS requires a combination of database, administration, report building and data analysis skills. Such a combination of exper
Data growth and standards
(Peter Haggar) Examine the challenges presented by the explosion of data, the analytics thereof, and an introduction to some standards relevant to these challenges. A sample scenario depicts a system where large amounts of data are ingested, understood, and manipulated, and where some specific stand
Rename Database Having Datafiles on ASM – 11gR2
(Anand) This blog post is about renaming the database when using ASM. Here i will be renaming the database name from “ORCL” to “MATRIX”.This method can be used for the database on lower versions (than 11gR2) also.
The PIECESIZE Clause
(Craig S. Mullins) One of the more troubling aspects of DB2 database design and creation is the non-partitioning index (NPI). Creating NPIs on tables in a partitioned table space can pose management and performance issues.
Database Mirroring In MS SQL Server – Part II
(Keshav Singh) With this video session I have tried to explain briefly how mirroring can be configured and used as one of the best fail over options for critical databases. Please use the forum below if you have any concerns.