ProgrammingMSAccess.com

Learn about Developers Group
Join Developers Group
Order SPAM Blocker
Free Stuff
Guest Book
.NET Resources
SQL Server Resources
Favorites
Technical Support
Books & DVDs by Webmaster
Articles, tutorials, & more
FAQs
Product Reviews
Samples
Prior Newsletters
Contact Us
Home
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

SQL Server Resources

ProgrammingMSAccess.com's webmaster, Rick Dobson, has been active with SQL Server for almost as long as he has worked with Microsoft Access, but his attention to SQL Server grew substantially starting with SQL Server 7.  The SQL Server resources at this site draw heavily on Rick's SQL Server experience.  The links below point to resources that address SQL Server from the perspective of an Access developer, a T-SQL developer, and a VB.NET developer.

Rick is the author of three books and one DVD with SQL Server in the title.  His third book on SQL Server addresses SQL Server Express, Visual Basic Express, and Visual Web Developer Express as well as the interaction between the three.  His articles appeared in such publications as SQL Server Magazine, SQL Server Professional, and SQL Server Solutions.  Some of the content below includes excerpts from or links to his published content, but other material below extends previously published content.

Rick's practice promotes an annual seminar presentation series that trains attendees in multiple Microsoft technologies relating to database development and VB programming, including VBA and VBScript through to VB.NET.  SQL Server has been a major topic in the last five annual seminar presentation series.  Please sign our Guest Book for early notification of future seminars.  We plan to grow this section during the coming year.

Annual Seminar Presentations Our current seminar presentation series focuses on SQL Server Express, Visual Basic Express, and Visual Web Developer Express.
Book Resources Resources for "Beginning SQL Server 2005 Express Database Applications with Visual Basic Express and Visual Web Developer Express".
SQL Server code samples A collection of code samples that will continue to grow.
Slide Deck Presentation Introductory presentation on SQL Server Express that covers installation as well as simple T-SQL code samples that showcase innovations introduced with SQL Server Express.  Also includes coverage of a query tool optimized for SQL Server Express that also works with MSDE.
Slide Deck Presentation Introductory presentation on creating Windows and Web solutions with ADO.NET and SQL Server Express.
Slide Deck Presentation Intermediate-level presentation on creating stored procedures and user-defined functions with a special emphasis on programming parameters and return status values.  Programming samples are in T-SQL and VB.NET/ADO.NET.
Selected articles by webmaster for SQL Server Magazine This particular subset of articles features content on Access/Office interoperability with SQL Server.  If you ever wanted to control SQL Server from Access or with VBA, one of these articles may have the content you need to solve a problem.
Magazine Article This SQL Server Magazine article demonstrates how to use VB.NET, ASP.NET and SQL Server to build a membership application.
SQL Server FAQ This FAQ highlights content about Access/SQL Server interoperability.  It represents our first SQL Server resources, and it remains one of the most popular reasons for visiting the site.
DVD Resources Resources for "Beginner's SQL Server 2000 T-SQL Programming on DVD".
DVD Resources Resources for "Programming Visual Basic .NET and ADO.NET with SQL Server and Access".
DVD Review DDG member review of "Programming Visual Basic .NET and ADO.NET with SQL Server and Access"
Book Resources Resources for "Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET".
Book Resources Resources for "Professional SQL Server Development with Access 2000", including download URL for sample code from the book.