Friday, 12 February 2010

Advanced SQL Training on the way ... hopefully

Paul Randal has blogged about the next set of classes that he and Kimberly will be presenting in April this year.

Last time they were in Australia I missed the course, but caught them at their user group presentation.

Hopefully, this time round I can grab a seat on the course.

Wednesday, 3 February 2010

DBA Survivor Name That Caption Contest

Thomas LaRock is running a a “Name That Caption” contest over at his DBA Survivor website promoting his upcoming book DBA Survivor: Become a Rock Star DBA of the same name. 

Here's my entry.

"Hmmm ... if I concentrate hard enough I can't hear that Access Developer outlining his next 'SQL Server' project"
"I wonder if anyone would mind if I stick the system views poster here."

Fwd: Important notice: Google Apps browser support

Users of older browsers, you are on notification, upgrade now  ...

Google Chrome
Apple Safari
Mozilla Firefox
Microsoft Internet Explorer

---------- Forwarded message ----------
From: <>
Date: Wed, Feb 3, 2010 at 8:18 AM
Subject: Important notice: Google Apps browser support

Dear Google Apps admin,​

In order to continue to improve our products and deliver more sophisticated features and performance, we are harnessing some of the latest improvements in web browser technology.  This includes faster JavaScript processing and new standards like HTML5.  As a result, over the course of 2010, we will be phasing out support for Microsoft Internet Explorer 6.0 as well as other older browsers that are not supported by their own manufacturers.

We plan to begin phasing out support of these older browsers on the Google Docs suite and the Google Sites editor on March 1, 2010.  After that point, certain functionality within these applications may have higher latency and may not work correctly in these older browsers. Later in 2010, we will start to phase out support for these browsers for Google Mail and Google Calendar.

Google Apps will continue to support Internet Explorer 7.0 and above, Firefox 3.0 and above, Google Chrome 4.0 and above, and Safari 3.0 and above.

Starting this week, users on these older browsers will see a message in Google Docs and the Google Sites editor explaining this change and asking them to upgrade their browser.  We will also alert you again closer to March 1 to remind you of this change.

In 2009, the Google Apps team delivered more than 100 improvements to enhance your product experience.  We are aiming to beat that in 2010 and continue to deliver the best and most innovative collaboration products for businesses.

Thank you for your continued support!


The Google Apps team

Email preferences: You have received this mandatory email service announcement to update you about important changes to your Google Apps product or account.

Google Inc.
1600 Amphitheatre Parkway
Mountain View, CA 94043


Tuesday, 2 February 2010

Open Transactions with SQL text

Just trying to track down which spid is bashing my poor little SQL machine.
Quite coincidentally Paul Randall just blogged about a new script to show who has open transactions on the server.

Only problem is I want the same information in SQL 2000 land ... :(

Best I can come up with at the moment is,

   1:  select [spid], [blocked], [waittime], [lastwaittype]
   2:    , [waitresource], [dbid], [cpu], [physical_io]
   3:    , [memusage], [login_time], [last_batch], [open_tran]
   4:    , [status], [hostname], [program_name]
   5:  from master..sysprocesses
   6:  where [spid] > 51
   7:    and [blocked] > 0
   8:  order by [blocked], spid
  10:  DECLARE @Handle binary(20)
  11:  SELECT @Handle = sql_handle FROM master..sysprocesses 
  12:  WHERE spid = 527  
  13:  SELECT * FROM ::fn_get_sql(@Handle)

Move files from sub-directory to root folder

Had a need to move a bunch of database backup files from sub-directories into a root folder so it was easier for my restore script to process them all. Came across this little gem and decided it really needed to go into my toolbox

for /f "tokens=5* skip=2" %i in ('dir *.bak ^| findstr "DIR"') do (move %i\*.* .)