This step-by-step article demonstrates how to install a certificate on a computer that is running SQL Server 2000 by using Microsoft Management Console (MMC) and describes how to enable SSL Encryption at the server, or for specific clients.
Other News
sp_smtp_sendmail for SQL Server
sp_smtp_sendmail is a wrapper stored procedure for xp_smtp_sendmail. This makes it easier to be used from environments like SQL Server DTS (SQL Task) which try to retrieve the parameter list of a procedure.
CLR and Language Enhancements in .NET Framework 2.0 – Part 1
(Saravana Kumar) The next release of .NET Framework 2.0 and Visual Studio .NET platform code-named Whidbey brings a series of new enhancements and altogether new advancements to all areas of .NET framework and visual studio. With its enhancements, it also paves the path to next generation Microsoft
Thinking XML: XMLOpen and more XML Hacks
(Uche Ogbuji) This article reflects on several noteworthy presentations at the recent XMLOpen conference in Cambridge, England, a rich technical symposium of XML processing topics. Noteworthy topics included XML metrics, Semantic Web, XML pipelines, Web Proper Names, and data types. The author a
Simple Programs in PL/SQL
he simplest form of program has some declarations followed by an executable section consisting of one or more of the SQL statements with which we are familiar. The major nuance is that the form of the SELECT statement is different from its SQL form. After the SELECT clause, we must have an INTO clau
Employ Strong Encryption in Your Apps with Our CryptoUtility Component
(Michael Stuart and J Sawyer) We’ve all been warned not to store secret information on computers. You know that storing passwords, credit card numbers, or Social Security numbers on your system is risky and can open the door for someone to steal that information. However, you may well have the need
DB2 Everyplace Version 8.2 synchronization horizontal filtering
(John T. Casey) Fewer rows synchronized yields faster synch times and faster table scans on your mobile device. This article explains horizontal filtering, a method for synchronizing a select subset of rows between the server and the DB2® Everyplace mobile device that can significantly enhance p
Linkin’ Park
(Edd Dumbill) As XML camp followers, you’ll know that discussion in the XML community is characterised by a serious of dominant recurring topics, so-called “permathreads.” Many of these topics have their roots in XML pre-history, and none more so than the topic of linking. One of the original tr
Think Of The Possibilities
(Kim Moutsos) Not so many years ago, few people could even pronounce Linux correctly, let alone see a place for it in the world of mission-critical applications. How times have changed. As of the second quarter of this year, the Linux server market had enjoyed eight consecutive quarters of double
Better to Best NDS
(Steven Feuerstein) In recent years, dynamic SQL has become a much more common aspect of PL/SQL programming. Prior to the availability of Native Dynamic SQL (NDS) in Oracle8i, dynamic SQL was available in PL/SQL only through the DBMS_SQL package. Although very robust, DBMS_SQL was very difficult