(Zak Ruvalcaba) If you’re building an Intranet application within your organization, for instance, you might choose to use Windows authentication. Configuring Windows authentication within IIS is fairly straight forward and involves only two steps.

Since its release in early 2002, the Microsoft SQL Server 2000 Driver for JDBC has been very well received by the Java developer community and Service Pack 3 addresses issues discovered since the release of Service Pack 2. Enhancements added to this driver since its original release include: support

(poonam) The ability to display images in a web application is a common requirement. There are two ways you can do this, either store images in a SQL database using the Binary Large Object (commonly know as BLOB) data type, or store the image on the disk. There are pro’s and cons to each of these me

(Brad M. McGehee) Every once in a while, a truly unique SQL Server product pops up, one that you have never seen before, and at the same time, provides a clever solution to a common problem. For example, let’s say that you are a developer and you need to include a database (both schema and data)

(Steve Jones) I’ve only met a couple people in my career who have been using SQL Server as long as I have. I was thinking about the past recently and started to reminisce about the places I’ve been with SQL Server. Actually I was watching Maryland win the 2002 NCAA men’s basketball title and started

(Muthusamy Anantha Kumar) SQL Server developers and database architects often find they have a need to sequence query results or generate a cumulative sum for a group of rows in a table. SQL Server does not have a Pseudo row-id similar to other RDBMS.

(Ken Henderson) In this month’s column, I’ll discuss a few of the issues facing developers who wish to write Transact-SQL code that is portable across languages. The introduction of Unicode data types, collations, and various other internationalization and localization features in SQL Server 7.0

(Kalen Delaney) Last month, in “Inside Search Arguments” (InstantDoc ID 42349), I discussed specific types of search arguments—which I call SARGs—that are most beneficial to the query optimizer when it’s determining the best execution plan for a query. In most of the examples I used, if the query di

(Les Pinter) Learn how to build a data access layer to communicate with either DBFs or SQL Server. Even cooler, you’ll do it with no code to change when you move from DBFs to SQL tables, and an upsizing wizard to migrate the data for you. Find out how to use a data access layer in FoxPro, which give

(Klaus Aschenbrenner) Rich client. Fat client. Thin client. Web client. Add another to the list: the so-called smart client. But what is a smart client? A smart client: –Uses local CPU power –Communicates with Web services –Supports online/offline scenarios –Uses the device hardware