SQL Server 2005 Books Online (September 2007)

SQL Server 2005 Books Online (September 2007) Download an updated version of the documentation and tutorials for Microsoft SQL Server 2005. See the "Additional Information" section for an update on SQL Server Express Books Online.

Virtual Lab: What's New in SQL Server 2008 for Database Administrators

What's New in SQL Server 2008 for Database Administrators Sponsored by Microsoft. In this lab, you will be introduced to some of the new features for database administrators in SQL Server 2008, including how to work with the new date data type, implement a Declarative Management Framework (DMF) policy, and more.

SQL Server Compact 3.5 Tools: Replicate SQL Server 2005 Data

SQL Server Compact 3.5 is a small footprint, in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. SQL Server Compact 3.5 Server Tools installs DLL's on the IIS server enabling replication of data with SQL Server 2005.

NEW: Office Live Add-in for Microsoft Office

Open and save documents directly from Microsoft Office Word, Office Excel, and Office PowerPoint to Microsoft Office Live Workspace Beta.

The Office Live Add-In will install new menu options allowing you to open and save documents directly from Microsoft Office Word, Office Excel, and Office PowerPoint to Microsoft Office Live Workspace Beta.

The Office Live Add-in will install new menu options in Microsoft Office 2007 and a toolbar in Microsoft Office XP and Microsoft Office 2003. You will be able to open documents located in Office Live Workspace directly from Microsoft Office Word, Office Excel, and Office PowerPoint. You will also be able to save files directly from Microsoft Office Word, Office Excel, and Office PowerPoint to your Microsoft Office Live Workspace.

You can pre-register for Microsoft Office Live Workspace at http://workspace.officelive.com.

SQL Server Compact 3.5 Updates

SQL Server Compact 3.5 is a small footprint in-process database engine for Windows Desktops and Mobile Devices.

SQL Server Compact 3.5 and Synchronization Services for ADO.Net v1.0 for Windows Desktop This download contains the files for SQL Server Compact 3.5 and Synchronization Services for ADO.Net v1.0 for Windows Desktop platform.

SQL Server Compact 3.5 Books Online and Samples This download contains the Books Online and Samples for SQL Server Compact 3.5.

SQL Server Compact 3.5 for Windows Mobile This download contains the CAB files and DLL’s that are used to install SQL Server Compact 3.5 on the Windows Mobile Devices platform.

Microsoft Visual Studio Tools for the Office 2007 (v3.0 Runtime) (x86)

This free download (1.9mb) installs the Visual Studio Tools for the Office system 3.0 Runtime, which is required to run VSTO solutions for the 2007 Microsoft Office system built using Microsoft Visual Studio 2008.

Latest SQL Server News

Download the SQL Server 2008 July CTP

Now Available: SQL Server Compact 3.5 Beta SQL Server Compact 3.5 Beta 2 introduces a host of new features, including LINQ to SQL support, Microsoft Synchronization Services for ADO.NET, plus enhanced support for T-SQL statements

SQL Server 2005 Driver for PHP CTP

FIX: SQL Server 2005 may send error information for the same problem many times when a fatal error occurs

FIX: Some events are not logged correctly when you enable SQL Server event forwarding on a SQL Server Agent of SQL Server 2000 to forward events to SQL Server 2005

New Office 2007 Security Tool

Microsoft is scheduled to release a software tool to better tweak the security settings of Office 2007. The application offers detailed documentation of the security settings in Office 2007, as well as a free Group Publish PostPolicy Object Accelerator that allows administrators to change and set security policies across users through Active Directory. Full story

BETA 2 of Custom RibbonX Reviewer for Access 2007

Click on the image to zoom in...

Download the just released free BETA 2 of my Access 2007 RibbonX Reviewer and Builder Add-In

BETA 2 provides advanced Access 2007 RibbonX review and build features, and is now deployed as an Access 2007 Add-In. You can create new Ribbons, copy/paste controls, and add new controls and delete controls on-the-fly. Extensive reference resources are incorporated into the GUI.

The next update will add the editing of control attributes.

Installation is now via a SetUp.exe file which includes the required DLL's and OCX's. The XML Preview Pane requires IE v 6.x or later. Make sure you read the readme.txt file.

