-
Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as...
-
I’m a big fan of the changes to clustering in Windows 2008, especially the new cluster support policy which is a big improvement over the HCL used for cluster validation in Windows 2000 and 2003. The HCL has been replaced by a Validation Test and a supported...
-
Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 2 hotfix to an installation of SQL Server 2005 Service Pack 2. By default, any hotfix that is provided in a SQL Server...
-
With the release of SQL 2008 Express I thought it would be helpful to add a note that it you try to use the ExpressMaint utility to perform database maintenance operations against SQL Server 2008 on a computer which has never had SQL Server 2005 installed...
-
Sometimes the visualisation of data can be difficult, consider displaying user activity for a multinational application. This is exactly what I wanted to do in such a manner that I could see who and when was using the system, however with over fifty countries...
-
http://sqlblog.com/blogs/joe_chang/archive/2008/08/17/large-query-performance-from-sql-server-2000-to-2008-32-64-bit.aspx Joe has published a well readable article.
-
Version 0.2 of the Allocation Add-in has just been released. It’s available from CodePlex here . This new version includes support for SQL Server 2008 RTM and has a couple of new features. The Allocation Map can now be set so that the entire file is rendered...
-
A new build of SQL 2005 Service Manager is now available for XP, Windows 2003 and Windows 2008 (1.0.0.14) and Vista (2.0.0.6). This release adds a fix for duplicate SSIS services when both SQL 2005 and SQL 2008 are installed. Note that it is fully compatible...
-
Having successfully installed SQL 2008 on my laptop I was looking forward to a smooth install on my main PC however it was not to be. Having gotten pretty much to the end of setup it failed on the SQL 2005 Express Tools rule. Now I know I've never...
-
Don't forget the early bird discount for the training days finishes this Friday (15th August) Seminar Register Early Bird Full Price Turbo charge your TSQL with .Net inside SQL Server click to register £150 £200 Advanced SQL Server Troubleshooting...
-
Don't forget the early bird discount for the training days finishes this Friday (15th August) Seminar Register Early Bird Full Price Turbo charge your TSQL with .Net inside SQL Server click to register £150 £200 Advanced SQL Server Troubleshooting...
-
The basic version of SQL 2008 Express is not available for download, the other editions (SQL 2008 Express with Tools and SQL 2008 Express with Advanced Services) are coming soon. Don't forget you will need to have installed .NET 3.5 SP1 and Windows...
-
In this Live Meeting Allan will be taking a look at some of the more interesting things that are coming our way for Integrations Services in SQL Server 2008. He will be looking at things like "The Caching Transform", the "Lookup Component"...
-
Many users complain that some new features are not working in SQL Server 2005 when the server is migrated from SQL Server 2000 These are the common tasks that should be done to avoid some migration issues 1 Change the compatibility level to 90 EXEC sp_dbcmptlevel...
-
As mentioned in a previous post , parts of SQL 2008 require you to have Visual Studio 2008 SP1 RTM installed if you had previously installed Visual Studio 2008 prior to installing SQL 2008. Today, Visual Studio 2008 Service Pack 1 RTM is available for...