MADPASS Monthly Meeting April 27th (SSRS!)

The third meeting for the Madison Area SQL Server Users Group (MADPASS) is tonight. The talk is about SQL Server Clustering for High Availability.

Meetings are always FREE and food is provided.  Details about the next meeting can be found below.
In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:
5:30 – 5:45 – General Q&A session & Announcements
5:45 – 6:15 – Short Presentation
6:15 – 6:45 – Food & Networking
6:45 – 7:45 – Main Presentation
7:45 – 8:00 – Door Prizes & Q&A Session


Reporting Services 201: The Next Level

You have mastered the art of linking a dataset to a table in SQL Server Reporting Services. You have solid, reliable reports that you and others depend on. Learn how to take them from "meh" to "wow", using features such as tablix, lists, images, and charts.


Wednesday, April 27th, 2011  5:30 PM


Jes Schultz BorlandJes Schultz Borland is a Database Administrator at Kimberly Clark. She holds an AAS – Programmer/Analyst degree. She has worked with SQL Server since 2007, focusing on Reporting Services and day-to-day administration. She is an active member of PASS, the PASS WIT virtual chapter, and MADPASS. She is also an avid tweeter, blogger and runner.


2310 Crossroads Drive
Madison, WI 53718

Park behind the building and walk in main entrance.
Our room will be straight ahead on the first floor.

Live Meeting:
Click here to enter the meeting.

Add Meeting to Calendar:

Click here to add the meeting to your calendar.

We will also be talking about upcoming elections. Cool prizes. Beer. Pizza, and more.

Geeky/Programming Product Reviews

Using Beyond Compare for Compares in TFS and SVN

I love Beyond Compare. Why? First off, their parent company Scooter Software is based in Madison, WI – so that is cool. Second, it is the best damn compare tool I have ever used. I use it for comparing every type of file, folders, folders to FTP, whatever. I love it. Best 30 dollars spent on software. I wish it did more, I could make a wish list.. anyways, to use it to do your source control compares for TFS and SVN? pretty easy.

TFS 2010/Visual Studio 2010

Open VS2010, Tools->Options->Source Control->Visual Studio Team Foundation Server… Click the “Configure User Tools” button


Click Add, and the settings for Compare.. I do .*, and then choose your Beyond Compare locations, and then the args like below

%1 %2 /title1=%6 /title2=%7



Right click anywhere in Windows Explorer, TortoiseSVN->Settings->External Programs->Diff Viewer

Choose External and then

"C:Program Files (x86)Beyond Compare 3BComp.exe" %base %mine /title1=%bname /title2=%yname /leftreadonly


(remove the x86 if you are on 32 bit, add it for 64 bit)


And.. there you go!


Sunday Night Show – The Annex (Madison, WI)

This sunday (Dec 14th), the Band I am in (Saturday Morning Cartel) is playing at the Annex in Madison. We are doing a charity/benefit show. The tickets are 10.00 and it all goes for the cause, which is for a little girl who is having medical problems. It will be my first show with the band where we are playing in Madison, so that is cool.

We also are playing on New Years at the MT Bar in Waterloo.


Big Change #1 – Moving

Since moving to Madison, WI back in November of 2007, not much has changed as far as the living situation. The apartment we are in is ok, and I was planning on not moving for a while. I just counted today and I have moved like 12 times since 1998. Yikes.

The problem is.. our apartment management company, “The Madison Apartments”, aka “Fiduciary Real Estate”, aka “Stoneridge Pointe Condos” decided they wanted to turn our apartment into a condo. You see, most of the places around where we live are condos, and when we moved in, they said NOTHING about our place being converted into a condo.

Fast forward 6 months, we come home and have a letter saying basically “you can buy it, or you can move” which is total BS. On top of that, I asked if we could move out early, since we are being FORCED out. And of course they said no. Greedy, greedy. I really do hope someone run across this post and sees how greedy they are, and that they should look for somewhere else to live.

Anyway, we found some new condos in Sun Prairie, WI which is about 2 miles east of where we live now. These condos have been sitting empty for a while, and no one has even lived in them. We are moving in there next weekend, a bigger place, and just nicer all around.

The funny thing is, the old apartments are changing rentals into condos, and the new place is turning condos into rentals. You would think that these places would be wanting to keep rentals as rentals, especially the way the housing market is. Do they really think someone is going to buy the apartment we are in as a condo? If they did they would really be missing out. Overpriced and really just not worth how much they want for it.

So, #12 move, coming up here soon. This time I am getting smart and hiring movers. I will get a case of beer, and watch THEM move. So worth it.

This is big change #1 out of 3. Stay tuned for the next two…

Life Random

"Leinie's" Going Nationwide. Import or Domestic?

Now that I live in Wisconsin, I guess I have to write about this. Going to school at Saint Cloud State, which is a fairly good party school, you do end up going to happy hour now and then. At the bars there, they always have pretty good deals. “1 dollar for Domestic Taps” etc, etc.

