(Jonathan Yarden) When the industry first adopted the Simple Mail Transfer Protocol (SMTP) as the ubiquitous e-mail transmission standard, we didn’t have the Internet security problems that now plague e-mail. Although e-mail chain letters and some minor junk e-mailing surfaced occasionally, the firs
Other News
Convert Seconds to Hours, Minutes, and Seconds
(Pablo Rovedo) This code converts seconds to hours, minutes, and seconds.
Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube
(William Pearson) In this article, we will examine the design and creation, within Analysis services, of relative time periods, a popular feature that can be generated automatically or manually for reporting in the Cognos PowerPlay application, within its cube design component, Cognos PowerPlay Tran
The ExecuteSQL Task
(Allan Mitchell) In this article we are going to take you through the ExecuteSQL task in SQL Server Integration Services for SQL Server 2005. We will be covering all the essentials that you will need to know to effectively use this task and make it as flexible as possible.
FIX: 17883 errors may be written to the SQL Server error log when you run a query that generates many floating point exception errors in SQL Server 2000
In Microsoft SQL Server 2000, when you run a query that generates many floating point exception errors, you may experience slow performance and query timeouts when you run other queries. This problem typically occurs when more than 1,000 floating point exceptions are generated.
Configure It Out with the Configuration Management Application Block
(Keenan A. Newton) Most applications require some sort of configuration data, whether it is a file resource, a database connection string, user settings, a Web service URL, or simply organizational branding requirements. To address these issues prior to .NET, developers had to utilize some type of A
Migrating Excel VBA Solutions to Visual Studio 2005 Tools for Office
(Dale Oberg) Convert solutions from Microsoft Visual Basic for Applications (VBA) to Microsoft Visual Studio 2005 Tools for Office and Microsoft Visual Basic 2005. Migrate the Trey Research IIS Log Analyzer solution from VBA to Visual Studio 2005 Tools for Office to highlight issues you may encounte
Move Over MySQL, SQLite is here!!
(Pradeep Kishore Gowda) The author discusses some of the features that have led to the popularity of SQLite and explains with examples how the PHP+SQLite combination works.
Send Mails from within a .NET 2.0 Application
(Thiru Thangarathinam) Most enterprise applications today need to send mail. This means the platform should provide the necessary support for applications to send these mails. In the case of .NET applications, .NET provides excellent support for sending e-mails through a set of intuitive classes.
Understanding DB2 Universal Database character conversion
(Sam Poon, Manu Sud and Raul Chong) Learn how DB2 Universal Database (DB2 UDB) handles character conversion. This article starts with a discussion of basic character code concepts including code pages, code points, and encoding schemes, followed by a more detailed explanation about how code page