Clearing the screen in PowerShell — Parv The IT Geek

A quick snippet for some newbie PowerShell developers whilst they start getting their teeth into the ISE is there are two easy ways of clearing the screen. I ahdnt thought about sharing this information but I saw a developer simply closing the ISE so that he could start afresh. I asked him why and heContinue reading “Clearing the screen in PowerShell — Parv The IT Geek”

Opening PowerShell Help in a window — Parv The IT Geek

Have you ever wanted to be able to easily read through the help system in PowerShell? Wanted to take advantage of your second screen whilst developing in PowerShell? Well I am going to show you how. Whenever I have used PowerShell I had a love-hate relationship with the help system. Whilst it helps me outContinue reading “Opening PowerShell Help in a window — Parv The IT Geek”

Update the PowerShell Help System — Parv The IT Geek

Have you ever wondered how to update the PowerShell help system? Wondered how to update it more than once in a 24 hour period? Needed to update the help file of a system not connected to the internet? Well I am going to show you how. Whenever I jump onto any new server the firstContinue reading “Update the PowerShell Help System — Parv The IT Geek”

Find what version of PowerShell is installed. — Parv The IT Geek

Have you ever wondered what PowerShell version your machine was running? Needed to quickly check the PowerShell version to see whether it had successfully upgraded? Well I am going to show you how. Today I was on one of my creaky old SQL Servers when I started doing some inventory checks to see what levelContinue reading “Find what version of PowerShell is installed. — Parv The IT Geek”

SQL JOINS — INNER,OUTER( FULL,LEFT,Right) ,CROSS, SELF — Parv The IT Geek

Have you ever been baffled when people talk about SQL joins? Mystified when you hear inner, outer, cross or self? Ran away in fear at the thought of joining two tables? Well I am about to help you out and face down those fears and explain to you what joins are, the different types andContinue reading “SQL JOINS — INNER,OUTER( FULL,LEFT,Right) ,CROSS, SELF — Parv The IT Geek”

Use SQL to search a column for a range of values — Parv The IT Geek

Have you ever wanted to search for a column for a range of values? For example if you were searching for Product ID which ranges from 1 to 300, or look for a range of names starting A to D. Well I can show you how to do these quickly and easily by using theContinue reading “Use SQL to search a column for a range of values — Parv The IT Geek”

Search for a list of values using the IN command in SQL — Parv The IT Geek

Have you ever been presented with a list of values which need to be found in a column or wondered how to search for a list of exact names, addresses, numbers without using wildcard searches or ranges. Well SQL has the answer and it is the IN command. USE AdventureWorks GO SELECT * FROM HumanResources.DepartmentContinue reading “Search for a list of values using the IN command in SQL — Parv The IT Geek”

NULL Values — How to filter out NULLS and how to find NULLS using SQL — Parv The IT Geek

Well SQL has the solution and our saviour is the ‘IS NULL’ and ‘IS NOT NULL’ commands. Using them in a ‘WHERE’ clause will allow us to do the filtering out appropriately. USE AdventureWorks GO SELECT COUNT(*) FROM [AdventureWorks].[Person].[Address] The above query bring us a result of 19,614 rows contained within the AddressLine2 where noContinue reading “NULL Values — How to filter out NULLS and how to find NULLS using SQL — Parv The IT Geek”

How to order results in SQL? ORDER BY — Parv The IT Geek

A basic query of the HumanResources.Department table bring s the following results. If you wanted to reverse the order of the DepartmentID then you would need to user the ‘ORDER BY’ clause. The default sort is always ascending ( ASC) but it does not have to be explicitly written. If you want the order toContinue reading “How to order results in SQL? ORDER BY — Parv The IT Geek”

How can I find out what SQL Server version is running? — Parv The IT Geek

I was asked by someone which SQL Server version a server was running and was surprised when my DBA colleague said to run a stored procedure I had never heard of. I had not thought that there would be more than one way as the usual method I used below was so simple I didn’tContinue reading “How can I find out what SQL Server version is running? — Parv The IT Geek”