SQLRally and beyond

I am almost ashamed to say that I have let over a month pass since my last post and truth be told I have come close a few times without never actually pressing that submit button.

I shan’t bore you with my excuses or reasons for my inactivity but what matters is I’m back!

I’ve been seeing an increasing amount of noise about SQLRally Dallas and I felt that I wanted to share my own personal experience with you about this rather unique event (in Orlando) -for it quite literary changed my life.

Six years or so ago I joined a company with big hopes and promises and after starting a small family (and growing it further after joining) I was looking for a period of stability and a platform to learn, improve and share my skills. In short I knew that come what may, as good or bad as things might get, I was there for the long haul.

Not long after joining, my skills and talent for other technologies were recognised and when the need for a specialized “crack” team supporting a critical troublesome in-house application, I was identified as their man. This position (I was told) would be permanent and was absolutely vital to the running of the company operation. There was one small problem -I didn’t want it and regretfully declined. My reasons were many but I had joined the company as a SQL Server SME and saw the very broad set of skills required to support one single application platform as a regression in my ever growing expertise in SQL Server (and increasing knowledge in Oracle) and did my best to explain this.

Unfortunately for me, the Technical Director at the time (let’s give him a fictitious name of Dennis) told me in no uncertain terms that this would be the last time I ever refused him. Three months into my new job, everything had turned sour overnight simply due to me being good at what I do.

Years would pass and with each new year would bring a new job offer somewhere else for an ever increasing Salary, but I would always find an excuse not to take it -probably the thought of working for someone else again and repeating the same mistake was always the biggest reason to avoid saying yes.

Then something happened.

Although I have been helping in forums and the like on and off for a long period of time which you can read a little more about in this post (Standing upon the shoulders of Giants) I always felt that I had more to give, more to share, more to say and more to learn. I decided to submit my first ever public presentation to SQLBits 7 and surprisingly managed to secure a speaking slot! As daunting as the whole thing was, I think I managed to pull it off -and if nothing else I know that I learnt LOADS during my weeks and weeks of hard graft of preparation putting it all together.

About a month or so later I took a week off work and self financed a trip to the SQLPASS 2010 Summit (my very first time) and met some absolutely amazingly talented people which is probably another story for another time.

Whilst in Seattle I decided that should the opportunity arise, I wanted to attempt a presentation in America and would submit and hope for the best. SQLRally Orlando was announced and my submissions went in. Although I didn’t make the first cut, my submission received the joint highest votes for the runners up and quite incredibly I was eventually selected as a wildcard! Totally brilliant and I was thrilled!

This time (unlike Seattle) I thought I would approach Dennis and see if my company would like to contribute in any way, since there would be obvious technical benefits to the organization. The response did not surprise me. He said that my speaking and attending sessions at SQLRally (or anywhere else) had absolutely no benefit to the company at all. I have never forgotten the impact that sentence made upon me. The situation was made even more ironic when a few days later I was assigned to an important scalability project (for someone had personally requested that I should be the resource).

…… The title of my presentation : “Orders of magnitude-Scaling your SQL Server Data“.

Like the SQLPASS Summit, I fully financed my trip to SQLRally and used a week of my holiday entitlement and came to a decision. I realised that however much I tried to improve myself socially and technically (and help others), Dennis would never support my efforts in any way. A few days later I received a permanent job offer from another firm offering a substantial salary increase (almost double) and I ……….turned it down!

SQLRally helped me realize that the only person holding me back was myself and It was time for me make the jump. I quit and left for Orlando to give my presentation. On my return I secured work and now when I need to finance any speaking or training events, the only person I need to convince is myself.

But what of SQLRally? I loved giving my presentation, it was very hard work preparing for it but I learnt more than I can put into words at hopefully managed to communicate some of that knowledge across. From a non speaking perspective, if you have never been to a SQL Server event and can get to Dallas then you are going to LOVE it. SQLRally is smaller than the Summit and full of lots of first timers and many regulars who will embrace you and make you feel completely at home.

Attending SQLRally could be your first steps towards something amazing. I hope you take them, and if you do, I look forward to meeting you someday soon and hopefully share a nice cold beer.


You can read more about my exploits at SQLRally here and here.

What has happened to me since my return?

Going forward I am currently :-

Dennis, I think you made a mistake with me but I know you would never be able to admit it. I sincerely thank you for every single day I spent praying for deliverance. You made me realize that if I wanted something strongly enough I could go out there and get it. Through your neglect you encouraged me to meet people LIKE me. You have given me hope and for that I will never forget you.

Posted in humour, learning, personaldevelopment, publicspeaking, sql, sqlbits, sqlpass, sqlrally, SQLServerPedia Syndication, summit, summit_2011 | 3 Comments

T-SQL Tuesday #25 – The Best Tool You’ve Never Used

Wow, it’s been a long time since my last T-SQL Tuesday post and I have disappointingly missed it 5 times for one reason or another. Still, the important thing is that I am back people!

This month’s T-SQL Tuesday is brought to you by Allen White (blog|twitter) who many of you will know for his PowerShell, SMO and SQL Server expertise.