So you walk in, and see that, and ask for a “Leinie’s HoneyWeiss” which is usually on tap in most bars in MN, but then you get a crazy response..

“We consider Leinie’s to be an Import”

WTF? An import? All the way from WI huh, so you can charge 4 dollars a glass? Man..

Anyways, I subscribe to Slashfood in my RSS Feeds, it’s one of my “fun” subscriptions, like xkcd, or gullible info, etc. I read today about “Leinie’s takes small town Wisconsin nationwide” What I have to wonder though, is it going to be served up as a domestic or import? We will just have to see.

As a side note. I wish Madison WI’s cool blog site Dane101 would let you submit stories. This is a trackback to them to see if they see this and take note.


Google Maps Street View comes to Madison!


Although, not as exciting as my street view in Portland, I live way back in the apartments in the back. No street passes by it. Although this is pretty cool. Good way to find your way around, or at least not get lost. But remember, Google Maps gets you lost!

Blogging Life Random

Madison Blogger Meetup

Trying to get a Madison Blogger Meetup going. There is a Facebook group here:

Hopefully next week (Thursday  Feb 21st, at Mickey’s Tavern)

Everything is subject to change at this point 🙂

On an unrelated note, Obama is in Madison tonight, at the Kohl Center. I got called 3 times to go and twice to go by people here. I am not going, I will watch it streaming online and watch MSNBC for the Chesapeake Tuesday results 🙂


Madison Differences #4 – Coffee Shops

Ok, another big difference from Portland. The coffee shops in Madison are few and far between, and there aren’t many Starbucks around, and if there are, they are drive thru, or at Target. And the east side of Madison is really low on coffee shops..

I have been to a couple of shops on the east side:

Cool Beans – This is located within the East Towne mall area roads. It is a bigger place, as big as a normal Starbucks. It has a fireplace which is cool, and it seems normal enough. My EVDO card worked so I didn’t try the Wifi, but the downside to Cool Beans is that there is like 1 (maybe 2) outlets available, and there are a lot of just “cushy” seats, like not useful for using a laptop. Coffee shops should have outlets at every table! The good thing is that it is pretty closet to my apt, but I think Beans ‘n Cream’s east Madison location is actually closer.

Beans ‘n Cream – I have been the the Sun Prairie location. It was nice, a little far to drive from my apt every day. It was hot with a fire going. The kicker though, my Verizon EVDO card got a weak or no signal, and it was on National Access (read: slow) so it was worthless. I tried out their wifi, but it isn’t open. You have to go to the counter to get a 60 minute pass, they print you off a user/password. Kind of odd, I didn’t like it. I will try the east Madison location, hopefully my EVDO card will pick up Broadband Access (read: fast) – I walked by the east Madison location, and there seemed to be less seating. One thing is that there were some outlets (always a good thing) at both..

Starbucks – ? Non-existent in Madison. There are a few, but the parking sucks, or they are drive-thru. They are mostly on the west side, and I am not driving 30-45 minutes to go there. The closest one to me is at the East Towne Target, and there are NO outlets – WTF? I mean I would go to Target and just try it and see how it went, but no outlets? It is hard enough to find one at a regular shop that isn’t being used. I guess they don’t want people with laptops to show up and stay for a while (I actually think the Starbucks at Target is ran as a different type of franchise than a regular Starbucks).

Overall? Well, I don’t even drink coffee (I do but not often) – so it really isn’t about the coffee, it is about the atmosphere for me, and the standardization (outlets, fireplace, places to sit, etc) – usually I am just getting hot chocolate… I do miss the bagels at Wired on Burnside though, and the coffee 🙂

Technorati tags: , , , , , , , ,

Madison Differences #3 – The Roads Suck (Report a Pothole)

Stumbled across this site –

You can report potholes in Madison. First off, can I just report an entire road? All of 151/East Washington/University from the Interstate to Middleton. And then how about every road surrounding the East Towne Mall. Add into that just about every side street in town.

I swear the roads in Madison are the worst I have ever seen. It would be better driving on dirt roads, at least townships have to grate them every once in a while, so they are driveable. I hope my car survives Madison roads – and I don’t even drive that much!

Report Pothole Link via

Technorati tags: , , , ,


Madison Differences #2 – Craigslist/Citysearch/Local Papers

One big difference between Madison and Portland is that it is tough to find stuff in Madison, unlike Portland. Portland is a big enough city where it has its own Citysearch and Craigslist is used a lot more. Madison just fits into the “National” citysearch, and craigslist is pretty empty.

Portland as the Mercury and Willamette Weekly, and other local papers, and really the only one I have seen here in Madison is the Isthmus, and there is a Madison magazine as well, but there are slim pickin’s, even in online zines or blogs in Madison. Smaller city = smaller footprint I guess…

Either that or I just haven’t found the hidden gems yet 🙂

Technorati tags: , , , , , , ,