http://www.sqlmag.com/authors/author/author/5681092/rss/5681092en-USFri, 25 May 2012 08:20:01 GMTFri, 25 May 2012 08:20:01 GMThttp://www.sqlmag.com/article/permissions/making-the-most-of-login-controls-with-asp-net
By Rick Dobson
ASP.NET 2.0 lets you use Visual Studio login controls with a SQL Server membership provider to dramatically simplify Web-site membership management.]]>Rick DobsonThu, 26 Oct 2006 00:00:00 GMThttp://www.sqlmag.com/article/permissions/making-the-most-of-login-controls-with-asp-nethttp://www.sqlmag.com/article/tsql3/create-your-own-code-library
By Rick Dobson
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 developers with a code library to use for many common data-access tasks.]]>Rick DobsonTue, 22 Mar 2005 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/create-your-own-code-libraryhttp://www.sqlmag.com/article/configuration/reporting-services-101
By Rick Dobson
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 Reporting Services a try, here’s a tutorial that will get you started.]]>Rick DobsonTue, 21 Dec 2004 00:00:00 GMThttp://www.sqlmag.com/article/configuration/reporting-services-101http://www.sqlmag.com/article/tsql3/web-services-made-easy
By Rick Dobson
Let the SQL Sever 2000 Web Services Toolkit turn you into a Web services wizard as you build this sample telephone-directory application.]]>Rick DobsonTue, 24 Aug 2004 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/web-services-made-easyhttp://www.sqlmag.com/article/tsql3/sql-server-and-net-a-dynamic-duo
By Rick Dobson
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 Web application can quickly bring you up to speed.]]>Rick DobsonTue, 23 Dec 2003 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/sql-server-and-net-a-dynamic-duohttp://www.sqlmag.com/article/access/special-mod-xp-sql-server-features
By Rick Dobson
If you’re planning to use Access 2002 to build SQL Server 2000 solutions, Microsoft Office XP Developer makes a lot of sense.]]>Rick DobsonSat, 01 Dec 2001 00:00:00 GMThttp://www.sqlmag.com/article/access/special-mod-xp-sql-server-featureshttp://www.sqlmag.com/article/xml/exporting-a-table-as-an-xml-document-to-a-web-site
By Rick Dobson
Here’s an example that shows how to export a table as an XML document to a Web site.]]>Rick DobsonSat, 01 Dec 2001 00:00:00 GMThttp://www.sqlmag.com/article/xml/exporting-a-table-as-an-xml-document-to-a-web-sitehttp://www.sqlmag.com/article/user-defined-function-udf/what-s-new-in-access-2002
By Rick Dobson
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.]]>Rick DobsonTue, 20 Nov 2001 00:00:00 GMThttp://www.sqlmag.com/article/user-defined-function-udf/what-s-new-in-access-2002http://www.sqlmag.com/article/activex/views-and-stored-procedures
By Rick Dobson
This column looks at the SQL-DMO syntax required to examine and manipulate SQL Server views and stored procedures.]]>Rick DobsonWed, 23 May 2001 00:00:00 GMThttp://www.sqlmag.com/article/activex/views-and-stored-procedureshttp://www.sqlmag.com/article/sql-server-2000/creating-tables-with-sql-dmo
By Rick Dobson
Develop your basic SQL-DMO programming skills by creating tables in Access projects.]]>Rick DobsonThu, 26 Apr 2001 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-2000/creating-tables-with-sql-dmohttp://www.sqlmag.com/article/database-development/sql-dmo-learning-the-basics
By Rick Dobson
SQL-DMO lets you program custom solutions containing administrative functions for SQL Server by exposing objects, methods, properties, and events through a COM interface.]]>Rick DobsonWed, 21 Mar 2001 00:00:00 GMThttp://www.sqlmag.com/article/database-development/sql-dmo-learning-the-basicshttp://www.sqlmag.com/article/stored-procedures/programming-sql-server-security
By Rick Dobson
You can use SQL-DMO to program a custom security interface.]]>Rick DobsonThu, 22 Feb 2001 00:00:00 GMThttp://www.sqlmag.com/article/stored-procedures/programming-sql-server-securityhttp://www.sqlmag.com/article/permissions/homegrown-security-solutions
By Rick Dobson
Using object permissions and user-defined roles, you can fine-tune secure access to database objects.]]>Rick DobsonWed, 24 Jan 2001 00:00:00 GMThttp://www.sqlmag.com/article/permissions/homegrown-security-solutionshttp://www.sqlmag.com/article/permissions/securing-sql-server-tables
By Rick Dobson
In this second article in a security series, Rick Dobson shows you how to set up SQL Server account security through Access projects.]]>Rick DobsonWed, 20 Dec 2000 00:00:00 GMThttp://www.sqlmag.com/article/permissions/securing-sql-server-tableshttp://www.sqlmag.com/article/permissions/access-granted
By Rick Dobson
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.]]>Rick DobsonMon, 27 Nov 2000 00:00:00 GMThttp://www.sqlmag.com/article/permissions/access-grantedhttp://www.sqlmag.com/article/tsql3/custom-datasheets
By Rick Dobson
Learn how to use FrontPage 2000 to customize SQL Server datasheets for publication to the Web or an intranet.]]>Rick DobsonThu, 19 Oct 2000 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/custom-datasheetshttp://www.sqlmag.com/article/sql-server/dynamic-datasheets
By Rick Dobson
Learn how to publish your SQL Server datasheets with FrontPage 2000.]]>Rick DobsonThu, 21 Sep 2000 00:00:00 GMThttp://www.sqlmag.com/article/sql-server/dynamic-datasheetshttp://www.sqlmag.com/article/quering/filtering-data-with-access-forms
By Rick Dobson
The author demonstrates two approaches to programming custom filters for the SQL Server Pubs database with Access forms. ]]>Rick DobsonMon, 26 Jun 2000 17:24:31 GMThttp://www.sqlmag.com/article/quering/filtering-data-with-access-formshttp://www.sqlmag.com/article/tsql3/datetime-values-in-access-projects
By Rick Dobson
Learn how Access handles dates and times to extract results in the format you need.]]>Rick DobsonMon, 26 Jun 2000 08:54:01 GMThttp://www.sqlmag.com/article/tsql3/datetime-values-in-access-projectshttp://www.sqlmag.com/article/sql-server-2000/programming-sql-dmo-from-access
By Rick Dobson
Learn how to build a custom application with Access projects and SQL Distributed Management Objects (SQL-DMO).]]>Rick DobsonFri, 19 May 2000 16:26:54 GMThttp://www.sqlmag.com/article/sql-server-2000/programming-sql-dmo-from-access