Access Hosting Blog Helps You Get Your Access Database on the Web

AccessHosting.com runs a blog featuring useful posts on getting Microsoft Access Web Databases up and running: Access Hosting Academy.

Free eBooks from Microsoft Press

• Free ebook: Moving to Microsoft Visual Studio 2010 (10 chapters by by Patrice Pelland, Pascal Paré, and Ken Haines)
• Free ebook: Introducing Microsoft SQL Server 2008 R2 (10 chapters by Ross Mistry and Stacia Misner)
• Free ebook: Programming Windows Phone 7 Series (DRAFT Preview) (6 chapters by Charles Petzold)
• Free ebook: Petzold’s Programming Windows Phone 7 (Special Excerpt 2) (newer than the ebook above; 11 chapters by Charles Petzold)
• Free ebook: Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft(8 chapters by Katherine Murray)
• Free ebook: Understanding Microsoft Virtualization Solutions (Second Edition) (6 chapters by Mitch Tulloch)
• Free ebook: First Look Microsoft Office 2010 (14 chapters by Katherine Murray)
• Free ebook: Windows 7 troubleshooting tips (short ebook by Mitch Tulloch)
• Free ebook: Introducing Windows Server 2008 R2 (9 chapters by Charlie Russel and Craig Zacker)
• Free ebook: Deploying Windows 7, Essential Guidance (10 chapters from the Windows 7 Resource Kit and 6 TechNet articles)

Microsoft SQL Server 2008 Books Online (May 2009)

Download the documentation and tutorials for Microsoft SQL Server 2008.

SQL Server 2008 Developer Training Kit

The SQL Server 2008 Developer Training Kit from Microsoft will help you understand how to build web applications using the rich data types, programming models and new development paradigms in SQL Server 2008.

SQL Server 2008 Updates April 2009

• SQL Server 2008 Service Pack 1
• Microsoft SQL Server 2008 Feature Pack
• Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies

SQL Server Express 2008 Now Available for Download

Version 10.00.1600.22 of SQL Server Express 2008 was released today.

Downloads:

• SQL Server Express 2008
• SQL Server Express 2008 with Tools

ADP Developers: Stick With SQL Server 2005

The MS Access Team Blog has today posted this advice:

• Access 2007 ADP’s will run against SQL Server 2008 but do not support designing server objects (tables, views, stored procedures, functions and relationships).
  
  
• SQL Server 2008 shipped after Office 2007 SP1 and after MS had locked down all the fixes for Office 2007 SP2 (coming out in a few months).
  
  
• If you rely on the design features of ADP’s it is recommended that you stick with SQL Server 2005.
  
  
• If you do make the move to SQL Server 2008 use the SQL Server Management Studio to design your server objects.

Latest SQL Server Updates (December 2008)

• Microsoft SQL Server 2005 Service Pack 3
• Feature Pack for Microsoft SQL Server 2005 - December 2008
  A collection of standalone install packages that provide additional value for SQL Server 2005.
• SQL Server 2005 Books Online
  
• Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
  This package includes two add-ins for Microsoft Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2007 (Data Mining Templates).
• Microsoft SQL Server 2005 Express Edition Service Pack 3
• Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3
• Microsoft SQL Server Management Studio Express Service Pack 3
  Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.

Microsoft SQL Server 2008 Feature Pack: October 2008

Download the Microsoft SQL Server 2008 Feature Pack, a collection of stand-alone install packages that provide additional value for SQL Server 2008:

File Name: instructions_enu.htm
Version: 10.00.1600.60
Date Published: 10/17/2008
Language: English
Download Size: 29 KB - 37.9 MB

Microsoft SQL Server 2008 Reporting Services: Report Builder 2.0

Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 Reporting Services.

This download provides a stand-alone installer for Report Builder 2.0:

File Name: ReportBuilder.msi
Version: 10.00.1600.60
Date Published: 10/17/2008
Language: English
Download Size: 18.7 MB

Free SQL Server 2008 eBook

Download for free the eBook version of the new Microsoft book: Introducing Microsoft SQL Server 2008.

Security Update for SQL Server 2000 Service Pack 4 and MS Access MSDE 2000 (KB948111)

A security issue has been identified in the SQL Server 2000 Service Pack 4 and the MSDE 2000 sql server engine used by MS Access that could allow an attacker to compromise your system and gain control over it. Download the hot fix.

Quick Details:
Version: 8.00.2273
Date Published: 9/26/2008
Download Size: 16.5 MB - 39.4 MB Download size depends on selected download components.

Latest SQL Server Fixes

FIX: SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall security update KB948108 or security update KB948109

FIX: No rows are returned when you use the sp_replqueuemonitor stored procedure to list the queued messages for a queue-updating subscription in SQL Server 2005

New v4.0 of SQL Server Migration Assistant 2005 for MS Access

Microsoft SQL Server Migration Assistant (SSMA) 2005 for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2005. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server. SSMA for Access supports Access 97 - Access 2007 databases.

Latest SQL Server 2008 Downloads

SQL Server 2008 Microsoft SQL Server 2008 Books Online Release Notes
SQL Server 2008 Express with Advanced Services - English
SQL Server 2008 Express
SQL Server 2008 Upgrade Advisor
SQL Server 2008 Books Online
SQL Server 2008 Enterprise Evaluation: Trial Experience for Developers
SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals

Configuring the Windows Firewall to Allow SQL Server Access

Configuring the Windows Firewall to Allow SQL Server Access To access an instance of SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server to allow access. This MSDN article discusses how to configure the Windows firewall, but the basic principles apply to other firewall programs.

New SQL Server 2008 Articles

New articles from Techrepublic.com on SQL Server 2008:

• More New SQL Server 2008 Features
• How do I use the Microsoft SQL Server Best Practices Analyzer?
• Windows Server 2008 drops RDP console option
• Backup compression in SQL Server 2008

Running Stored Procedures in SQL Server from Access

Randall Rode has posted an article on the process of running parameterized stored procedures in a SQL Server database from an Access client application.

Microsoft Releases SQL Server 2008

Microsoft today announced the release to manufacturing of Microsoft SQL Server 2008. Press release

More SQL Server Fixes

FIX: SQL Server 2005 Express Edition cannot pass the Windows logo certification when you install an ISV application on a Windows Vista-based computer or on a Windows Server 2008-based computer.

FIX: When you update more than one row in a table that is joined to another table in SQL Server 2005, some rows are not added.