12 Coding tips for my younger self — Parv The IT Geek
Over the years I have written quite a lot of code. These are the tips that I wish I had known when I had started out and would have saved me a lot of head scratching and restless nights:Create a “to do” listPhoto by David Ballew on UnsplashAlways write down your tasks and keep it updated as…
Quick introduction to SQL, databases and relational theory — Parv The IT Geek
Many people find it daunting when they think about Databases and SQL. I know I found it very scary in the beginning and my early experiences with Database developers left me feeling very small and I thought that maybe I was not good enough to succeed in this field.However, I was luckily given a quick…
My top tips for new programmers — Parv The IT Geek
Over the years I have written quite a lot of code. These are the tips that I wish I had known when I had started out and would have saved me a lot of head scratching and restless nights:Create a “to do” list. Always write down your tasks and keep it updated as you work…
Book Review: Learn Windows PowerShell in a Month of Lunches, Second Edition by Don Jones — Parv…
During December I decided to dedicate myself to learning Powershell for the next few months. Many of the blogs I follow and some of my respected peers have recommended the Learn Windows PowerShell in a Month of Lunches book and ashamedly I have owned the book and never gotten past the first chapters.The reason I…
Why you should learn programming — Parv The IT Geek
I remember when one of my friends got a summer job where he was asked to remove certain special characters from filenames and replace it with an underscore. He complained it was boring and tedious but it paid well so he stuck at it.He was expected to do a certain amount of files per hour…
How to change the collation of a database in SQL Server? — Parv The IT Geek
Have you ever wondered how to change the collation for a database in SQL Server?Well the other day I received a database from a third party supplier and the first step was to change the Collation of the database. My questioning about why they would supply the database in the incorrect collation setting was met…
SQL Server Collations Find current collation and all supported collations — Parv The IT Geek
Have you ever needed to check your database or SQL instance to find out its collation? Have you ever wanted to check whether a collation is supported by Windows or SQL Server?Well I am going to show you how to find out the information quickly and easily.The below query will show the instance level collation. SELECT…
Generate random numbers in PowerShell with Get-Random — Parv The IT Geek
Generate random numbers in PowerShell with Get-RandomHave you ever wanted to generate random numbers for passwords, test data…. and wondered how you could easily generate them?Well I was confronted by the same situation on one of our servers where I needed some random numbers for inputting wait times to test an application but didn’t have…
ASCII String function in SQL Server — Parv The IT Geek
Have you wondered what the ASCII value of a character is whilst using SQL Server? Or needed to quickly check the ASCII value? Or wondered how the ASCII Function worked?Well the other day I saw one of the developers using the ASCII function which I was not familiar with so I decided to a bit…
List Hotfixes installed with PowerShell with Get-Hotfix — Parv The IT Geek
Have you ever wondered what updates have been applied to your Windows operating system?Well a quick and easy way to do that is to use the PowerShell command Get-Hotfix. This will list out the description, the HotfixID and when it was installed.I used this on a few PCs where it appeared that updates were not…
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
Parv The IT Geek 