Monday, July 30, 2007

Free Office Tutorials

The Office Lecture site offers a range of free MS Office tutorials. There is also an affiliate site Free Programming Books with a range of free downloadable eBooks. Both are ad-driven portals, but definitely worth browsing.
SQL Server Administration: New Articles

New articles on SQL Server Administration from TechRepublic.com:

Wednesday, July 25, 2007

Access 2007 Quick Tips #1: Add a Total Row to an Access 2007 Table

Before Access 2007, you could calculate totals on your data in an Access query, report, or form. Now Access 2007 lets you add a Total row field to your tables. Article from Mary Ann Richardson ot TechRepublic.com.

Monday, July 23, 2007

ITSearchEngine - Focused Search For IT Products



I have just discovered this cool new IT-focused portal: ITSearchEngine

Saturday, July 21, 2007

Access 2007 Runtime Re-Issued

The Access 2007 Runtime is similar to previous runtimes in that all design-related UI is either removed or disabled. You do NOT need to buy any special SKU in order to redistribute the Access 2007 Runtime. You can freely redistribute it or point users to this download.

You can also download the Access 2007 Developer Extensions package.


Tuesday, July 17, 2007

Latest SQL Server Hotfixes

FIX: The Cluster Discrimination tab is empty when you browse a clustering
model of SQL Server 2005 Analysis Services in SQL Server BIDS

FIX: You cannot cancel an MDX query that runs for a long time in SQL Server
2005 Analysis Services

FIX: A server may start slowly if you have SQL Server 2005 Analysis Services
installed and if many objects are stored on the server

Monday, July 16, 2007

Zoho: David's Office Suite



An interesting review of the ZOHO On-Line Office-Style Applications Suite.
Use Pre-Built Style Features to Format Excel 2007

This article from TechRepublic.com shows you how to use the the Styles section of the Home tab in the Excel 2007 Ribbon.
Use Excel Services to Enable Business Intelligence on Microsoft Office SharePoint Server 2007 Applications

Excel Services is a new way to interact with Excel spreadsheets, allowing you to add spreadsheets and workbooks to your enterprise dashboards and portals on Office SharePoint Server 2007. This free sample chapter from the Microsoft Press book, Programming Excel Services, covers:
  • Understanding Excel Services and Microsoft Office SharePoint Server 2007
  • Understanding the History of SharePoint
  • Installing and Configuring Excel Services

Thursday, July 12, 2007

Migrating From Oracle to SQL Server 2005

Migrating from Oracle: When SQL Server 2005 Makes Sense From DevX.com An article that rounds up a few ways to make longstanding Oracle adherents feel not only comfortable but highly conversant with SQL Server.

Tuesday, July 10, 2007

Latest SQL Server 2005 Fixes

FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1

FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '' does not match with a table name or alias name used in the query"

Office Security Updates for July 2007

Security Update for the 2007 Microsoft Office System (KB936514) A security vulnerability exists in the 2007 Microsoft Office System and the Compatibility Pack for the 2007 Office System that could allow remote code execution. This update resolves that vulnerability.

Security Update for Microsoft Office Publisher 2007 (KB936646) A security vulnerability exists in Microsoft Office Publisher 2007 that could allow remote code execution. This update resolves that vulnerability.

Security Update for Excel Viewer 2003 (KB936508) A security vulnerability exists in Microsoft Office Excel Viewer 2003 that could allow arbitrary code to run when opening a malicious document. This update addresses that vulnerability.

Security Update for Excel 2002 (KB936513) A security vulnerability exists in Microsoft Excel 2002 that could allow remote code execution. This update resolves that vulnerability.

Update for Microsoft Office Outlook 2007 (KB937608) This update fixes a problem in which a calendar item that is marked as private is opened if it is found by using the Search Desktop feature.

Security Update for Excel 2000 (KB936511) A security vulnerability exists in Microsoft Excel 2000 that could allow remote code execution. This update resolves that vulnerability.

Security Update for Microsoft Office Excel 2007 (KB936509) A security vulnerability exists in Microsoft Office Excel 2007 that could allow remote code execution. This update resolves that vulnerability.

Security Update for Excel 2003 (KB936507) A security vulnerability exists in Microsoft Office Excel 2003 that could allow remote code execution. This update resolves that vulnerability.

Saturday, July 07, 2007

Access 2007 on Vista Woes

As more users deploy Access 2007 on Windows Vista desktops, Access developers can expect a quantum leap in support calls. I have found that simple VBA code that works in all 32-bit versions of Access, including Access 2007 on pre-Vista Windows, does not work in Access 2007 on Vista.

Service packs are required now!

Tuesday, July 03, 2007

SQL Server 2005 Best Practices Analyzer (July 2007)

SQL Server 2005 Best Practices Analyzer (July 2007) The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings, using a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.