By Rick Dobson, 10/26/2006
ASP.NET 2.0 lets you use Visual Studio login controls with a SQL Server membership provider to dramatically simplify Web-site membership management.
By Rick Dobson, 03/22/2005
ADO.NET developers often use T-SQL strings to retrieve data for applications, but poorly written strings can lead to errors. By learning a few techniques, you can provide ...
By Rick Dobson, 12/21/2004
Although much excitement surrounded last year's release of SQL Server 2000 Reporting Services, some SQL Server professionals have put off adopting it. If you're ready to give ...
By Rick Dobson, 08/24/2004
Let the SQL Sever 2000 Web Services Toolkit turn you into a Web services wizard as you build this sample telephone-directory application.
By Rick Dobson, 12/23/2003
SQL Server and the .NET framework make a powerful pair for developing enterprise applications. If you're not familiar with .NET's languages and capabilities, this article's sample ...
By Rick Dobson, 12/01/2001
If you're planning to use Access 2002 to build SQL Server 2000 solutions, Microsoft Office XP Developer makes a lot of sense.
By Rick Dobson, 12/01/2001
Here's an example that shows how to export a table as an XML document to a Web site.
By Rick Dobson, 11/20/2001
Use this backstage tour of Access 2002's SQL Server-related features to help determine whether the new Access release is what your organization needs.
By Rick Dobson, 05/23/2001
This column looks at the SQL-DMO syntax required to examine and manipulate SQL Server views and stored procedures.
By Rick Dobson, 04/26/2001
Develop your basic SQL-DMO programming skills by creating tables in Access projects.
By Rick Dobson, 03/21/2001
SQL-DMO lets you program custom solutions containing administrative functions for SQL Server by exposing objects, methods, properties, and events through a COM interface.
By Rick Dobson, 02/22/2001
You can use SQL-DMO to program a custom security interface.
By Rick Dobson, 01/24/2001
Using object permissions and user-defined roles, you can fine-tune secure access to database objects.
By Rick Dobson, 12/20/2000
In this second article in a security series, Rick Dobson shows you how to set up SQL Server account security through Access projects.
By Rick Dobson, 11/27/2000
You can successfully log in to SQL Server from an Access project when you understand login process aspects such as authentication modes and login accounts.
By Rick Dobson, 10/19/2000
Learn how to use FrontPage 2000 to customize SQL Server datasheets for publication to the Web or an intranet.
By Rick Dobson, 09/21/2000
Learn how to publish your SQL Server datasheets with FrontPage 2000.
By Rick Dobson, 06/26/2000
The author demonstrates two approaches to programming custom filters for the SQL Server Pubs database with Access forms.
By Rick Dobson, 06/26/2000
Learn how Access handles dates and times to extract results in the format you need.
By Rick Dobson, 05/19/2000
Learn how to build a custom application with Access projects and SQL Distributed Management Objects (SQL-DMO).