Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

March 2006 - Posts

Friday, 31 March 2006 4:49 PM

F1

Either there are a great many cats meowing over the road in Albert Park, or that must be the F1 cars starting up today.. Melbourne sure is a city full of sports-crazed people - last week we were all going bonkers over the Commonwealth Games, now its the
posted by Greg_Linwood | 2 Comments
Filed Under:
Wednesday, 29 March 2006 9:00 AM

You CAN capture full error messages server-side (sp_altermessage)

I was talking to a colleague yesterday who was 100% CERTAIN that full error messages cannot be captured on the server at run time. He correctly pointed out that the SQL Profiler's Errors & Warnings: Exception event only reports the error number but
posted by Greg_Linwood | 2 Comments
Filed Under:
Tuesday, 28 March 2006 10:06 AM

Breaking changes in SQL Trace - not happy (mumble, mumble...)

We're upgrading our SQL Server monitoring toolset - SQLBenchmarkPro - at work at the moment so that it can monitor SQL 2000 & SQL 2005 instances concurrently. We hit a couple of snags recently which might be worth noting if you're into scripting
posted by Greg_Linwood | 0 Comments
Filed Under:
Monday, 27 March 2006 7:41 PM

SQL Server 2000 post SP4 hotfix build (build 2187)

Microsoft advised SQL MVPs this morning about the following SQL 2000 SP4 hotfix: We now have posted an update to the SQL Server 2000 post SP4 hotfix build we had to pull off the web some time ago. You can view the KB article for this new build (build
posted by Greg_Linwood | 0 Comments
Filed Under:
Saturday, 25 March 2006 8:10 AM

Query Optimization Team Blog

Conor Cunningham - from Microsoft's SQL Server Optimizer Team - announced a new blog to SQL Server MVPs today, which will be maintained by his colleagues in the SQL Server Optimizer Team. For those who are interested in optimizing SQL Server performance,
posted by Greg_Linwood | 0 Comments
Filed Under:
Friday, 24 March 2006 9:10 PM

Perth SQL Server User Group presentation

I presented a session to the Perth SQL Server User Group for the first time on Thursday - "Professional SQL Server Performance Tuning". I'd never been to Perth before, so it was good to get over there finally to meet the local UG organiser Brian Madsen
posted by Greg_Linwood | 3 Comments
Filed Under:
Wednesday, 22 March 2006 6:19 AM

SQL 2005's new "Forced Parameterization" feature

I was discussing the problems associated with managing the performance of SQL Server based vendor software systems with Kalen Delaney whilst she was teaching in Melbourne a couple of weeks ago & she pointed out a new SQL Server 2005
posted by Greg_Linwood | 1 Comments
Tuesday, 21 March 2006 10:53 PM

Real Time BI - AUSSQL presentation, Melbourne March, 2006

Darren Gosbell presented an interesting session at Melbourne tonight on SQL Server 2005 Analysis Service's Proactive Caching technologies. Despite my professional work mainly being performed in the relational engine side of the SQL Server technology,
posted by Greg_Linwood | 0 Comments
Filed Under:
Wednesday, 15 March 2006 8:02 PM

Upgrade to [Measure database file i/o with fn_virtualfilestats (SQL2000 AND SQL2005)]

I'm up-grading a script I posted a few weeks back which measures i/o at database file level. Included in the new script are: (a) Physical O/S filenames(b) Physical O/S file volumes(c) A secondary, summary report of i/o, aggregated to volume level. Cheers,Greg
posted by Greg_Linwood | 0 Comments
Filed Under:
Wednesday, 15 March 2006 7:39 AM

SQL Profiler - Errors & Warnings: Blocked Process Report

Now, here's a cool new SQL 2005 Profiler event I used for the first time in anger yesterday. What I love about this event is that it actually spits out significant & useful data from both the blocked process & blocking process - locked resource, input
posted by Greg_Linwood | 0 Comments
Filed Under:
Tuesday, 7 March 2006 6:49 AM

A useful SQL Server engine team blog

This morning I heard about a SQL Server Engine Team blog, where various members of the SQL product team blog about their specific areas of expertise. Worth a look at least: [url]http://blogs.msdn.com/sqltips/default.aspx[/url] One of the contributors
posted by Greg_Linwood | 0 Comments
Filed Under: