February 2011 –Technical Rollup Mail–SQL
News
HP Business Decision Appliance – A Closer Look at Backup and Availability Features
SQL Server Appliances – A Workload-based Appliance Design Philosophy
Microsoft SQL Server Compact 4.0 is available for download and use with WebMatrix
Other
https://blogs.technet.com/trm/default.aspx
Events/Webcasts
TechNet Webcast: Best Practices on Deploying PROS with SQL Server (Level 200)
Join us for this webcast as we share the best practices for deploying the PROS Pricing Suite application on Microsoft SQL Server 2008 data management software. We talk in detail about performance, high availability, and scaling the Pricing Suite application on the Windows Server 2008 R2 operating system and SQL Server 2008, using practical customer deployments as examples.
SQL Server Performance Tuning Seminar for Developers and Administrators
Join us at our SQL Server Performance Tuning Seminar to gain advanced knowledge in tuning and monitoring Microsoft SQL Server 2008 and SQL Server 2005. The seminar addresses CPU, Memory, Disk, Query and Lock monitoring and tuning techniques.
New KB's
SQL 2005
Microsoft SQL Server 2005 Analysis Services: An MDX query that contains an Aggregate function returns #Error for the cell values in SQL Server 2005 Analysis Services
https://support.microsoft.com/kb/942981/en-US
Microsoft SQL Server 2005 Developer Edition: FIX: Slow performance when you recover a database if there are many VLFs inside the transaction log in SQL Server 2005 or in SQL Server 2008
https://support.microsoft.com/kb/2455009/en-US
Microsoft SQL Server 2005 Developer Edition: Applications may fail after upgrading your database from SQL Server 2000 to a later version
https://support.microsoft.com/kb/2470176/en-US
Microsoft SQL Server 2005 Enterprise Edition: You get "Error code 64" when accessing Replisapi.dll through ISA server
https://support.microsoft.com/kb/2481773/en-US
SQL 2008
Microsoft SQL Server 2008 Analysis Services: FIX: SSAS 2008 crashes after a ProcessFull operation is performed on a measure group for a server-based cube if SSAS tries to clean a session that contains a session cube
https://support.microsoft.com/kb/2480368/en-US
Microsoft SQL Server 2008 Analysis Services: FIX: PivotTable report might return no values after you apply a complex filter in SSAS 2008
https://support.microsoft.com/kb/2481245/en-US
Microsoft SQL Server 2008 Analysis Services: "Excel experienced a serious problem with the 'sqlserver.dmxladdin' add-in" error message after you install SQL Server 2008 Data Mining Add-ins for Office 2007
https://support.microsoft.com/kb/2491880/en-US
Microsoft SQL Server 2008 Analysis Services: "SQL Server 2008 Setup requires Microsoft .NET Framework 4.0 to be installed" error message when you apply Service Pack 2 (SP2) for SQL Server 2008
https://support.microsoft.com/kb/2500042/en-US
Microsoft SQL Server 2008 Developer: Error message when you install SQL Server 2008 RTM on a localized (non-English) Windows Server 2003 version: "SQLBrowser start request failed"
https://support.microsoft.com/kb/2420359/en-US
Microsoft SQL Server 2008 Developer: Cumulative update package 12 for SQL Server 2008 Service Pack 1
https://support.microsoft.com/kb/2467236/en-US
Microsoft SQL Server 2008 Developer: FIX: "xact_seqno" column in the "MSrepl_errors" table does not record a skipped row in SQL Server 2008 if you use the "-SkipErrors" parameter in the Distribution Agent
https://support.microsoft.com/kb/2484392/en-US
Microsoft SQL Server 2008 Developer: "RESTORE DATABASE is terminating abnormally" error message when you perform a full backup of a database in SQL Server 2008 R2
https://support.microsoft.com/kb/2487231/en-US
Microsoft SQL Server 2008 Developer: "Non-yielding Scheduler" error and SQL Server 2008 stops responding intermittently in Windows Server 2008
https://support.microsoft.com/kb/2491214/en-US
Microsoft SQL Server 2008 Developer: You receive an error message when you set up a SQL Server 2008 failover cluster on a subnet that contains only IPv6 addresses
https://support.microsoft.com/kb/975951/en-US
Microsoft SQL Server 2008 Enterprise: FIX: 10061 Winsock error code occurs when an application uses the extended OLE DB initialization properties for the SQL Server Native Client 10.0 OLE DB provider in the connection string
https://support.microsoft.com/kb/2482977/en-US
Microsoft SQL Server 2008 Reporting Services: Colors get distorted when you copy an Excel worksheet that is exported from Reporting Services
https://support.microsoft.com/kb/2465477/en-US
Microsoft SQL Server 2008 Reporting Services: FIX: "An item with the same key has already been added" error when you export a report to a PDF or TIFF file in SQL Server 2008 Reporting Services