by Shawn Kresal – Many of us are already familiar with connection pooling and understand to some degree its importance in web and SQL Server programming. We’ve all heard the adage that “connections are expensive” and “pooling is good”. This article will examine the topic in more detail, bringing to

Review this FAQ to find answers to some common questions about how SQL Server 2000 scales to meet the needs of very large database (VLDB) systems.

Review by Vyas Kondreddi – This is the most comprehensive book for anyone interested in knowing how SQL Server works internally. You might ask, “Who is interested in the internals of SQL Server?”. My answer would be, “Any DBA or technical architect, who undertakes serious SQL Server implementations.

While IT hiring may slow slightly in the third quarter, according to a survey conducted by the recruiter Robert Half Technology, demand for professionals with SQL Server skills remains strong.(R)

Greg Larsen discusses using the CHARINDEX and PATINDEX functions to search text columns and character strings. Included are how each of these functions operate, and an explaination of the differences between them. Also provided are examples on how you might use these functions to solve a number of d

By Robert Westervelt – Teradata Warehouse executive Vickie Farrell gives her two cents on the value of the new data warehouse, and the changing role that DBAs play in it.

Several dozen readers responded to Brian Moran’s call for feedback about the primary causes of planned and unplanned SQL Server outages in their environments. Here are the tallied results.

by Andy Clark – The Red Gate Compare Bundle contains three tools that can help you maintain systems—SQL Compare, SQL Data Compare, and COMPare. Each tool does a simple job and does it well.

by Louis Duc Nguyen – Learn how to create a web page to extract data from a SQL Server database, with pivot/transpose.

This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition. The article then concentrates on XML support, covering XML data ret