Shaving for a great cause – The Leukaemia Foundation

I’m going bald.

For Charity. And I need all of you to help me help the Leukaemia Foundation by donating here http://my.leukaemiafoundation.org.au/lukehayler

Today, 31 Australians will get the news they have blood cancer. Your donation will help the Leukaemia Foundation support them from the moment they are diagnosed, free of charge.

The money you give will also help to fund Australia’s best blood cancer research.

I have also been dared to have my legs waxed, which stupidly I agreed to, but only if I reach $1,000. If I reach this goal I’ll have the waxing done here at work in front of about 60 people…and I am sure that someone will video it.

So please donate (but not too generously, am not keen on the waxing idea).

And if you don’t want to donate, then please at least share this update with your network.

Thanks!

[TeraGSS Security Library] [115022] Exception occurred in TERAGSS layer

Ever have a moment where all you seem to do is bang you head against a wall in frustration over trying to overcome an error? Yeah, I just had one.

I have a MS SSAS Tabular solution which connects to Teradata using a .Net data Provider (for Teradata, obviously). And, having recently updated my LAN password (to which my Teradata login is linked) I started getting the following error when trying to connect via the Tabular solution:

============================

Error Message:

============================

[Teradata Database] [8017] The UserId, Password or Account is invalid.
—————————-
TdgssAuthenticationTokenExchange delegate threw an exception. See the inner exception for details.
ErrorCode: -452984642 Severity: Error Facility: DotNet
—————————-
[TeraGSS Security Library] [115022] Exception occurred in TERAGSS layer. See inner exception for details.
—————————-
Failed to connect to the server. Reason: [TeraGSS Security Library] [115022] Exception occurred in TERAGSS layer. See inner exception for details.

 

Now the line that stands out quite prominently is “The UserId, Password or Account is invalid“. And since I checked and double checked that this was fine  and that my account hadn’t been locked out, I was starting to get a little frustrated.

I tried uninstalling the .Net data provider, restarting and then re-installing it. That didn’t work for me, but it has for others who have gone down this route.

Then I found this little gem of an article on the Teradata forums, which goes on to say that if a password contains special characters (Including @, / and \) then these special characters need to be escaped (using \) in order for the password to be accepted.

I tried it. It worked like a charm.

Hopefully I won’t forget about this little ‘feature’ next time I encounter this error…

 

 

SQL Server Social 13 – in the bag.

What a great evening.

Yet again, our wonderful sponsors (LobsterPot, Avanade, Pluralsight & Redgate) have ensured that the data community in Melbourne stays connected on a personal level. So a big thank you to them for their ongoing support.

We had a few prizes to give away tonight, including:

  • Redgate books, USB keys & t-shirts
  • Pluralsight one-month subscription to the full library of training videos.

Congratulations to the several lucky attendees who managed to correctly answer the quiz questions and ask the best of our experts. We hope you enjoy your prizes!

 

Martin Cairney and Stefan Riedel read out some tricky questions as part of the Pop Quiz

SQL Server Social – Pop Quiz!

 

SQL Server Social

SQL Server Social – In the Cells of the Royal Melbourne Hotel

