(SANJIT SIL) All web forms are actually instances of the ASP.NET page class, which is defined in the System.Web.UI namespace. The Page class inherits from the TemplateControl class, which in turn inherits from the Control class. As a result, the Page class provides useful properties and methods that
Other News
How the SQL UNION Affects Table Design
(Kenneth Downs) Last week we saw a JOIN. A JOIN will combine values from two (or more) different tables and put them into the same row of the output.
APAR Friday + 2: A couple APARs I missed yesterday
(Willie Favero) I’m still trying to catch up on my APARs from last Friday. I made the post before I actually finished doing all of the write-ups. I didn’t want to miss an actual APAR post on Friday. So here is the last installment of the APARs I “should” have posted about 2 days ago (the +2 in the t
Performance impact of controller cache: SQL Server OLTP workloads
(Linchi Shea) Through empirical data presented in my two previous posts on the performance impact of controller cache configurations on sequential disk I/O workloads and large SQL workloads, we observed that allocating controller cache to writes would result in better performance, at least with the
Running Parameterized SQL Commands using the Execute SQL Task – II
This post is a continuation of the SSIS series of posts that we had done before: DTS vs SSIS, Execute SQL Task, and running parameterized SQL commands using that task. In today’s post, we will continue the previous post and will cover parameterized queries in the Execute SQL task and returning the r
How do I use BCP in SQL Server?
(Steven Warren) The Bulk Copy Program (BCP) is a command-line utility that ships with Microsoft SQL Server. With BCP, you can import and export large amounts of data in and out of SQL Server databases quickly and easily. Any DBA who has utilized this functionality will agree that BCP is an essential
Business Intelligence
(Buck Woody) There is a lot of confusion around the term “Business Intelligence”, most of it generated by the people who sell “Business Intelligence” software. In fact, most Business Intelligence projects fail — that’s right — most of them. There are a lot of reasons, and the primary one is unmet ex
The information perspective of SOA design, Part 5: The value and use of Rational Data Architect in SOA
(Brian Byrne, David McCarty, Dr. Guenter Sauter and Peter Worcester) Discover how you can use the IBM Rational Data Architect, IBM Industry Models and the unified metadata management of IBM Information Server to align process, service, and data models. Use these tools to accelerate your SOA project.
Oracle Database 11g: SQL Plan Management, Part 3
(Jim Czuprynski) Oracle Database 11gR1 offers a new tool set, SQL Plan Management (SPM), that lets any Oracle DBA capture and preserve the most efficient execution plans for any SQL statement. The final article in this series illustrates how to use SPM to limit unexpected regression of existing SQL
MySQL: Getting Creative with Partitioning
Lately, I’ve been trying to keep up with at least one of the MySQL Forums: Partitioning.