(Rob Downer and Shantan Kethireddy) Having a good indexing strategy is imperative to achieving high query performance on any database platform. A comprehensive and efficient indexing strategy can mean the difference between queries that complete in seconds rather than minutes or hours. Implementing
Author: SSWUG Research
Windows Workflow: Rules and Conditions
(scott) Software applies knowledge to data. This is true for all software from business applications to video games. The knowledge inside software is generally a combination of procedural knowledge and declarative knowledge. Procedural knowledge is information about how to perform a task, like how t
Application Architecture Decisions: Datasets and Objects
(John Mueller) Microsoft must love new database technologies. They’ve created a whole alphabet soup of technologies, making it hard for any developer to keep up. Some older technologies, such as Open Database Connectivity (ODBC) are very much alive and in common use today. Others, such as Remote Dat
Upload multiple files to VarBinary column in SQL Server 2005
(Muthusamy Anantha Kumar) This article discusses how to upload multiple image or text files to the SQL Server database varbinary column.
MySQL UDFs
(DarkLizener) This tutorial explains what a User Defined Function (UDF) is, what it does, and why/when it is useful.
Microsoft makes AJAX easier
(Matt Nicholson) Microsoft ‘Atlas’ aims to make AJAX development much easier for the Visual Studio developer, thanks to client-side Javascript code and AJAX-enabled controls on the server. Matt Nicholson finds out more from Microsoft’s Mike Ormond and Ian Moulster.
Migrating from Data Transformation Services to Integration Services in SQL Server
(Kirk Haselden) When presenting Integration Services (IS) to current or former Data Transformation Services (DTS) users, one of the first things they want to know is how Integration Services will affect their current packages. The questions come in different forms, such as the following: Will it bre
Meet the specs: Intro to WS-ResourceTransfer 1.0
(Kane Scarlett) The WS-ResourceTransfer 1.0 initial draft specification defines extensions to WS-Transfer, a general SOAP-based protocol for accessing XML representations of Web service-based resources. The family of Web services specifications, the “WS-” group, is designed to interoperate with othe
The DB2 business game
(Pat Moffatt and Jessica Cao) If you’re a beginner with IBM DB2 and SQL, you may wonder how the technical skills you’re learning are used in the “real world.” Here is a chance for you to put your DB2 SQL skills into play in this interactive game! Jump into a “run your own business” scenario, where y
FIX: You cannot uninstall SQL Server 2000 build 2187 when SQL Server 2000 build 2187 is configured as a Microsoft Cluster Service (MSCS) node
Consider the following scenario. Microsoft SQL Server 2000 build 2187 is configured as a Microsoft Cluster Service (MSCS) node. You try to uninstall SQL Server 2000 build 2187 by using Add or Remove Programs. In this scenario, you cannot uninstall SQL Server 2000 build 2187.