(Sara Cushman) Though plenty of people have already caught a glimpse of SQL Server 2005, and some companies are even using Beta 2 in production environments, most enterprises won’t be seeing the latest release of Microsoft’s DBMS until it ships early next year. But attendees at 2004 PASS Community S
Author: SSWUG Research
Delegates vs. Interfaces in .NET
(Jon Shemitz) When you write .NET code that takes callback parameters, your first instinct may be to use delegates, but it may not occur to you that you can use an interface instead. Learn why and when an interface may be a better answer.
Multiple Active Result Sets (MARS) in SQL Server 2005
(Christian Kleinerman) All Microsoft SQL Server data access application programming interfaces (APIs) provide an abstraction to represent sessions and requests within those sessions. SQL Server 2000 and earlier restricted the programming model such that at any point in time there would be at most on
Using Oracle’s Redefinition Package for Performing Online Reorganizations
(Tom Szekely, Gil Candia and Danny Pham) This paper discusses the use of Oracle’s Redefinition Package to perform online reorganizations in Oracle 9i and 10G databases. The paper describes the redefinition process, the commands used to perform the redefinition online, and certain limitations an
A Baker’s Dozen: Thirteen Things You Should Know Before Porting Your Visual C++ .NET Programs to Visual Studio 2005
(Stanley B. Lippman) This article discusses issues that developers should be aware of when porting applications to Microsoft Visual Studio 2005.
eServer i5 and DB2: Business Intelligence Concepts
Business Intelligence (BI) is a popular and powerful concept of applying a set of technologies to turn data into meaningful information. With Business Intelligence Applications, large amounts of data originating in many different formats (spreadsheets, relational databases, web logs) can be consoli
Operating DB2 DataPropagator
This chapter describes how to operate the Capture and Apply programs generally. This chapter also describes regular database maintenance, monitoring replication, handling gaps, and modifying your replication configuration.
The XML Litmus Test
(Dare Obasanjo) This article provides some simple guidelines for determining when XML is the appropriate technology to use in a software application or architecture design.
MSDE With SQL Web Data Administrator : Authorization
(Scott) In our previous article we examined authentication with MSDE. In this article we will take a close look at authorization. Specifically, we will see how to use and manage database roles, and how to grant, revoke, and deny permissions to database objects and statements. If you need to inst
Trouble with Mixed Extents
(Kalen Delaney) Last month, in “Mixed Extent Usage,” I discussed the algorithm that SQL Server 2000 and 7.0 use to allocate space to a table or index. I also introduced the undocumented DBCC EXTENTINFO command. This command can show you which extents SQL Server has allocated to an object as uniform