Hello!
I’ve posted some scripts and other (hopefully) useful tips and tricks for PowerShell scripting. However, I’ve never told you about PowerGUI. Microsofts editor is very simple and is just fine, but PowerGUI takes PowerShell scripting to a whole new level! It’s free, easy to use and there are a lot of youtube videos out there showing you how to utilize it’s best features. You can get it here.
Also; the PowerGUI site also has a big library of PowerShell scripts for you to use.
I’ve previously posted about deadlocks in MSSQL and figuring out the process creating problems. However; deadlocks is only a tiny bit of what can be bottlenecks in your setup. I found this tool some time ago which could analyze trace files and suggest where your bottlenecks are. It’s called SQL Nexus, is open source and available here.
Another tip would be to run Microsofts best practices analyzer. If you’re not sure if your setup is according to best practices, it can be a real help!
Links for: SQL 2005 and SQL 2008 R2.
Welcome to my blog!
I’ve always thought blogs were a bit weird, but I’ve found that some are actually quite useful. There’s a wealth of information out there, and this will be my tiny contribution.
I work in IT, and have always been interested in technology. Here I will post whatever I’ve found to be useful information when i faced a problem, or just post stuff I find cool.. Like Piwik! Advanced web analytics rapped in a nice UI. Open Source and Free.
Here’s a pic!
There isn’t much traffic recorded yet, so it looks pretty empty, but you get the idea 
