Sunday, April 25, 2010

Free ebook: Introducing Microsoft SQL Server 2008 R2

Another free ebook from Microsoft Press: Introducing Microsoft SQL Server 2008 R2

The 10 chapters and 216 pages cover:
  • Part I: Database Administration
    • Chapter 1: SQL Server 2008 R2 Editions and Enhancements
    • Chapter 2: Multi-Server Administration
    • Chapter 3: Data-Tier Applications
    • Chapter 4: High Availability and Virtualization Enhancements
    • Chapter 5: Consolidation and Monitoring
  • Part II: Business Intelligence Development
    • Chapter 6: Scalable Data Warehousing
    • Chapter 7: Master Data Services
    • Chapter 8: Complex Event Processing with StreamInsight
    • Chapter 9: Reporting Services Enhancements
    • Chapter 10: Self-Service Analysis with PowerPivot
Read more here:

Or download in XPS format here or PDF format here.

Tuesday, April 20, 2010

Messed up Product Builder lookups

Users are able to right click and change some of the lookup's in the Product Builder configuration form. This way they can by accident hide the entire lookup and not be able to use it again, before someone deletes the change from their Usage Data.

To avoid this issue, set the property AllowUserSetup on the design of the PBATableVarLookup and PBAVariableEnumLookup forms to No.