(Phillip Piper) All projects suffer creeping featurism, things that start simple and elegant end up as the “before” image in a weight-loss ad. This control has grown considerably since it was first written. For those in a hurry, this control has the following features: –It can easily display a l
Other News
Generating the cooltip for ADF applications (using JHeadstart)
(Lucas Jellema) Our end users – inspired by the Interaction Designers – have requested a superduper tooltip for their fields. Not the shy title popup label that browsers show for elements with the title attribute set (limited in number of characters and layout options), no, a real sturdy tooltip. It
Creating and Managing RDF Vocabularies
(Brian Sletten) Do you like to relax in the morning over a cup of coffee and the “zoopepe”? Do you like to put “kapatz” on your “hogatz”? These are obviously meaningless terms to most people, but it is easy to imagine a young child using them in place of “newspaper,” “ketchup,” and “hotdog” because
More In-Depth About Nulls And DBNull
(Brian Mains) I see a lot on forums the question being asked about DBNull, and why it may cause problems when you read values from a reader, or try to assign it to a value type. This article delves into DBNull more explicitly and shows the differences between various objects.
Use an XForms document as a custom XML editor
(Doug Tidwell) In a recent article we looked at XSLT 2.0 functions that allowed us to generate an attractive HTML table that represented the results of an XML tournament (a bracket). What we didn’t address in that article is how to fill in the winners and losers for that XML tournament. In this arti
Embrace CSS with Friendly Control Adapters for ASP.NET 2.0
(Tony Patton) Even though Microsoft is not always the biggest advocate of standards such as CSS, there is robust CSS support in the latest incarnation of its Visual Studio environment, and CSS is easy to apply in ASP.NET applications — but it could be so much easier. The goal of ASP.NET 2.0 CSS Frie
Analysis Services
(Buck Woody) In SQL Server 2000, Microsoft offered a powerful Business Intelligence tool they called Analysis Service. This feature was greatly enhanced in SQL Server 2005. Both versions, starting with the Standard Edition, contain this software as part of the standard licensing — there isn’t anythi
SqlCredit – Part 10: MAC Performance and Updating SqlCredit
(Rob Garrison) There are three main sections here: MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.
Performance is slow when you run a query in SQL Server 2005 that updates a table on a linked server and then joins the table to a table on the local server
Consider the following scenario: • You have a query that updates a table on a linked server and then joins the table to a table on the local server. • The local server is running Microsoft SQL Server 2005. • On the local server, you run the query in SQL Server 2005.
Importing Text-based data: Workbench
(Robyn Page and Phil Factor) It is hard to estimate the enormous number of unnecessry and unmaintainable SSIS and DTS files that are written merely to import data from text into SQL Server. For performance, and for the sanity of the DBA, it is usually better to allow SQL Server to import text and to