Security in the CLR World Inside SQL Server   22 May 2006 19:10 GMT
Is running .NET Framework code within SQL Server 2005 exciting or a threat? Which is it? This article explores the security issues of SQLCLR code so that both developers and DBAs can make informed decisions about its use.
Source: DevX

Sybase DataWindow .NET 2.0—Easy, Powerful, and Flexible   19 May 2006 14:44 GMT
Sybase's DataWindow .NET control simplifies and unifies the process of building both Windows and Web reporting and data-entry applications—without compromising your control of either the data or the visual style.
Source: DevX

Rebuilding Vogue.com.au   19 May 2006 04:00 GMT
An old content site. Multiple systems. Table-based design. No content management facilities. And a 35-day project timeframe. Faced with these challenges, David and his team redevelop the Vogue Australia web site from the ground up in just over one month. Here, he reveals how they did it, explaining the finer details of the decisions that were made, and why.

Source: SitePoint

Raise Printing to a Fine Art in Windows Forms   18 May 2006 23:01 GMT
Learn how to format, preview, and print output the way you want it to look using the capabilities of the .NET System.Drawing.Printing namespace and the PrintDocument class.
Source: DevX

Guidelines for Test-Driven Development   17 May 2006 18:25 GMT
Find out how to incorporate Visual Studio Team System into Test-Driven development practices emphasized in Agile development methodologies.
Source: MSDN

Podtastic! Professional Podcasting for the Rest of Us   17 May 2006 07:55 GMT
If you've been sitting on the sidelines of the podcasting explosion, now's your time to step up to the mic! In this hands-on tute, Jon explains the basics of what you need to know about podcasting before walking you through the process of creating, recording, distributing, and promoting your own professional show.
Source: SitePoint

User Tips: Receiving an Email When Database Data is Changed   17 May 2006 00:00 GMT

For low-volume databases, those that are predominantly read and not written to, or database tables that are designed to not be updated or only updated under rare circumstances, a DBA or developer may be interested in being notified whenever the data in a particular table is modified. Or you may have certain records in a table that are assigned to a particular user and, upon that record being updated, that user should be notified of the change. While this sort of logic can be implemented at the code level, Microsoft SQL Server has all of the technologies needed to achieve this aim built directly into it. Triggers can be used to perform some action when data is inserted, updated, or deleted from a table, and Microsoft SQL Server's xp_sendmail extended stored procedure can be invoked to send an email to one or more recipients. Combining triggers with xp_sendmail provides a means for alerting specified users via email when the data in a particular table is modified.

This tip demonstrates how to create such a notification system. This code presented here is a simplified version from an action item application that emails the appropriate people when an item is updated. We'll step through creating the table, some dummy data, and the trigger one step at a time. You can download the entire database script at the end of this article. Read on to learn more!

See all User Tips...
Read More >

Source: 4GuysFromRolla

RFID in Retail: An Introduction   12 May 2006 23:12 GMT
This white paper provides a general introduction to Radio Frequency Identification (RFID) technology, and discusses the benefits and challenges of this technology for organizations that are involved in the production, movement, or sale of retail goods.
Source: MSDN

Gaining Supply Chain Efficiency through Global Data Synchronization   12 May 2006 23:11 GMT
This article examines how the trading of item data and the ordering of trade items in the supply chain can be made more efficient by integrating processes and systems, and by leveraging standards.
Source: MSDN

Building Rich Interactive Kiosks   12 May 2006 23:08 GMT
This paper will provide an overview of the new technologies in Windows Vista that will enable developers to create a new generation of retail kiosks, and it will relate these technologies to benefits a developer will see for creating rich kiosk solutions.
Source: MSDN