Posts

SQLDIAG and PSSDIAG

Most of the time I work with SQL Server 2005 when I need to collect statistics and create a nice looking html document with #PerfMon stats. In that case I run SQLDIAG with detailed statistics enabled. Command at the prompt is: SQLDIAG /i SD_Detailed.XML. This time around I was asked to run a performance report on a SQL 2000 Server. It's been a long time since I've done any work of this type so here are a few things I've learned from working with it. Apparently SQL 2000 doesn't support SQLDIAG. In that case I need to run PSSDIAG. You may ask why do I need to run either one, there are other tools available. Well, SQLDIAG and PSSDIAG create a .BLG file that I can feed into PAL tool that will create a really good html formatted document with plenty of information on performance. Well, my problems started right away. It is not as flexible as SQLDIAG and I stopped taking 2005 for granted after I've messed around with PSSDIAG for 2000. Apparently I need XML parser SP2 to r...

Update on get-process | kill

Got replies on #twitter by @jsnover, @r_keith_hill re: get-process | kill command. It is fixed in #powershell v.2, will only kill user- specific processes. Will test in Windows 7, also was told to use -whatif tag. -whatif tag tells you what the command you're about to run will do. Now that's neat! Thank you fine gentlemen for your help. Twitter is a wonderful tool! --Artem

Never do this in PowerShell!

I was playing with #powershell the other day and found this "neat" trick. If you type "get-process | kill", it will reboot your box i.e. kill all running processes. Goes to show how important it is to know what you're doing with #shell. Use at your own risk! -- Artem

New feature in Ubuntu 9.04 Jaunty Jackalope

If you go to Terminal in #Ubuntu 9.04, and type "screen" no quotes, you will get quick info on CPU, Memory and some other info. Pretty neat! I heard this on LinuxOutlaws podcast. -- Artem

Run Powershell Inside Cygwin

Image
#Cygwin in simpler terms is a bash shell for #Windows.  You can run all your favorite bash tools like #rsync, #ssh, etc in cygwin. Turns out, you can run #powershell also. Yes powershell! Simply type “powershell” in cygwin, no quotes, and you will enter a powershell environment. Else, you can type a full command like this >powershell “get-eventlog System”. At the end you will be brought back to bash shell. In the first example you will stay in powershell. One caveat though, I don’t see tab completion in cygwin and file names are case sensitive, so you must specify the names exactly how they’re defined. ______________________________________________________________________

New Ubuntu Look

Image
Jaunty is out of the door and first traces of Mark Shuttleworth's promise to bring a beautiful OS that can rival Mac OSX are surfacing. I must be honest, when I upgraded I installed ubuntu-restricted-extras with Microsoft Fonts, but I never did enable them. I ended up using default fonts. These fonts are easy to read and really do look cool. Themes that are shipped with 9.04 are also great. The one I ended up using is called "Dust Sand". It looks a little like OSX theme but it is different. I prefer it over the default "Human" theme. Slight opacity is also a nice touch that comes with this theme. I really dig it..

Newly-found Gems

There were a lot of changes to my podcast collection since the last time I talked about them. I recently found Knightwise (KWTV) and Category5 TV. These two podcasts concentrate on users and provide really good tips and resources for people learning Ubuntu and other software. Knightwise has a really good attitude and blogs from Belgium. You can also find him on Facebook. Category5 TV is another great resource. These guys are in Canada and I found them when they were featured on Ubuntu UK podcast. What I don't like about Category 5 tv is that you need to register on the website and go through a few clicks to get through RSS feeds. Once you do though, you have a lot of choices to pick from. For the people with a lot of time, I suggest to subscribe to a full feed. For the short attention span people like me, I am going for the meat, that's what it is called. However, if you subscribe in iTunes, there is no feed h.264 feed for iPhone yet. So you should settle for Miro for now. I pr...