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.
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 with PowerShell you will find out that PowerShell commands can return a lot more information than what they show on screen. I will show how to get that information in a future blog post but just be aware that there is a lot more information readily available and only the displayed columns are exported to text(TXT) files.
When exporting to CSV and XML the hidden columns are exported as well. I will give an example of the difference in the exports.
The results of Get-Process are displayed below.
If I run the below commands I would output the results of Get-Process to CSV and XML.
Have you ever wanted to open a file and view its contents using PowerShell? Well I am going to show you how.
I frequently output the results of PowerShell queries into files for later review but rarely used PowerShell to view the contents. This has been because I always had other programs readily available to view the contents easily so never thought to use it. The other day I was on a server where we didn’t have access to notepad and I wanted to look at a file I had generated earlier that day.
I used an old DOS command ‘type’ but saw my colleague who frequently worked on that server use a PowerShell command I was unfamiliar with. He was using Get-Content to look at some files so I used the help command to quickly familiarise myself with the command and once again I was smiling at the beauty and ease of PowerShell commands.
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 take a screenshot but these are way more complicated than simply using the inbuilt functionality within PowerShell.
For example if you wanted to output the processes currently running you would use Get-Process. To output it you would add the below command
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 that I can help identify what maybe causing the problem. However, the problem can be that on a server which is low on resources it may take a long time to open or the opening of task manager may add to the problems or it may not open at all.
This has led me to frequently opening PowerShell and using it to get the information which I need. The script is quite simple and is below.
I have found the advantage of using the script is that it gives me a snapshot whilst in task manager it is always a moving target and if I run it several times I can just scroll up and down to find a pattern which would help diagnose the problem.
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 with the Hello World program in C# which was the first milestone all programmers had to accomplish before becoming programming gurus.
After he downloaded and installed Visual Studio 2012 Express I wrote the below script to show him how easy it was start programming and that he should just practice practice practice.
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, last boot up time and many other properties of various computers. I told him that I had a short script which had that information and probably a whole lot more information which he might find useful.
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 my System Admin was struggling with the restore. He thought he was doing something wrong with the restore and I said he hadn’t done anything wrong and that the database was likely put into that state prior to being backed up and sent to us.
I showed him the below T-SQL which enabled him to change the state to read write and then change it to read only if required.
Make Database Read Only
ALTER DATABASE [YourDBName] SET READ_ONLY WITH NO_WAIT
ALTER DATABASE [YourDBName] SET READ_ONLY
Make Database Read/Write
ALTER DATABASE [YourDBName] SET READ_WRITE WITH NO_WAIT