Browse by Tags

All Tags » SQL Server 2005 (RSS)
Vital Statistics – free webcast now available
02 February 10 10:53 AM | Christian | with no comments
Another one of my sessions from SQLBits V, this time on SQL Server Statistics. You can it from the SQLBits website: http://tinyurl.com/yb2t2v5 The presentation was based on information that you’ll also find in my latest book, Professional SQL Server 2008...
Filed under: , , , , ,
Webcast Now On Demand: The 5-Minute SQL Server Healthcheck
16 November 09 08:59 PM | Christian | 1 comment(s)
I joined Kevin Kline from Quest on Thursday for a webcast on "The 5-minute SQL Server Healthcheck" which is now available online. I hope you find it useful! http://www.quest.com/events/listdetails.aspx?contentid=10581&technology=34&prod...
Filed under: , , ,
SQL Server Standard 'Lock pages in memory' workaround coming soon...
24 April 09 10:47 AM | Christian | with no comments
Bob Ward just announced at European SQL PASS that you'll be able to use the 'lock pages in memory' workaround in SQL Server Standard Edition to resolve working set trimming issues. In the next CU releases for SQL Server 2005 and 2008 you'll...
Filed under: ,
FREE one-day seminar on Optimising SQL Server Performance
08 March 09 01:54 PM | Christian | with no comments
I’m going to be joining Quest Software on 24th March for a seminar on Optimising SQL Server Performance at the Quest offices in Maidenhead, Berkshire. Attendance is FREE and you’ll get a chance to try out Quest’s product range with hands-on-labs: BOOK...
Filed under: , ,
A walk down memory lane, SQLBits Video now available
10 November 08 01:30 PM | Christian | with no comments
After surprising me with a camera crew and a lighting rig when I turned up to present my session at SQLBits in September, Microsoft have finished editing the footage and the finished result is now available. Fortunately for me they've done a great...
Filed under: , , , , , , ,
Temporary object re-use "nugget" at the UK SQL Server User Group
21 October 08 08:30 PM | Christian | 2 comment(s)
I presented a 5 minute nugget on temporary object re-use at the UK SQL Server User Group last week and I promised that I'd follow it up with a post so here it is! As of SQL Server 2005 temporary objects are now cached by default as long as Named constraints...
Filed under: ,
A walk down memory lane at SQLBitsIII
17 September 08 03:38 PM | Christian | with no comments
[Update 5th Nov 08] New download link added Thank you to everyone who attend my session on memory at SQLBits on 12th Sept. I really enjoyed it and judging by the feedback many of you did too. You can download the slideshow and pdf from our website: http...
Filed under: , , , , ,
LiveDataScript: Scripting data from a database into insert statements
30 July 08 09:50 AM | Christian | with no comments
We've partnered with a company called Live Software Solutions on a number of projects recently and they've just decide to release a great tool we've been using on a number of projects as a free download. It allows you to generate a single...
Filed under: ,
Customer Advisory Team - BizTalk Server Performance Optimization Guide
09 July 08 01:20 PM | Christian | 1 comment(s)
We've been doing some work with the BizTalk Customer Advisory Team at Microsoft to help develop official guidance for SQL Server in a BizTalk environment. This has just been launched as part of the Microsoft BizTalk Server Performance Optimization...
Filed under: ,
Will you still want me, when I'm 64?
29 April 08 09:44 AM | Christian | with no comments
[Update 5th Nov 08] New download link added Thankyou to all those who attended my session on 64-bit SQL Server at the UK SQL Server User Group on 17th April 2008. I've just got round to uploading the slidedeck for those of you that have been asking...
Filed under: , , , ,