Have you wanted to output results from PowerShell to CSV or XML? Well I am going to show you how. I have previously explained how to export results of PowerShell queries but did not include how to export the results to CSV or XML. The reason for that is that when you become familiar withContinue reading “Output results from PowerShell to CSV or XML — Parv The IT Geek”
Category Archives: Uncategorized
Simple way to output results to a file using PowerShell — Parv The IT Geek
Have you ever wanted to send the output of a PowerShell command to a file? Well I am going to show you how. When you run a PowerShell command like Get-Process, Get-Host…. It will return useful information but sometimes you want to save that information for future reference. You could cut and paste or takeContinue reading “Simple way to output results to a file using PowerShell — Parv The IT Geek”
List active process running using PowerShell — Parv The IT Geek
Have you ever wanted to quickly find the processes running using Powershell? Wanted an alternate to Task Manager? Well I am going to show you how. Whenever I get a call from someone about a performance issue on any of our SQL Servers I always usually have a quick glance of Task Manager so thatContinue reading “List active process running using PowerShell — Parv The IT Geek”
Hello World in C# — Parv The IT Geek
Have you ever wanted to reach the first milestone in programming by writing a Hello World application in C#? Well I am going to show you the script to produce the program. I was asked by a member of our helpdesk team how he could become a programmer. I answered that he should start withContinue reading “Hello World in C# — Parv The IT Geek”
Get the Operating System Properties via PowerShell — Parv The IT Geek
Have you ever wanted to get all the operating system properties of a computer? Well I am going to show you a short PowerShell script which can get loads of information about the operating system. One of my colleagues was googling around for information about how to find the windows directory, number of users, lastContinue reading “Get the Operating System Properties via PowerShell — Parv The IT Geek”
Change a database state in SQL — Parv The IT Geek
Have you ever wanted to change a databases state from read only to read write or vice versa? Well I am going to show you how using some easy to remember T-SQL which you will be using repeatedly over time. We received a database from a client the other day and noticed one of myContinue reading “Change a database state in SQL — Parv The IT Geek”
List SQL databases in SQL Server — Parv The IT Geek
Have you ever wanted to list out all the databases you have on a server? Well I am going to show you how to do it quickly and easily. The other day I had completed a migration from a creaky old dinosaur server to a brand new powerful server which always brings a smile onContinue reading “List SQL databases in SQL Server — Parv The IT Geek”
List of DBCC commands in SQL Server — Parv The IT Geek
Have you wanted a list of DBCC commands to enable you to do a deep dive? Well I am going to list them out for you. Below is a list which complied after a discussion with a fellow DBA who said there were only about twenty whilst I was sure there were way more. WeContinue reading “List of DBCC commands in SQL Server — Parv The IT Geek”
Find todays date & time in SQL Server part 2 — Parv The IT Geek
Have you ever wanted to return the time found in GETDATE or CURRENT_TIMESTAMP to a higher level off accuracy in SQL? Well I am going to show you how. The other day I needed to get the current time to greater accuracy due to the time stamp given to some records and I had toContinue reading “Find todays date & time in SQL Server part 2 — Parv The IT Geek”
Have you ever wanted to convert a US date to UK format using SQL? — Parv The IT Geek
Have you ever come across the situation where you have data in US format and need it changed to UK format? Well I am going to show you how to use SQL to easily reformat the date. I have had this problem several times in the past dealing with international clients who supply databases withContinue reading “Have you ever wanted to convert a US date to UK format using SQL? — Parv The IT Geek”
Parv The IT Geek 