Ironically for this post (or the subject at least) I was saving up towards a larger Data Visualisation article that I was putting together, but when I read the subject of this months T-SQL Tuesday I just knew it was time to spill the beans.

Let me give you the backstory…

Around four years ago, week in and week out I used to religiously buy a Technology Publication just on the “off chance” that they would have something of use in their pages. Very occasionally a little gem would crop up and eventually one day I found what I was looking for. This particular little gem used a rather ingenious way to visualise folder and file space usage and most importantly it was free and fast.

One of the biggest problems I used to experience as a production DBA was the filling of various disk drives. From backups, log, data, tempdb and even system drive we would get it all and having a substantial amount of servers made it a common problem.

When these issues would occur I was very happy to receive them because I knew I could identify the problem area in minutes (if not seconds) and it was always very satisfying to whip out my secret tool (ooo errr missus!)

So why is it so good…

There are of course lots of other space analysis tools on the market, many commercial and many shareware or even free. But most of those I have seen have usually been slow, used poor visualisation and mostly required a local or remote installation. My tool is a simple Windows based executable that does not require installation and can live on your network home folder. This can be mapped across to any server you Remote Desktop into, so hey presto it is always available to you :)

One of the biggest usability points of the tool is the ability to zoom into out out of folders very easily and quickly. It is this ability which makes finding problem files and folders incredibly simple.

Imagine the following scenarios :-

  1. Your system drive is close to filling up, you are not sure why and your Windows Administrator is struggling to locate the problem folder.
  2. You have thousands of databases across many instances on a server and your: -
    1. Data drive is full
    2. Log drive is full
  3. Your Backup drive is getting very full. Backup and archive routines appear to be working.

… and some real-world explanations for those situations that I have uncovered in seconds using this awesome utility :-

  1. A DBA left a long running Profiler trace locally on the SQL Server. It transpired that even though the trace file can be saved on any drive, Profiler unfortunately generates a ever growing temporary trace file locally on the C: Drive until it is stopped (a recipe for disaster!).
    1. A mis-behaving bulk loading process caused a database data file to grow out of control.
    2. A long running transaction prevented the log file VLFs from being truncated and caused it to grow out of control.
  2. DBAs did not follow standards and practices and stored VLDB adhoc backups in random locations.

Remember fixing a SQL Server problem is usually pretty easy in most cases, the hard part is identifying where the actual problem lies. With the best Tool you have have never used, even identifying your space issues becomes a breeze.

Ladies and Gentlemen I give you SpaceMonger! Ensure that you download the old v1.4.0 version located on the Free Software tab since this is the superior release. Now imagine using this on a multi TB disk and being able to zoom into your problem. You will be astounded how fast and easy it is.

The more data you have the easier those problem files are to find!

Posted in database, reporting, SQLServerPedia Syndication, storage, t-sql tuesday, windows | 4 Comments

Lets keep it short – problem creating availability group listeners

Someone once said to me that he thought I should work as a GUI tester since I always seemed to find problems in the UI after I highlighted a problem to him that I’d found in Linux Gnome that he had never seen before after all his years working with the product. I guess there is an element of truth to that statement since I really do like clicking around and trying different things. However I suspect that my latest discovery won’t necessarily be one of those obscure problems that no-one else comes across since it is such an obvious problem and fairly easy to run into.

Whilst playing around with SQL Server 2012 (Denali) Availability groups, I discovered that there is a restriction set on the size of the listener name that you are able to enter through the GUI.

Let me demonstrate…

First I will create a new DNS host name called “readpastandfurious” which you should note is 18 characters long.

create our "longish" DNS host record

And of course there isn’t a problem creating this record since the restriction upon the size of the DNS host name is (I believe 24 characters).

DNS Server will now resolve our host record

Next I decide to create an Availability Group Listener via the SSMS GUI wizard and am very surprised when I can only type in 15 characters! Obviously this text field must have been programmatically restricted since by default the GUI text fields would not be limited.

oh dear we are out of space

My first thought was that it has been restricted on purpose perhaps for an odd NETBIOS reason -if for example NETBIOS was being used for resolution in any way in addition to DNS (daft but possible). Microsoft limits NETBIOS names to 15 characters, so this might have been a plausible explanation.

Next I decide to try and create the full 18 character availability group via T-SQL and I am a little surprised to find that it succeeded with no problems at all!

ALTER AVAILABILITY GROUP [READPAST & Furious Optimistic]
ADD LISTENER 'readpastandfurious' (WITH IP ( ('10.0.5.1','255.0.0.0') ) )

but as I suspected, TSQL is hunky dory

My conclusion then is that this behaviour is almost certainly a bug and was introduced by a programmer who either doesn’t understand the difference between NETBIOS and DNS or blindly assumed that 15 characters is enough?! In any event I believe this is a problem and have therefore raised a connect item for this issue here give it a vote up if you believe you might fall prey to this issue at some point in the future!

Posted in denali, error, gui, sql, SQLServerPedia Syndication | Leave a comment