by Kiran Pai – I have found that many articles found on the net are good and detailed but they are not really friendly to novice programmers.In my article the topic is presented as a Q&A session. Most of the questions are the ones that most novices would like to ask. And the Answers are pres
Author: SSWUG Research
Magazines Announce Best of Show Awards
Penton Media announced that Winternals Software LP’s ERD Commander 2002 won Best Overall Product in the Windows & .NET Magazine and SQL Server Magazine Best of Show Awards at Microsoft TechEd 2002.
INF: Authentication Methods for Connections to SQL Server in Active Server Pages
SQL Server authentication relies on the internal user list maintained by the SQL Server computer. This list does not include Windows NT users, and is specific to the SQL Server computer. Users are created and configured using the SQL Server Enterprise Manager. To use this authentication method, perf
Use XML File as database
(Yasir Osama) In this article I will show you how to use XML file as a storage area later. When you store information on xml file you will save time and system resource if you use access database the process is more complicated, an Access database have limits on the number of users using it at a giv
Database future debated
By Paul Krill – SAN JOSE, CALIF. — Whether the future of databases is the traditional, relational and SQL model with XML technologies incorporated into it or a new XML-based model is a matter of debate, according to panelists during a session Tuesday at the Software Development Conference & Expo he
Strange Transformations
by John E. Simpson – In this month's Q&A column, John Simpson explains how to handle unwanted CDATA sections in source trees and offers some advice for serving XHTML to old browsers.
Get EXPLAIN PLAN without running the query
(Anant Verma) There are times when one needs to see the path that Oracle will choose for a particular query WITHOUT actually running it. It may be a very long-running query and trying to iteratively tune the query can take a lot of time. There is a command (SET AUTOTRACE TRACEONLY EXPLAIN), which wh
Don’t Shut Down That Database! Use Oracle 9i Online Object Redefinition Instead
By Chris Lawson and Roger Schrag – In this paper, two experienced Oracle DBAs will introduce you to this exciting new feature. Since neither of us works for Oracle Corporation, we’d like to think this paper is balanced and objective. First we will introduce the DBMS_REDEFINITION package. Then we wil
Free webcast: SQL Server 2000 development with Visual Basic.NET
By Tim DiChiara – Learn how to combine VB.NET & SQL Server 2000 to create slick database solutions & XML web services. Join us for a free webcast on Tuesday, April 30, 2002 at 01:00 PM EDT (17:00 GMT), with author Rick Dobson!
Notification Services Beta Program
SQL Server 2000 Notification Services makes it easy to develop and deploy applications that generate and send personalized notifications to wired and wireless devices. Notification Services scans input events from a wide variety of sources, matches these events against a user’s subscriptions, genera