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:
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.
0X80090302
SEC_E_NOT_SUPPORTED
The requested Function is not supported
0x8009030f
SEC_E_MESSAGE_ALTERED
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
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
*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
