(Eric Brown) With SQL Server 2005 up and running, there are some things you can do to make life easier as a developer — without having to become a database administrator. One of the most common pains in the rear end is change management. While most developers are familiar with Microsoft Source Safe
Author: SSWUG Research
Group by GROUPING SETS for custom rollups in Oracle
(Bob Watkins) When you use GROUP BY with the summary functions like COUNT and SUM, you normally don’t get multi-level totals. Each unique combination of the columns in the GROUP BY generates a total, but these totals aren’t “rolled up” into higher level totals.
Query Execution Timeouts in SQL Server (Part 1 of 2)
(Senqiang Zhou) This short article provides a checklist for query execution time out errors in Yukon. It does not touch the time out issues on optimization and connection. Before reading this article, you are recommended to read the following post to get familiar with SQL Server memory management ar
VB.Net Lists: Add some elegance to your code
(Craig Murphy) It is a fairly common programming scenario to find ourselves with a list of identical objects. In the past, without adequate support from programming languages, we found ourselves writing a lot of searching and sorting code, and that may have put you off using lists in favour of array
Using SOA with WebSphere Process Integration products: Part 6: Business measures and monitoring
(Bhargav Perepa and Carol Serna) The first article in this series develops a business process model using IBM WebSphere Business Modeler. This article develops the model further by demonstrating how to add a business measures model that uses WebSphere Business Monitor to monitor the BPEL workflow ap
Oracle DBA Concepts Part-2
(Fahd Mirza) In order to efficiently and intelligently manage an Oracle database, you have to have a sound knowledge of its underlying architectural details. This knowledge pays off because it is directly linked with DBA’s job. The real job of DBA starts after the installation of database, when he e
Learn the basics about structured exception handling in VB.NET
(Irina Medvinskaya) One of the most reputable changes in the Visual Basic language is the introduction of structured exception handling in VB.NET. While the latest version of the language still supports the On Error Goto type of error handling, it’s not preferred; instead, you should use structured
Dynamic Webpages with JSON
(Ajay Raina and John Jimenez) Making asynchronous HTTP requests from Webpages is an effective technique in bringing seemingly static pages to life. Asynchronous JavaScript and XML (AJAX) has become a popular technology in creating richer and more dynamic Web clients, and is often used to incorporate
A Practical Approach to .NET Testing using Visual Studio 2005 Test Team Suite
(Jawahar Govindaraj) This document will cover practical approach to White box Testing Techniques using Microsoft Visual Studio 2005 Test Team Suite. It covers concepts with a simple, easy to follow example.
FIX: You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000
Consider the following scenario: • You compare strings by using one of the width sensitive collations in Microsoft SQL Server 2000. For example, you have three strings. You compare these strings by using the Latin1_general_CS_AS_WS collation. • Two of the strings contain punctuation characters