by Michael Balloni – Relational databases, like Microsoft's SQL Server, use locks to prevent multiple users from making conflicting modifications to a set of data. When a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the
Community
Analyze Your SQL Server Databases Using Coefficient
by Brad M. McGehee – Just as you can’t ever be “too thin or too rich,” there is also no such thing as a database that is "too fast". In fact, if you have been a DBA for long, the biggest grip you probably hear from most users is that the database is too slow. I doubt if any DBA […]
XHTML Black Book
By Steven Holzner XHTML is a complete rewrite of HTML 4 in XML, the language you can use to structure data for the Web. Written by a master programmer, this in-depth book covers XHTML essentials including migrating from HTML 4 to XHTML, tags, using the W3C validation service, the skeleton, writ
Protecting the Middle
This XML-based approach lets you change stored-procedure parameters without affecting the middle tier, by Xenos J. Sroka.
Top 10 Interview Questions When Hiring XML Developers
by Brian Buehling – As XML becomes more pervasive, hiring managers won't have to look very hard to find candidates claiming to have experience working on projects involving XML. Despite this trend, it is still not an easy task to find a truly skilled XML developer. This fact, combined with the i
SQL Server Full Text Search Optimization
by Tony Bain – Full text indexing is a great feature that solves a long running database problem, the searching of textual data columns for specific words and phrases in SQL Server databases. However, as the full-text search engine is a separate component of SQL Server (it uses the Microsoft Search
Stored Procedures: Returning Data
This article discusses three common ways to return data from stored procedures: OUTPUTing variables, temp tables and the RETURN statement.
XML Black Book 2nd Edition
By Natanya Pitts The eagerly awaited second edition of the XML Black Book focuses on real-world implementations that include XML. It also covers the latest versions of the XML specification and related specifications such as XSL, CSS, XLink, XPath, and more. Written to improve your productivity
JXUnit: Building Suites of Test Data with XML
Data-Centric Testing: Advantage of Separating Test Data from Test Code.Test data plays a central role in testing. From the lowest level (method tests) to the highest (acceptance tests), a test involves input data, expected output data, and a comparison between the expected and actual output data
XML Hype Down But Not Out In New York
by Edd Dumbill – Signs of reality were setting in this week at XML DevCon 2001 in New York City. As vendors and professionals were feeling the pinch of the economic conditions, the cloud of dust raised by recent overmarketing was starting to settle.