By Vyas Kondreddi – This is the only book available, that covers SQL-DMO for SQL Server 2000 (and SQL Server 7.0 as well). It is filled with code samples and sample applications. Authors take real world scenarios from their own experiences and show you how to accomplish those specific tasks using SQ
Other News
Oracle Will Support 10.7 For Another Year
By Gregg Keizer – In a reversal of its earlier stance — one that brought heat from some users — Oracle said Thursday it will extend limited support for its popular 10.7 business software suite for another year.
Automate MS Agents With XML
by Dan Wahlin – Here’s a sample app that uses XML to automate the speech of a Microsoft Agent character named Merlin, and to drive the text, pictures, and sentences that show up in the program. I built this Windows Forms application for kids to help give them a jump-start on reading.
FIX: Connection Leak with .NET Data Provider for Oracle in ASP.NET
When you use the Microsoft .NET Framework Data Provider for Oracle inside ASP.NET, over time, the number of connections to the Oracle database increases beyond what you expect. Additionally, you detect an increasing number of idle connections when you examine Oracle connections on the Oracle server.
Extreme XML: Reverse Linking Explained
Benjamin Guralnik introduces the concept of reverse linking, which allows you to populate older documents with a link to a new document in one step.
The Return of XML Hypertext
Kendall Clark reports on the creation of a new mailing list focused on the use of XML for hypertext.
Build Search Applications for the Web Using SQL Server 2000 Full-Text Search
Learn to plan, build, and optimize Web search applications that use Microsoft SQL Server 2000 Full-Text Search.
SQL Server Builtin Functions to Encrypt data
By Shahid Saleem – Some times we need to store the data in encryped form, for example when we use our own application for simple password check, we can write our own algo but will take lot of time or we can use cryptography API for the purpose but the simples way to get the objective that we can use
HOW TO: Troubleshoot SQL Mail with Microsoft Exchange Server
This article discusses certain basic troubleshooting techniques that you can use to diagnose and resolve most SQL Mail problems. Typically, the errors you receive when you start a SQL Mail session or when you send mail from SQL Mail with a Microsoft Exchange Server fall into two categories:
Top 10 SQL Server security blunders, part I
By Jan Stafford – Do you ever lock the front door and leave the back door wide open? That kind of half-safe security practice is all too common among database administrators, said database security expert Aaron C. Newman. In many cases, DBAs get lucky and hackers overlook their oversights. Too often