(Brett D. McLaughlin, Sr.) In a perfect world, you’d create every Web site you were ever assigned to maintain, improve, and redesign. Unfortunately, in the real world, you’re often forced to take on a site someone else designed or constructed.

(Matt Woodward) I’ve been working quite a bit with XML in SQL Server lately (I’ll try to do a post on some xquery stuff at some point), and I had a need to check XML data that I’m pulling off disk against a table in SQL Server to see if the data I pulled off disk is a duplicate with […]

(Russell Butek) We all agree that defining Web Services Description Language (WSDL) faults is good (if you disagree, then you’re probably not reading this article). There are a number of ways to define WSDL faults, but only a limited subset provides for reuse. This article presents you with a templa

(Dan Wahlin) .NET 3.5 has a lot of great new features that can significantly enhance developer productivity. I’ve been spending some time lately working on a little sample application that demonstrates how an N-Layer ASP.NET 3.5 application can be built using LINQ, lambdas and LINQ with stored proc

(Stephen Forte) Continuing our discussion from yesterday on SQL Server 2008 XML Enhancements, let’s take a look at the XSD enhancement of Union and List types. In SQL Server 2005 you could define a simple type of xsd:list with an enumeration to require items in a list for any element that inherits t

(Michelle Gutzait) As a database administrator, I tend to look closely at performance issues and how to make sure the use of XML does not affect SQL Server performance. In this tip, I’ll take you through an example using two tables, one inserted and queried with XML and the other with the VARCHAR (M

(Leonard Anghel) Suppose you need to serialize a DOM tree, with the result being an XML document. Xerces-J allows you to specify a maximum line length and an indent value

(Stephen Forte) The SQL Server 2008 February CTP is now installed. I did it on my daily machine to force me to use it in a more realistic environment. It installed a-ok with my default SQL 2005 instance. As you can see below you can use the SQL 2008 IDE to manage and work with both SQL Server instan

(Paul Done) For the implementation of Web Services in the enterprise environment, I’ve seen many different technologies used. Recently, in my spare moments, I’ve reflected on this and have come to the conclusion that all these technologies tend to fit one of three models (or hybrids of these models)

(Vijaya Kadiyala) XML was developed by the World Wide Web Consortium (W3C). All companies using XML and related technologies try to follow the XML standard that is in place.