2017 Blogging Plan

This year I am going to get back to blogging regularly and this time I really mean it. I have neglected to blog regularly due to procrastination and not being happy with most of the blog posts I had written. I will try to blog at least every fortnight and will, subject to my work and family, try to blog more often. This schedule should be easy to maintain and not become a burden and lead to me going on another blogging sabbatical (hiding he he).

This year I plan on levelling up my PowerShell, C# skills and learning more about Cyber Security.

I have seen some of the cool stuff some people are doing with PowerShell and would love to automate everything in my life. This will free me up to do more Production DBA work and enable me to increase my project workload. I hope that I can try and produce some scripts which I can add to the DBATools.io project and give them back something for their awesome community work.

My C# journey is mainly so I can increase my programming expertise and I want to try and take part in some competitive programming and undertake some programming challenges. Currently my knowledge level is insufficient to do this but I want to learn more and hope that learning design patterns, algorithms and object orientated programming will let me fill in these gaps and allow me to have some programming fun.

Lately I have become interested in Cyber Security as I want to understand both the methodology used by hackers and the people preventing them. I find the mindset, creativity and folklore around all of this to be fascinating and hope that I can learn a few things along the way.

I hope that my audience will enjoy my 2017 journey and will help keep me accountable.

Thanks for your support.

Ruby Challenge update

Hello all.

A quick update on my Ruby Challenge.

I am half way through the One Month Rails course and I am really enjoying learning Rails programming.

I have found Ruby to be a quite intuitive and easy language to pick up. I have already started looking at creating a few simple apps which have always been on my mind.

I am hoping to try and finish the course by the end of next week and hopefully start Michael Hartl’s course.

Hope everyone has a nice weekend.

 

 

 

 

 

Ruby Rails challenge

I overheard a conversation the other day in the office about some of my colleagues all challenging themselves to do an Iron Man race as they always wanted to do it and they thought it would be fun to do it as well.

This got me thinking about my own dreams and challenges I could set for myself. Whilst an Iron Man competition sounds fun it doesn’t appeal to me and I have thought about what I could do in a short period of time to both experience something new and to learn and grow.

I have always had a niggling desire to create apps and my existing knowledge of  C#, Python, SQL and PowerShell has been primarily geared towards solving administrative tasks rather than creating programs. After a short deliberation in my head I have decided that I will start knocking out a few apps over the next few months and hopefully share any knowledge I have picked up  over that time.

A quick Google around showed that there were two ways to go to fulfil my goal and those were Ruby & Rails or Python & Django. I know there are pros and cons to both options and didn’t want to get stuck in that malaise so I have chosen the Ruby & Rails route.

The two reasons for choosing Ruby & Rails is because its shiny and new for me and there appears to be a growing community of users which I would like to be a part of and the other reason is there is a meetup local to myself for Ruby programmers which gives me less than a month to learn the basics of Ruby programming and to produce at least one rudimentary app.

I have signed up to onemonth.com for their Rails program and will do the Ruby on Rails Tutorial by Michael Hartl on SafaribookOnline.com which should give me a firm foundation and hopefully I will be able to contribute in that meetup.

I will post regular updates about my progress and hope this public announcement will keep me accountable. Also, I probably be posting a whole load of Ruby & Rails related blogs and hope that everyone finds them enjoyable and informative.

Now I want to turn the tables and ask all my readers what they will be doing over the next few months to learn, grow and most importantly have fun.

 

 

2015 My first review

I am just writing a quick blog review for my 2015 plans. I know that its a bit early for a review but I have always believed in the saying ‘If one does not know to which port one is sailing, no wind is favorable.’  Therefore I am just making a minor course correction to ensure my goals have been met.

So far I am keeping to my plan of blogging at least once a week and finding that not trying to keep to a daily posting schedule has kept me more motivated to produce content for my blog.

I have connected my blog to my Twitter account, Facebook fan page and Linkedin profile which is promoting my blog and hopefully I can help spread my knowledge.

My plan of converting posts to YouTube videos hasn’t progressed very far as I haven’t

 

  • Blog at least once a week

 

So far I am keeping to my plan of blogging at least once a week and finding that not trying to keep to a daily posting schedule has kept me more motivated to produce content for my blog.

 

  • Promote my Twitter and Facebook page

 

I have connected my blog to my Twitter account, Facebook fan page and Linkedin profile which is promoting my blog and hopefully I can help spread my knowledge.

 

  • Convert all my posts into Youtube videos

 

My plan of converting posts to YouTube videos hasn’t progressed very far as I haven’t checked any software out but will do it later in the month.

 

  • 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.

 

My first month of themed blogging has started off to great success and I hope that I can do more of these each month.

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

Etc

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.

Welcome to my FREE SQL blog – Learn SQL Free

Hi everyone.

My name is Parvinder Nijjar and I work as a  Microsoft SQL Server Database Administrator (DBA).  I am certified at MCITP level for SQL Server and have almost seven years of experience with Database technologies.

I have a huge love of Windows Server, SQL Server, C# and PowerShell. I hope that through this blog that I’ve created I can help spread SQL knowledge to everyone so that they can improve their SQL knowledge and become better data professionals.

Throughout this blog I will share my knowledge and experiences of Indexing, Policy Based Management, Replication, Mirroring, Clustering, Log Shipping, Backup and Restore, SQL internals, Security, SSAS, SSRS, SSIS best practices and programming.