Blog

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 aContinue reading “Quick introduction to SQL, databases and relational theory — Parv The IT Geek”

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 reasonContinue reading “Book Review: Learn Windows PowerShell in a Month of Lunches, Second Edition by Don Jones — Parv…”

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 wasContinue reading “How to change the collation of a database in SQL Server? — Parv The IT Geek”

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 instanceContinue reading “SQL Server Collations Find current collation and all supported collations — Parv The IT Geek”

Generate random numbers in PowerShell with Get-Random — Parv The IT Geek

Generate random numbers in PowerShell with Get-Random Have 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 butContinue reading “Generate random numbers in PowerShell with Get-Random — Parv The IT Geek”

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 updatesContinue reading “List Hotfixes installed with PowerShell with Get-Hotfix — Parv The IT Geek”

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow My Blog

Get new content delivered directly to your inbox.

<span>%d</span> bloggers like this: