I've just noticed that the SQL Server 2000 BOL has been updated and can be downloaded here http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en. I find it useful to have a copy of the SQL 2000 BOL installed as I'm constantly referencing the material (and it works on Vista).
There are some good katmai whitepapers appearing on the the katmai site. The list is available here http://www.microsoft.com/sql/2008/learning/whitepapers.mspx.
Performance and Scale http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_perfandscale.mspx
Delivering location intelligence with spatial data http://www.microsoft.com/sql/techinfo/whitepapers/spatialdata.mspx
SQL Server 2008 Reporting Services http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_ssrs.mspx
What's new for XML in SQL Server 2008 http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_xml.mspx
Managing unstructured data http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_unstructured.mspx
Server consolidation http://www.microsoft.com/sql/techinfo/whitepapers/hosting_sql_srv_consol.mspx
Data warehousing http://www.microsoft.com/sql/techinfo/whitepapers/sql-for-datawarehousing_2008.mspx
Data Programmability http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_dp.mspx
Lots of useful info appearing here http://sqlcat.com/Default.aspx. This is a great article on database mirroring log compression in Katmai http://sqlcat.com/technicalnotes/archive/2007/09/17/database-mirroring-log-compression-in-sql-server-2008-improves-throughput.aspx
This is a nice touch, the pre-canned VHD's are now available for pre-release versions of SQL Server 2008 CTP4 http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-82e4-4efd6705f4a6&DisplayLang=en and Windows Server 2008 Beta 3 http://www.microsoft.com/downloads/details.aspx?familyid=9AA65956-4A13-46A3-9711-82939A041792&displaylang=en. Note: the VHD download is split into approximately four compressed .rar files.
I thought the SQL Server 2005 Large Values out of Row would be a sp_tableoption config value similar to text in row - apparently not! It took a while to find out that this is hidden in sys.tables. The following query returns the value I was looking for:
SELECT [name] AS tablename, large_value_types_out_of_row FROM sys.tables
The PPS UK launch is happening on 16th October in London. Sign up here: http://www.microsoft.com/uk/office/ppslaunch/default.mspx
It's nice to see a new CTP of Katmai on the Microsoft Connect site - I've been waiting to look at the new database mirroring enhancement which performs automatic page repair. There are many other features in this CTP which are listed here https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470 which will be covered in the webcasts over August https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6082.
I like this whitepaper particularly because it talks about tuning, validating and benchmarking the storage system before laying down SQL Server on the disk. It is nice to see a mention of the disk sector alignment benefits in a SQL document as this has been mentioned before but primarily for Exchange, of course these problems go away in Vista and Windows Server 2008 as the disk is aligned by 1024 as default.
I almost missed this one.. SQL Server 2005 has received another update (May 2007) which can be downloaded here: http://www.microsoft.com/downloads/details.aspx?familyid=be6a2c5d-00df-4220-b133-29c1e0b6585f&displaylang=en - watch out, its 135mb! The updated BOL is also on MSDN :-)
Katmai information is slowly making its way into the public domain. There is a good webcast scheduled today. Further info here: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032341071&EventCategory=2&culture=en-US&CountryCode=US
A new cumulative hotfix has been released and contains quite a few important fixes. Read more about this build here http://support.microsoft.com/kb/935356.
Read more about the new certification here http://www.microsoft.com/learning/mcp/architect/database/default.mspx
If you haven't heard, we have just published some information about the next release of SQL Server codenamed Katmai - you can read more here http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx. I will post more details as soon as I get a spare half hour.
This is a really nice feature ...
"The Microsoft SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later" http://www.microsoft.com/downloads/details.aspx?FamilyId=1D3A4A0D-7E0C-4730-8204-E419218C1EFC&displaylang=en
As mentioned perviously, we identified a problem with the maintenance plan clean-up task that was introduced in SQL Server 2005 Service Pack 2. Well, the good news is that we have now released a hotfix to correct the problem which can be downloaded from here http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en.
The corresponding knowlege base article is available here http://support.microsoft.com/kb/933508 Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended.
FYI You should be aware of this issue if you intend to deploy SQL Server 2005 SP2: http://blogs.msdn.com/sqlrem/archive/2007/02/24/Maintenance-Plan-Changes-in-SQL-Server-2005-SP2.aspx
There are some really great entries appearing on the SQL Server 2005 Best Practices website. I just noticed this web page which discusses, amongs other things, some new features in SP2 like the vardecimal storage format and LOGON triggers. Take a look:
Top 10 Hidden Gems in SQL Server 2005 http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx.
I also like the SQL Server 2005 Script Repository http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true which provides links to some really useful scripts.
Service pack 2 for SQL Server 2005 is now available - all the details are here http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx.
We can expect the RTM release of Service Pack 2 for SQL Server 2005 very very soon. In the meantime, please take a look at the updated readme file (dated 9th Jan 2007) 'Whats new in SQL Server 2005 SP2' which is available here: http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/WhatsNewSQL2005SP2.htm (this has continually been updated in line with the fixes and changes which are being made).
Here are some of my favourite changes/additions:
I haven't posted for a while (please forgive me) as I've been quite busy over the past few weeks. I should really try to post more frequently. Anyway, I am not going to talk about Microsoft software but instead talk about the release of SQL Prompt 3 from Red Gate http://www.red-gate.com/products/SQL_Prompt/index.htm. I recently received the 'we have a new version' email so decided to take a look and I must say it is looking good. The metadata look-up performance is certainly better than version 2.
I'm also quite interested in the SQL Refactor tool http://www.red-gate.com/products/SQL_Refactor/index.htm which is also available from Red Gate. The T-SQL formatter 'Lay Out SQL' option is something I've been looking for ever since I saw something similiar in Toad Formatter Plus for Oracle.
We've just published a whole bunch of SQL Server best practices here http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx. There's some really great information on there and links to whitepaper resources. I'll certainly be bookmarking this for future reference.
PerformancePoint Server 2007 CTP1 is now available via the Connect website https://connect.microsoft.com/site/sitehome.aspx?SiteID=181. The bits (x86 and x64) are available to download including documentation and sample data etc. I haven't had a change to look at it yet but will do over the next few days.
On a slightly different note, my brother has decided to run in the London Marathon (26 miles!). He is raising money for Concern Worldwide - this is an international charity focused on education, health and emergencies. They work all over the world but concentrate much of their work around Africa. If you'd like to sponsor him for a good cause, please do so via: http://www.justgiving.com/mattjones. Thank you.
This is quite an interesting KB article detailing I/O requirements for tempdb, and amongst other things, the use of RAM disks and solid state media. There are some important points to consider e.g. as the media is not durable, only tempdb can be located on it; it cannot be used for other database files. It is also worth remembering that the performance of temp tables will not be great due to the double RAM caching mechanism. I recommend reading the KB article for the full details http://support.microsoft.com/kb/917047 Microsoft SQL Server I/O subsystem requirements for the tempdb database
Tony Rogerson (SQL Server MVP who runs the UK site sqlserverfaq.com) has two copies (invitations) of MSDN Team Subscription to give away! Go here to read the full competition details: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/11/1285.aspx
What do you need to do? Simple really, just contribute technical information, hints and tips or advice to the SQL Server community via the UK SQL Server User Group sister site www.sqlblogcasts.com. The winners will be announced at the end of this month (31st November).
The sysinternal tools are now on TechNet. I know this is not specifically related to SQL Server however, but they are very useful tools which can help diagnose performance problems. I particularly like process explorer and process monitor (and they work on x64 & Vista too!). Get them here: http://www.microsoft.com/technet/sysinternals/processesandthreadsutilities.mspx