Be sure not to miss it next month when we have three more Pluralsight one-month subscriptions and two Redgate software licenses (SQL Prompt (worth $195) & SQL Monitor (worth $795) up for grabs!

We are also hoping to confirm attendance of a very special guest who will be in town for the next SQL Server Social. Once the date has been booked in registrations will open and invitations will be sent out. You won’t want to miss the March event, trust me.

See you in March.

 

SQL Sever Social No. 13

SQL Server Social

If you are in Melbourne this week be sure to drop in and say hello at the next SQL Server Social event. If you haven’t heard about it before, it is a networking event for those working in the data industry (if you’ve heard the terms ‘database’ and ‘business intelligence’, then this is you).

 

Event Details

Date: February 6th, 2013 from 5:30pm onwards

Venue: The Royal Melbourne Hotel, 629 Bourke Street, Melbourne, Australia

Registration (FREE!): http://sqlserversocial13.eventbrite.com

 

This event is sponsored by LobsterPot Solutions, Avanade & Pluralsight so your food and drinks for the duration of the evening will be covered. All you need to do is turn up!

See you there!

-L

PicPick. Because it’s pure awesome.

This is THE little screencapturer that definitely could. I used to be an avid fan of Zing. It’s still good. But PicPick beats it hands down.

It’s not just a screen capture tool. It’s an image editor, a whiteboard, and a ruler too. And one of the features that I love best (and I loved this about Zing too) is that the screen capture is triggered by hot keys (Shift + Print Screen, for example).

Oh, and it’s FREE*.

image 

Go get it from picpick.org or go here to download it directly. Highly recommended!

*For home/personal use.

Gettin’ my Run on again.

It’s bee far too long since I wore out a good pair of running shoes, but the time has come once again to do just that. I have only done one half-marathon and that was a few years ago now. I vowed then that I’d never do it again (I hit an 11mile wall that was pretty hard to get through). Times change. I want to do it again. With a view to doing a full marathon at some point ‘in the future’.

Today was day 1. Of many. And while it was only on a treadmill, I have started well and FEEL AWESOME! A quick 5KM in just over 30 minutes is not bad going, considering it’s been months.

I have the #sqlfamily to thank. #sqlrun is the driver of this change and long may you wonderful people continue to encourage others.

Here’s my run activity for today:

Distance 3.12 miles (5 KM)
Duration 00:30:14
Average Pace 09:42 min/mile
Average Speed 6.19 mph
Calories Burned (apparently) 392

http://runkeeper.com/user/lukehayler/activity/62714410

Tomorrow brings more Downhill Mountain Biking! Woo Hoo!!

SQL Server Social No. 2 – Movember Edition

SherlockHolmesInnLast Thursday saw the first of many regular SQL Server Social events.Held at the Sherlock Holmes Inn on Collins Street, it was a great event with around 25-30 people in attendance. A lot more than I imagined considering a last minute change to the date.

Stephen Few, renown educator and trainer in BI Visualisations and author, had been giving a BI Visualisation workshop earlier in the week. I was in attendance at the workshop and managed to persuade Stephen to attend our social event. He was only in Melbourne until Friday November 18th, hence the last minute change to the date.

 

It was a Movember themed event, but unfortunately not that many people took part. I was one of two Mo Bro’s of the evening. Angus Bell had quite the impressive Mo and walked away with a heap of Movember merchandise (which he later gave away at another Movember party), as well as bottle of wine. It was a great effort by Angus, check out his Mo below and donate to his cause here:

Angus Bell

 

Next month’s event is in the works and will be held, once again, at The Sherlock Holmes Inn. Dates and times will be communicated soon. Stay tuned for more on SQL Server Social!

SQL Server Social Update – Stephen Few to join us!

7609782-wooden-barrelThat’s right. Stephen Few, the leading educator and author in data visualisation techniques, will be joining us for the November SQL Server Social event.

However, in order to have Stephen join us, it has meant that I have had to change the date of the event. So, SQL server Social will now be held THIS THURSDAY, 17th November 2011.

Stephen is an incredibly busy individual and travels all over the world enlightening people on data visualisation best practices, so I am privileged that he has agreed to join us.

I’ll be sending out updates to those of you who have already registered and will be apologising profusely. Don’t worry, if you can make it, your current registration will still stand. For those of you who can now make it, please head over to http://sqlserversocial.eventbrite.com to sign up. Don’t forget, this is a rare opportunity to come and meet, and chat to, one of the leading experts on data visualisation.

It’s Movember–Don’t forget about Men’s health!

iPhone 1483

It’s Movember time again, and that means ridiculous facial hair for many men. Much to the disgust of their spouse. But it’s not about looking ridiculous, that’s just a by-product. It’s about awareness and education of men’s health.

Think about this:

  • On average men die five to six years younger than women.
  • The suicide rate is four times higher for men than women
  • More than five men die prematurely each hour from potentially preventable illnesses

Men’s health is all too easily forgotten or pushed by the wayside. Men are notoriously adverse to seeking medical help when they need it most; believing that they should ‘tough it out’.

The Movember campaign is all about raising awareness of men’s health issues that often get ignored; Prostate cancer and depression (in men).  There are two key charities:

And let’s not forget the Movember Global Action Plan that aims to accelerate prostate cancer outcomes through global research collaboration.

Some stats (Because data is cool right?)

The Movember campaign has been alive since 2003 and each year builds on the success of the last. It’ll be interesting to see how 2011 fares.

So what can YOU do?

 

Fancy a party?

I’m hosting an event later this month called SQL Server Social. It’s a great event. People meet, talk, drink, network and generally have a great time. This month we are turning the event into a Mo Party. It’ll be wall-to-wall, floor-to-ceiling Mos. There’ll be prizes and giveaways and even a free drink on your arrival. If you’re interested head on over to http://sqlserversocial.eventbrite.com and register. All the details about the event are listed there too. SQL Server Social has several online presences:

 

 

Do your bit. Grow a Mo!

SQL Server Social – Movember Edition!

7609782-wooden-barrelIt’s back! After a very successful pilot event back in May this year, SQL Server Social has been confirmed for November, so it’s time to save a date in your diary so you don’t forget.

Event Details

Date 24th November 2011
Time 5:30pm onwards
Venue The Sherlock Holmes Inn,
415 Collins Street,
Melbourne,
Australia
Special Theme Movember!
Eventbrite link for registration http://sqlserversocial.eventbrite.com/

 

If you are not sure what SQL Server Social is all about, you can either read about the first event here, or check out the following recap:

What is SQL Server Social

SQL Server Social is a monthly event that has been created to provide SQL Server Professionals with a chance to network with industry peers, discuss predefined topics, have a little fun, have a beer and make some new friends.

What is the aim of SQL Server Social

SQL Server Social aims to build local SQL Server communities through regular social meetings, where database professionals can share their experiences and learn from their peers through open discussion.

Movember Edition

This month’s edition is a special one. It’s Movember and that means Mos! Here’s what the campaign is all about:

During November each year, Movember is responsible for the sprouting of moustaches on thousands of men’s faces in Australia and around the world. The aim of which is to raise vital funds and awareness for men’s health, specifically prostate cancer and depression in men.

For all the guys planning on attending, let’s see who has the best Mo by the 24th of this month. There’ll still be 6 days remaining until the official end of the campaign, but it’ll be good to see how you are all faring by that stage. This will be my first year participating; you can follow my ‘progress’ on my Mo page – mobro.co/lukehayler. If you feel so inclined, I have also put together a team for SQL Server Social, so show your support for the cause and join in!

Facebook Page!

SQL Server Social now has it’s own Facebook page. This page will be used to keep all the fans in the loop with updates about future events, photos from past events, links to interesting SQL-related sites, and so-on and so-forth…So if you are on Facebook why not tag along and keep up-to-date. Check out the page here.

Twitter!

SQL Server Social is also all over twitter like a bad rash. Follow us for updates – @sqlserversocial

SQL Crosswords

One of the [optional] challenges for the event is to complete a SQL Server Crossword. The SQL Server Crosswords have been generously donated to our cause by John Sansom (blog | @JohnSansom). John is a DBA in the UK and is a frequent blogger at www.johnsansom.com. John has had several awards bestowed upon him including Microsoft’s Community Contributor 2011 and SQLServerPedia’s Professional Development 2010 Winner as well as being a Rock Star Blogger (in Tom La Rock’s rankings). John has a wealth of information on his blog, so do yourself a favour and go check it out.

See you there!