Free "Basic Training" for SQL Server

Scaling Up Reporting Services 2008 vs. Reporting Services 2005

Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory

SQL Server 2008 Beta Exams

The Microsoft certifications blog for developer & SQL Server technologies, makes an Open Inventation for SQL Server 2008 DBA 71-432 and SQL Server 2008 BI 71-448, only through the end of July.

Link: http://blogs.msdn.com/gerryo/archive/2008/07/01/sql-server-beta-exams-extended-open-invitation.aspx

CU
tosc

T-SQL Programmability Features in SQL Server 2008

Jobs on production instances

BgInfo, WMI and SQL Server

BgInfo from Sysinternals (now Windows Sysinternals, by Mark Russinovich) automatically displays relevant information about a Windows computer on the desktop's background, such as the computer name, IP address, service pack version, and more interesting features like WMI query results!

Often when I walked up to several systems in our data center by using a console switch, I have quickly to know important aspects of theirs configurations and if all SQL-Servers Services are running.

And there for I make a small script, which I use with

Full story »

Report Server Catalog Best Practices

Link: http://sqlcat.com/technicalnotes/archive/2008/06/26/report-server-catalog-best-practices.aspx

This technical note is part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series which provides general guidance on how to set up, implement, and optimize an enterprise scale-out architecture for your Microsoft SQL Server Reporting Services (SSRS) environment.

CU
tosc

Cumulative update package 9 for SQL Server 2005 Service Pack 2

The Cumulative Update package 9 for SQL Server 2005 Service Pack 2 (Build 09.00.3257.00) is now available:

http://support.microsoft.com/kb/953752/en-us

And here you can get the whole information of builds that were released after SQL Server 2005 Service Pack 2:

http://support.microsoft.com/kb/937137/en-us

CU
tosc

Scaling Out SQL Server 2005

Link: http://blogs.msdn.com/sqlcat/archive/2008/06/12/sql-server-scale-out.aspx

Kevin Cox from the Microsoft SQL Server Development Customer Advisory Team point it out, the SQL Server scale well.

CU
tosc