by Wei-Meng Lee – A look at the new SQL Server CE edition, included in the .NET Compact Framework, in Pocket PC applications.
Community
Archive log switch history
by Jeremy Birkett – Here is a script to track archive log switching by the day and by the hour. Since most of the work on our databases take place between the 1st and 7th of the month, the script is limited by that. It shows you the number of switches by the hour and by the day. It’s very […]
Case Study: Reducing Memory Usage with MTS
By Brian Keating – This article assumes that the reader has at least a basic knowledge of the MTS architecture—how dispatchers, shared servers, request queues and response queues all interact. The primary focus of this article is to discuss a real-world case of implementing MTS on a production datab
Book Announcement: System Architecture with XML
By Berthold Daum and Udo Merten – XML is bringing together some fairly disparate groups into a new cultural clash: document developers trying to understand what a transaction is, database analysts getting upset because the relational model doesn’t fit anymore, and web designers having to deal with s
Google SVG Search II
This week we will we will continue to make use of our previously acquired knowledge of the Google Web Services API and SVG. Now that we have the SOAP functionality in place, we need to turn towards the SVG end of the application.
Getting Started With Cocoon 2
by Steve Punte – Cocoon 2, part of the Apache XML Project, is a highly flexible web publishing framework built from reusable components. Although reusability is an oft-touted quality of software frameworks, Cocoon stands out because of the simplicity of the interface between the components. Cocoon 2
Book Review: Transact-SQL Cookbook
by Ales Spetic & Jonathan Gennick – So you have mastered Transact-SQL, and you know how to SELECT, INSERT, UPDATE, and DELETE data. But, do you know how to create and use a pivot table, how to summarize classes of sets of data, how to find the complement of a set, how to calculate a matrix trace, ho
Optimizing SQL Server Performance by using File and Filegroups
By Alexander Chigrik – Learn how to optimize SQL Server Performance using files and filegroups.
Cumulative Patch for SQL Server
Who should read this bulletin: Database administrators using Microsoft® SQL Server™ or Microsoft SQL Server Desktop Engine (MSDE) 2000. Impact of vulnerability: Three new vulnerabilities, the most serious of which could run code of attacker’s choice on server.
Oracle database code will not become open source
By Louis Chua – While Oracle Corp. is committed to the open source movement and its standards, database code will remain proprietary because there will be difficulties in providing services if customers make alterations to the source code.