by Joe Celko – Obituaries come with old age — both the ones that I write and my own some day. Several years ago, I promised myself that I would try to meet people whom I admire before either of us died. Dr. Edgar Codd was one of my successes in that regard. By the time you read this column, […]

by MAK Muthusamy Anantha Kumar – Date stamping is a very common requirement in the IT industry for any data extract created. Through the DTS package with ActiveX script, it is very easy to date stamp a file. In this article, I am going to walk you through how to export a table to a date stamped file

By Brian Moran – IBM recently stirred up the database market’s low-end price range with the release of DB2 Universal Database (UDB) Express Edition with self-managing and resource tuning (SMART) technology. Find out some ways that it will affect SQL Server users.

by Shakil Siraj – The article is based on one of many experimental things I do when I am bored. The concept is pretty simple. I wanted my eVB application to talk to MS SQL Sever 7 over the TCP/IP network, just the kind of the thing I do with my desktop database applications. I couldn’t find any SQL

You are invited to attend this one-hour LIVE online Web Seminar right at your computer desktop!Presenter: Morris Lewis – Authenticating users’ identities in ASP.NET applications is more difficult than traditional client-server applications because users rarely have accounts within the estab

On June 10, Wired Magazine ran an article titled “Slammed! An Inside View of the Worm that Crashed the Internet in 15 Seconds” (Wired Magazine, July 2003). This article includes a copy of the Slammer worm source code. Publication of the source code could make it possible for someone to create a more

XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through

Learn how to manage write-back operations in Analysis Services through this example of an employee time-biling application from SQL Server Magazine.

By Preethiviraj Kulasingham – This script returns duplicate indexes on the current database. It uses two user-defined functions that are compatible with SQL Server 2000 (I used SP3). It won’t work in SQL Server 7.0 because of the user-defined functions and a memory table.

(Itzik Ben-Gan) When your query needs to find items with certain relationships, you can use relational division, or you can try these new tricks. (R,$)