(Ed Tittel) What with a new desktop OS (Vista, in all its many versions) and a new version of MS Office (2007) on the scene, there’s been plenty of action around Visual Studio in the past few months. Given all the new functionality those two introductions trailed in their wake, not to mention more t
Author: SSWUG Research
Poking around SQL Server’s Transaction Log
(Andrew MacNeill) I recently had the opportunity to try and figure out why SQL Server was doing certain things in one of my applications. This application was using CursorAdapters and for some strange reason, data was being cleared out (for no apparent reason, of course).
DB2 Import Commands Failing With ‘transaction log for db is full’ Errors
(Andrew Law) Trying to upload test data with the DB2 Import Utility. I have a .CSV file with 100,000 records in it. It used to work; then I added another column and now it fails with “transaction log for database is full” errors.
Special: Adam Machanic interviews Sean ODriscoll, General Manager for the Microsoft MVP Program – what is the MVP program, how does it work and more
Pro-Center Video Programming for IT Professionals
A Development Gem
(Daniel F. Savarese) Web application development presents a set of challenges different from those encountered in the development of self-contained desktop or server software. Whereas the interconnections between program modules in self-contained software are determined largely at compile time, the
A Look at the PBXT Storage Engine
(Robin Schumacher) Every now and then I get a big reminder of how great it is to be a part of the open source way of doing things. Having a strong community of MySQL lovers who use the free and open source MySQL database server and pay MySQL AB with code contributions and bug reports is truly a grea
.NET Application Extensibility, Part 2
(Jack Gudenkauf and Jesse Kaplan) In our first column, where we introduced the new System.AddIn namespace in the Base Class Libraries (BCLs), we walked through the typical process customers undertake in order to provide extensibility through their host applications. We discussed the functionality ne
Sending E-mail with Database Mail in SQL Server 2005
(Tim Chapman) As technology continues to advance, the increasing need to know what is occurring in your information systems requires more advanced solutions. It’s extremely advantageous to be able to be quickly and easily notified of situations, especially about potential problems; Microsoft continu
SSAS Partition Slicing
(Eric Jacobsen) SSAS uses partitions to contain cube data. Small cubes might use only one, but for non trivial cubes, cube designers will create partitions based on ease of managing data and to split groups of data. This document discusses how the server uses “slices” to examine partitions at quer
Meet the specs: WS-RT 1.0 operations, Part 3
(Kane Scarlett) Meet the WS-ResourceTransfer 1.0 initial draft specification, a proposed open standard that extends certain operations by allowing fragments of XML code in a single resource to be addressed instead of having to affect the entire resource. This article provides a closer look at how th