#redgate sql source control

So, had the need of source controlling our views and sprocs (who doesn’t)

We have been trying various methods using one of the billion versions of team foundation server etc. etc.

So decided to try Red Gate Sql Source Control, and use subversion as the back end.

So first off I needed a server spun up…. so time to update my server 2008 template… please wait… ok an hour later got it all patched up. Next I needed Subversion

I’ve never messed with this one before but it says easy install so I will give it a try!

Ok, installation took about 30 seconds… so far I like it! Ok made a repository and started following instructions here

Started downloading a 28 day trial of sql source control

So installed and then linked it to our database. I was too quick as a bunny and didn’t wait for it to sync up. But after it has recorded all the objects then you commit all the objects as new!

This stuff works great, and only took < 1 hour to setup! Awesomesauce



Slow server 2008 r2 box…. did you know

In some cases you may experience degraded overall performance on a Windows Server 2008 R2 machine when running with the default (Balanced) power plan. The issue may occur irrespective of platform and may be exhibited on both native and virtual environments. The degraded performance may increase the average response time for some tasks and cause performance issues with CPU-intensive applications



Some methods of Learning #Qlikview

I’m always looking for ways to increase my knowledge about Qlikview. I really wish someone would write a 1,000 monster Bible on the product but Alas I haven’t found it yet.

Some things I have found:

Books on Qlikview: Hello Qlikview  This is a nice little intro guide to qlikview, this is good to hand to someone who is just starting to get into self service BI using Qlikview.

Qlikview for Enterprises This is a very indepth book about BI, ETL, and practices surrounding an Qlikview implementation. It won’t really help you learn how to script / or design though.

Qlikview 11 Developers Guide This book isn’t released yet (as of 10/9/2012) it looks like it should be pretty good

The next thing that I find very useful is to follow people on the Qlikview Forum and read everything that they post 🙂

For scripting awesomeness you should follow

Henric Cronström and Rob Wunderlich

Speaking of Henric (I wish he would write a book on Qlikview!) you should read all of his Tech documents  I really like

And speaking of Rob you should check out his downloads  he has the awesome Qlikview CookBook as well as the Qlikview Components

I also like to follow Steve Dark all of the qlikviews he publishes are extremely well done and documented.

So, I also like to follow a bunch of Qlikview Blogs.

If you are interested in making Qlikview look Awesome you really need to read everything by

I also like


so, went to #sqlinthecity Here’s my takeaway

Sql in the city @ seattle was great. Got to hear from brent ozar! He was fabulous, everything I could hope for in a speaker. He was very knowledgeable, able to spin questions into the presentation… and finally he was hilarious! He has some cool diagnostics scripts here

If you get one thing out of it, that script is pretty awsome!

Now I also have a bunch of viewing to do here: