(Peter Aitken) In two recent articles we looked at file access in the .NET framework—how to write data to and read data from both binary and text files. There’s one more aspect of file programming that a developer needs to know about, and that’s the file management tasks: –Creating and deleting
Author: SSWUG Research
An Orcas Preview: Go Inside the Next Version of VB
(Josh Fitzgerald) Microsoft is promising some exciting new features for Visual Basic 9 (codename: Orcas). The enhancements will include better-integrated support for handling data, increased support for dynamic typing, and language features that will reduce code redundancy and improve programmer pro
CLR Stored Procs Rock
(Payton Byrd) There’s just no doubt about it, Microsoft hit a major, major home run with the release of SQL Server 2005 and .Net 2.0. One of the great new features is the ability to create stored procedures in any .Net language and run that code as a stored procedure from SQL Server 2005.
Memory Use in SQL Server
(Mike Hodgson) People often post questions in the SQL Server newsgroups about physical memory and how SQL Server uses it. This is a commonly misunderstood subject. The two main questions that users ask are along the lines of 1) “Does SQL Server have a memory leak? It consumes more and more memory un
Creating a DB2 user-defined function to access Web services
You can use the Web Service User-Defined Function wizard to create DB2 user-defined functions (UDFs) that can access the operations of Web services.
FIX: SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publication
Consider the following scenario. You create a merge publication in Microsoft SQL Server 2000. SQL Server 2000 may take a long time to complete the synchronization phase when one of the following operations occurs: • You add a new subscriber to the merge publication. • An existing subscriber is
Implementing Additional Methods with mysqli and PHP 5
(Alejandro Gervasio) Welcome to the third installment of the series “Using mysqli in PHP 5.” Comprised of three articles, this series teaches you how to use the most important methods and properties included in the “mysqli” extension, which is bundled with PHP 5, in order to get the most out of the
Introduction to the Analysis Services 2005 Query Log
(William Pearson) In my article, Usage-Based Optimization in Analysis Services 2005, we introduced and explored Usage-Based Optimization, gaining some hands-on exposure to the Usage-Based Optimization Wizard. We noted that the new Usage-Based Optimization Wizard improves dramatically upon the effect
Learn Oracle: The Index
(Lewis R Cunningham) I’ve written quite a few tutorial type entries in the last year and a half. You can find them if you search but I thought it would be easier to post an index of links that I can keep updated.
Data Integrity with DB2 for z/OS
(Paolo Bruni, John Iczkovits, Rama Naidoo, Fabricio Pimentel and Suresh Sane) DB2 provides functions to guarantee integrity at the system level and at the application level. From the system point of view, DB2’s integration with zSeries and disk storage architecture is the cornerstone for data integr