(Serdar Yegulalp) SQL Server 2000 has a number of useful albeit undocumented (and therefore unsupported) stored procedures. Among them is the sp_gettypestring stored procedure, which can be used to return the type string for a column in a table. If you’re trying to use a program to determine what a
Author: SSWUG Research
eXtreme .NET: Practice Your XP with a Fictional Case Study
(Neil Roodyn) In my book, "eXtreme .NET," I introduce a team of developers who are learning how to improve their ability to deliver great software. In this article, you’ll follow this team as they learn about a new tool to help them develop software solutions using the .NET Framework. The tool they
Mine Your Own Data with the JDM API
(Frank Sommers) The Java Data Mining API (JDM) is the first attempt to create a standard Java API to access data-mining tools from Java applications. JDM promises to bring to data mining what JDBC brought to databases, and to make data mining a new and useful part of an enterprise Java developer’s t
The .NET Show: Management Services
In this episode Alex Sutton and Marty Hough show us the improvements to the system and application event logging model that will make it easier for applications to expose details about their operational processes.
SQL Server 2005 – SQL Server Integration Services – Loop Containers
(Marcin Policht) As we briefly mentioned in the previous installment of this series, among features introduced in the SQL Server 2005 Integration Services there are For and ForEach loops, implemented in the form of containers that can be incorporated into the Control Flow part of a package design. (
Using SQL Server 2005’s New Web Services Capability
(Martin Heller) Imagine that you’re a developer at a company that wants to automate its warehouse inventory process. After the usual series of meetings, the managers agree with your original proposal to track the barcodes of every box in the warehouse. They equip the warehouse staff with hand-held P
New Unicode Consortium Technical Report on Unicode Security Considerations
Unicode Technical Report #36 on Unicode Security Considerations "describes some of the security considerations that programmers, system analysts, standards developers, and users should take into account [when using the Unicode Standard], and provides specific recommendations to reduce the risk of pr
Oracle 10g – Nifty little features
(Lewis R Cunningham) There have been a lot of blogging about the new Oracle features like SQL Tuning Advisor, SQL Access Advisor, AWM, the scheduler, etc. Here are a few items that I haven’t heard much about but are nifty little time savers. These are the kinds of things that make life just a little
Datafile Location and Storage Information
(Pavel Descoteaux) This script provides datafile location and storage information for the connected database. The script works with UNIX, Linux, or Windows. Simply run this procedure with DBA Administrator privileges so that all SYS objects can be queried.
XML Integration With ADO+
(Pawan Bangar) One of the most important design goals for ADO+ was powerful XML support. Microsoft designed ADO+ hand in hand with the .NET XML framework. Both are components of a single architecture. The unification of ADO+ with the XML framework happens in the dataset.