Time for another episode of the SQL Friday, The Best SQL Server Links Of The Past Week show, the Good Friday edition.
Here is what I found interesting this past week in SQL Land:
Updated Errors may occur after configuring Analysis Services to use Kerberos authentication on Advanced Encryption Standard Aware Operating Systems
The PSS SQL Server Engineers explain what causes this, here is just a part of the post
The Microsoft SQL Server Analysis Services support team has seen an increasing number of issues involving errors when attempting to execute queries against or deploy databases to instances of Analysis Services 2005 and Analysis Services 2008 that are configured for Kerberos authentication and running on Windows 2008 Server or Windows Vista. This note provides information regarding the errors that have been reported and investigated.
What we’ve found is that when a client application is running on an operating system that is Advanced Encryption Standard (AES) aware (i.e. Windows Vista and Windows 2008 Server) and connects to an Analysis Services server that is running on an operating system that is AES aware then one of the following error return values or error messages may surface.
The requested Function is not supported
The message or signature supplied for verification has been altered
Free SQL Server DBA Training Videos
Brent Ozar shows us some links to SQL Server DBA Tutorial Podcasts and also Free Online SQL Server Training Events
The 3 Things you Need to Know to Install SQL 2005 on Windows 2008 Cluster
The PSS SQL Server Engineers explain what we need to know to install SQL Server 2005 on a Windows 2008 Cluster
Page Splitting & Rollbacks
Michelle Ufford shows us that when you have a lot of rollbacks you could have page splits and not be aware of it
SQL Server 2008 SP1 and Cumulative Updates Explained
Does SQL Server 2008 SP1 contain the hotfixes that were included in Cumulative Update 4? good question, the PSS SQL Server Engineers explain that SQL Server 2008 SP1 does contain some fixes in CU4 for SQL Server 2008 RTM. There is a table in the post so make sure that you take a look
That is it for this week, I will tag the weekly posts with SQL Friday in case you want to see the whole archive in the future