Phills Philosophies

Guess there's no cricket this weekend

2010-10-15T08:14:00.000+10:00

Doesn't look very promising :(

Chile rescue shaft nears trapped miners | News.com.au

2010-10-08T12:25:00.001+10:00

Finally coming close to re-uniting these guys with their familiesSee this Amp at http://amplify.com/u/c1kk

2010-09-20T13:37:00.001+10:00

Loving the canary build http://amplify.com/u/asog

Early Access Release Channels - The Chromium Projects

2010-09-20T01:04:00.001+10:00

Get your latest Chrome fix here ...See this Amp at http://amplify.com/u/arqe

2010-09-20T01:02:00.001+10:00

This is my first post on Amplify! http://amplify.com/u/arq8

2010-09-09T08:57:00.000+10:00

Very cool look at an arcade games museum in Moscow. http://adangerousbusiness.com/2010/01/05/the-museum-of-soviet-video-games/

Gotta Love Telstra

2010-09-03T11:56:00.001+10:00

Yesterday My Plan Your current plan is BigPond Elite Liberty* (25GB) - Cable $89.95 monthly Today My Plan Your current plan is BigPond Elite Liberty* (100GB) - Cable $79.95 monthly Hmmm ... an extra 75GB for $10 less ... no I don't want that plan ... yeh roight!

Cats! I'm a kitty kat ...

2010-08-24T13:27:00.000+10:00

An old one I found during a cleanup ... http://www.albinoblacksheep.com/flash/kittycat.php

No cyberattack, but eerily similar

2010-05-13T17:50:00.001+10:00

Read this write up about the big Wall Street drop on May 6 with interest.For anyone that reads Tom Clancy, does it sound a bit too close to the financial crisis fomented by the Japanese in Debt of Honor?

T-SQL Tuesday #006: fixing the text blob

2010-05-11T15:40:00.002+10:00

Thought I'd join the T-SQL Tuesday party. Originally started by Adam Machanic (Twitter: @AdamMachanic), this one is hosted by Michael Coles. Many moons ago whilst working for MyDBA we came across a data corruption problem at a client site. Their vendor supplied application running on SQL Server 2000 stored a bunch of notes in a text column with lovely HTML formatting. The same data was also

LHC has stable beams ...

2010-03-30T21:32:00.000+10:00

... and the world didn't end!! http://meltronx.com/lhcdatawide/index.html http://hasthelargehadroncolliderdestroyedtheworldyet.com/ http://www.cyriak.co.uk/lhc/lhc-webcams.html

Yet another impressive view of Paris

2010-03-26T15:26:00.001+10:00

http://www.gillesvidal.com/blogpano/paris.htm

2010-03-23T10:18:00.000+10:00

Quick query to list which Reporting Services report the SQL Agent jobs relate to. .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: Consolas, "Courier New", Courier, Monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color:

SQL Artwork

2010-03-19T10:23:00.000+10:00

MS Premier Field Engineer Fabricio Catae posts a stunning piece of deadlock artwork.

I've heard of late trains ... but ...

2010-03-18T19:37:00.000+10:00

Snapped this whilst I was waiting for my train home. I think we can safely say that the trains never ran that late when Connex was running the system ... LOL

Paris @ 26 Gigapixels

2010-03-17T14:36:00.003+10:00

http://www.paris-26-gigapixels.com/index-en.html “a stitching of 2346 single photos showing a very high-resolution panoramic view of the French capital (354159x75570 px)” What’s the signage on the building to the right of the red crane? How many antennas does the black office building have on it? What time is it by the clock on the bell tower? Free Kudos to whoever gets all three correct.

Advanced SQL Training on the way ... hopefully

2010-02-12T17:52:00.001+10:00

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.

DBA Survivor Name That Caption Contest

2010-02-03T08:44:00.000+10:00

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"or "I wonder if anyone would mind if I stick the system views poster here."

Fwd: Important notice: Google Apps browser support

2010-02-03T07:58:00.001+10:00

Users of older browsers, you are on notification, upgrade now ...Google ChromeApple SafariMozilla Firefox Microsoft Internet Explorer---------- Forwarded message ---------- From: <apps-noreply@google.com>Date: Wed, Feb 3, 2010 at 8:18 AMSubject: Important notice: Google Apps browser support To: philcart@gmail.comDear Google Apps admin, In order to continue to improve our products and deliver

Open Transactions with SQL text

2010-02-02T15:09:00.000+10:00

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, .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: Consolas,

Move files from sub-directory to root folder

2010-02-02T10:57:00.001+10:00

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\*.* .)

SQL Server x32 Perfmon on Windows x64

2010-01-28T12:36:00.001+10:00

For me to find later http://weblogs.asp.net/guybarrette/archive/2009/06/16/missing-sql-server-x32-performance-counters-on-x64-windows.aspx

The things you find

2010-01-05T15:56:00.000+10:00

Was just trawling through my disk doing a bit of a clean out and discovered a folder with a few images. In amongst them were these two which are a before and after shot of Mount St Helens after it erupted in 1980. On that morning in May over 1,300 feet was removed from the summit and over 2 cubic kilometers of dirt and rock was displaced. Awesome display of force from Mother Nature.

Quick snapshot of current activity

2009-12-18T17:51:00.001+10:00

This query provides a quick snapshot of current active and waiting sessions in SQL Server 2008. select er.[session_id], txt.[text], pln.[query_plan] , sess.login_name, sess.host_name, db.name as db_name , sess.last_request_start_time, sess.last_request_end_time , er.[blocking_session_id], er.[last_wait_type], er.[wait_time] , er.[cpu_time], er.[reads], er.[writes], er.[

SQL 2008 Database Mail Resend

2009-12-15T11:27:00.001+10:00

Try this query to resend failed items in the Database Mail queue. declare @mailItem intdeclare @mailRequest nvarchar(max)declare @mailRecipient nvarchar(max)declare @mailSubject nvarchar(255)declare @mailSendDate datetimedeclare @statusMsg nvarchar(400)declare @rc intdeclare curFailedMail cursor fast_forward for SELECT [mailitem_id] FROM [msdb].[dbo].[sysmail_faileditems]open