Posts

Showing posts from October, 2014

SQL Server uses a lot of memory

Here's a little work around for SQL server which uses a lot more memory than it should. Naturally, you can set this through the properties of the instance it self. however, since this is a bug in microsoft sql server 2008 (r2?), this script is a workaround.

Powershell - Create 100 AD users

Hi, I had the need for 100 users for a test environment i was building. So heres the powershell script that i used to create them.

Changing keyboard layout / language in powershell

To change keyboard layout in powershell use the following command:

FreeNAS Hyper-V Netword Card Issue / Problem

I had to install a FreeNAS. This was done through hyper-V. The problem though, were, that FreeNAS wasnt able to see the network card.  This is the workaround:

Powershell - CSV Column Manipulation

Image
If you want to change a csv file, there might be easier ways than open it in excel and edit / remove the columns that you dont need. In this example. I had to extract all the Latitude and Longitude from earthquackes the past month. This was a somewhat 10 000 line long file. So why not try it in Powershell. Headers looked like this   time,latitude,longitude,depth,mag,magType,nst,gap,dmin,rms,net,id,updated,place,type

Popular posts from this blog

[SOLVED] Veeam: Failed change tracking (CBT)