(Brad M. McGehee) As the forum administrator for SQL-Server-Performance.Com, I see hundreds of questions from DBAs on SQL Server clustering. What always surprises me is how misunderstood clustering is. So exactly what do I, and Microsoft, mean when we refer to SQL Server 2005 clustering? Here’s a go
Author: SSWUG Research
DB2 9 Application Development exam 733 prep, Part 2: DB2 data manipulation
(Sunil Sabat) The material in this tutorial primarily covers the objectives in Section 2 of the exam, entitled “Data manipulation.” (R)
See performance gains by using indexed views in SQL Server
(Tim Chapman) A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a virtual table to simplify queries and add a layer of security to your base tables; however, it does not take up any space in the database. In fact, a view really doesn’t
Moving An SQL Server Database
(Desirée Harris) A database move can be done a couple different ways, but when the database is updated frequently and the move needs to be completed with minimal downtime and no data loss, it is best to move it by detaching and then reattaching the database on the new server. The database will be of
Mastering OLAP Reports: Extend Reporting Services with Custom Code
(William Pearson) As I have emphasized throughout the articles of the series, the most powerful characteristic of Reporting Services is the unprecedented flexibility it offers us in creating reports specifically tailored to our business environments. It affords us the capability to innovatively empl
Monitor db2 backup, restore and recover operations in real-time
(David) DB2 has a nifty feature that allow you to view the list of active utilities on the instance.
Interview with Sanjiva Weerawarana: Debunking REST/WS-* Myths
InfoQ’s Stefan Tilkov had a chance to talk to Sanjiva Weerawarana, who founded WSO2 after having spent nearly 8 years in IBM Research, where he was one of the founders of the Web services platform. During that time, he co-authored many Web services specifications including WSDL, BPEL4WS, WS-Addressi
How to Use Oracle (21) – Bitmap indexes
(Dratz) I’ve been thinking over the last couple of days of how best to try and explain bitmap indexes. It’s one of those topics where I thought I had a good explanation, then thought it wasn’t so good, then thought it was great, then wasn’t sure.
Delete rows during updates using Oracle 10g’s MERGE statement
(Bob Watkins) The MERGE statement, introduced in Oracle 9i Release 2, is often called an “upsert” because it can both update and insert rows in the same pass. It’s a real timesaver for Extract, Transform, and Load (ETL) applications, such as loading a data warehouse. Rows that don’t already exist in
Creating an RSS Reader Application
(Jacques Noah) In the previous two articles we discussed how to read and build an RSS document with PHP. In this article we will create an application that uses the concepts discussed in the other two articles. So let’s go straight to the coding.