(Jeremy Kadlec) When SQL Server performance is critical, inevitably you find a problem related to a CPU, I/O or memory bottleneck. The culprit is typically related to the architecture (hardware or software) or the code being executed. With such a broad scope to determine the root cause of the perfor
Author: SSWUG Research
Index Build strategy in SQL Server – Part 3: Offline Serial/Parallel Partitioning
(Lyudmila Fokina) There are two main categories of partitioned index build: –Aligned (when base object and in-build index use the same partition schema) –Not- Aligned (when heap and index use different partition schemas (including the case when base object is not partitioned at all and in-bui
SQL Server 2005 Compact Edition: The Little Engine That Can
(Josh Fitzgerald) Microsoft SQL Server 2005 Compact Edition (SQLce) is the newest version of Microsoft’s mobile database solution. SQLce provides relational database functionality for mobile and desktop applications through a lightweight and easily distributable engine. Applications that need relati
A meaningful Web for humans and machines, Part 2: Explore the parallel Web
(Lee Feigenbaum and Elias Torres) In this series of articles, we present a thorough, example-filled examination of the existing and emerging technologies that enable machines and humans to easily access the wealth of Web-published data. In this article, we examine the concept of the parallel Web and
Creating a Custom BuildProvider in ASP.NET 2.0
(Bilal Haidar) Last week we were trying to generate some source code in the form of a C# class out of an XML file that contains some settings configuration at run time and yet, be able to have an intellisense at design time. This is all said and the .NET environment is .NET 1.1. After so much resear
Open Source Licensing: BSD and GPL
(Dru Lavigne) There are nearly 60 licenses which have been approved as meeting the Open Source definition. In today’s post I’ll talk about the originating philosophies behind two of the better known licenses, the BSD and GPL.
Perform actions at set intervals with VB.NET’s Timer control
(Irina Medvinskaya) Developers are often required to make a specific action take place on a form on a regular basis or after a set time interval. One way you can achieve this functionality is by using VB.NET’s Timer control. In this quick tip, I show you how to work with the Timer control in your ap
Invalid stored procedures
(Brian Peasland) When running an application that is connected to an Oracle server/database, and trying to add rows or make a call to the DB, I am getting various errors that I believe are stating that the stored procedures are invalid. This is the first time I am using Oracle (10g). Is there anythi
DB2 V8 Common Criteria reporting tool for DB2 V8
(Willie Favero) Are you familiar with Common Criteria? Did you know that DB2 for z/OS Version 8 can be Common Criteria compliant? If you know the answers to both of these questions, then you are probably going to be interested in the APAR that just closed the middle of December 2006. If none of this
Information service patterns, Part 2: Data consolidation pattern
(Guenter Sauter, Bill Mathews, Mei Selvage and Ernest Ostic) Business growth forces companies’ IT capabilities to evolve with changing business demands. New applications are introduced to support innovative requirements. Existing information is processed and analyzed in new ways to gain even more in