Office 2007 Security Guide

The 2007 Microsoft Office Security Guide (9Nov07) provides prescriptive Group Policy setting and security configuration recommendations to help strengthen the security of computers running the 2007 Microsoft Office release on computers that run Windows Vista or Windows XP in domain–based environments.

Web Seminar Series on Office 2007 Open XML

Microsoft Web Seminars 2007 Microsoft Office System Open XML
Sponsored by Microsoft December 10-20, 10:00 AM PST (USA)

Open XML builds on the original vision of XML, where broad inter-operability allows documents to be archived, restructured, aggregated and re-used dynamically. This Web seminar series will cover Open XML Architecture, programming with the Packaging API, WordprocessingML, SpreadsheetML, DrawingML Fundamentals, and PresentationML.

Free Web Seminar On SQL Server Security

On October 30, 2007 Windows IT Pro Magazine is presenting a free web Seminar on SQL Server Security: How to Secure, Monitor and Audit Your Databases. Register

Most companies remain focused on the security of the perimeter and ignore the database. This seminar will discuss the basics of database security and best practice for securing, monitoring and auditing SQL Server.

Other topics to be covered:

• The three layers of security in most systems today
• Why secure the database layer?
• Challenges securing the database layer
• Best practices for securing, monitoring & auditing SQL Server databases
• Tools to help secure SQL Server

Latest SQL Server 2005 Hotfixes

FIX: Error message when you run a query that references a column of the XML data type in SQL Server 2005: "The XML data type is damaged".

FIX: Error message when you try to delete some stored procedures concurrently in SQL Server 2005: "Temp table deferred drop doesn't scale for certain workloads".

Latest SQL Server 2005 Resources

• Microsoft SQL Server 2005 Service Pack 2 SQL Server 2005 SP2 includes significant enhancements to maintenance plans, including an enhancement that lets users specify the cleanup interval in hours. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP2.
  
  
• How To: Determine the version of SQL Server 2005 Integration Services
  
  
• How To: Use Excel Services as a data source in Microsoft Office PerformancePoint Server 2007 Monitoring and Analytics

Latest Office 2007 Resources

• 2007 Office System Sample: Setting Up a Development Environment This code sample accompanies the MSDN technical article Setting Up a Development Environment for the 2007 Microsoft Office System.
  
  
• 2007 Office Sample: Using the Office Open XML Formats to Support Electronic Health Records Portability and Health Industry Standards
  
  
• 2007 Office Document: Open XML Markup Explained

Automatically Schedule Access Reports For Printing

If you say need to print an Access report by 10:00 every Friday morning, you don’t have to do it manually. Follow this great tip from Tech Republic's Mary Ann Richardson.

Add Addtional Files to Access 2007 Deployment Packages

This How To shows you how to add an add-in to an Access 2007 deployment package using the Package Solution Wizard, containing your application, the Microsoft Office Access 2007 Runtime, and additional files.

Additional links:

• Deploying Access 2007 Runtime-Based Solutions

• Access Developer Portal

• Introducing the Access 2007 Developer Extensions and Runtime

• Microsoft Office Developer Center

Office Business Applications Developer Portal

This Microsoft Office 2007 Portal provides a comprehensive set of servers, clients, and tools to make it easier for enterprises, software vendors, and developers to build and deploy a new class of business applications called Office Business Applications (OBAs).

Latest SQL Server 2005 Fixes

. FIX: An access violation may occur intermittently when you run an Integration Services package that contains a Data Flow task in SQL Server 2005

. FIX: On a computer that is running SQL Server 2005 and that has multiple processors, you may receive incorrect results when you run a query that contains an inner join

NEW: Access 2003 to Access 2007 Interactive Command Reference Guide

Download a visual interactive reference guide to help you find Access 2003 commands in the new Access 2007 Ribbonbars.

You can also download the Access Ribbon mapping workbook, an Excel file that lists the commands on each tab of the Access 2007 Ribbon and the menu/toolbar location in previous versions of Access. Instructions on the first tab of the workbook provide tips for customizing, finding, and printing data.