What would you like to learn or for me to talk about?

Hi all.

Just a quick blog post to say that I would like to thank everyone who has visited this site, sent me emails or comments on social media. It makes all my efforts worthwhile and further motivates me to continue blogging.

Now I would like to reach to everyone and find out what they would like to learn more about. This helps me to cater for my audience and give me new ideas for future blog posts.

Thanks once again to everyone and have a great day.



Jan Theme for Learn SQL Free – Programming / Control of flow elements of T-SQL

After a short amount of thought about what would a be a cool theme for January I decided that a series of posts on the Programming / Control of flow elements of T-SQL.

I will try and cover all of the below commands this month which cover almost all the programming elements of T-SQL.

GOTO label

and the dreaded but often very useful CURSOR

My plans for 2015

Hi to all my readers.

I must confess that my Blogging has suffered during the latter half of my wife’s pregnancy and the first five months of my newborn baby girl’s life.

I have had grand plans about Blogging about Powershell, C#, SQL Server and Python each and everyday but my own unrealistic expectations have come back to roost and I have not really done anything for several months. I have procrastinated on so many things like changing the WordPress theme, email sign up form…. that I have decided that I must now be more honest and committed to growing this Blog.

My plans for 2015 are

  • Blog at least once a week
  • Promote my Twitter and Facebook page
  • Convert all my posts into Youtube videos
  • Try and do a at least one themed month of Blogging. I am thinking of something like a month of Powershell one liners, 31 days of DMVs etc.


ABC The best trait of a SQL DBA

Have you ever wondered what the best trait all super SQL DBAs possess? Well I will tell what the best trait is and an easy acronym to remember it.

I had a conversation with one of my colleagues we talked about the different DBAs and System Admins in the company both past and present and he asked me what I had learned having met them all.

It was an easy answer and I replied my ‘ABC.’ He looked perplexed and then I told it him what it stood for.

ABC = Always Be Checking.

As a DBA I see myself as the protector of the data and liaison between users, developers and system admins to ensure that everyone is happy.

The only way I can do that is to follow the ABC.

Check backups

Check SQL jobs

Check database mirroring

Check SQL Logs

Check for unused indexes

Check SA password

Check index suggestions and liaise with developers to implement them and maximise their potential

Check with application managers that users are having a good experience connecting to the database


Along the DBA journey there are many problems which you will face and many of them can be fixed at source by following the ABC mantra.

If you don’t want to follow the ABC mantra then you will always find yourself reacting to situations rather than managing them.