0

VS Live is Coming to a City Near You! We Can Save You $500 in Chicago and Vegas

by Angela 24. February 2014 10:13

 

Have you been considering attending VS Live this year?  They are really expanding their locations this year, holding events in Orlando, Redmond, Las Vegas, Chicago and even Washington DC. It’s a great event both to network with like minded technology geeks like yourself, as well as to get some great education around a HUGE number of topics.  Once again, the Chicago ALM User Group has secured a special discount code for members and friends for a couple of these events. So if you were wanting to attend, now we can even save you $500 with our exclusive discount codes: UGCH09 (Chicago) and UGLV10 (Las Vegas).

Topics will include:

➤ Windows Client

➤ JavaScript / HTML5 Client

➤ Azure / Cloud Computing

➤ Cross-Platform Mobile

➤ SharePoint

➤ SQL Server

➤ ASP.NET

➤ Visual Studio / .NET

➤ Windows Phone

 

$500 Discount off regular registration price for ALMUG friends and family using discount codes below.  Discount does not stack on top of early bird discounts. Prices range from $1,795 - $2,095 without the discount.

Your price: $1,595 after discount

 

Chicago Event Links

May 5-8, Chicago Hilton

VSLive Chicago homepage: http://bit.ly/UGCH09

VSLive Chicago registration page:  http://bit.ly/UGCH09Reg

Las Vegas Event Links

March 10 – 14th, Planet Hollywood

URL will direct to event home page: http://bit.ly/UGLV10

URL will direct to the registration page: http://bit.ly/UGLV10Reg

0

Chicago Visual Studio ALM User Group Meets July 31st

by Angela 15. July 2013 12:40

It’s that time again! We’re meeting on July 31st at the Aon Center in downtown Chicago to talk about one of my favorite features of the 2012 toolset, database management with TFS!  You can do some pretty slick stuff with the latest set of free data tools.  That’s right, they are FREE now.  Here are some more details on what’s being covered:

Abstract: One of the trickiest parts of ALM is tracking changes to database schemas related to building and deploying a particular release. The tooling from Microsoft once again changed in 2012 with the replacement of Visual Studio Database Projects (aka “Data Dude”) with SSDT. This hands-on presentation will discuss how to convert from previous versions of Visual Studio Database Projects as well as reverse engineering a schema from an existing database. The presentation will also look at changing and refactoring the database and how to incorporate the tool into the build and deploy cycles.

Speaker Bio: Daniel Sniderman is an Associate Principal Consultant for Magenic, one of the nation's premiere Microsoft Gold Certified Partners. Dan first learned to program FORTRAN in in the late 70’s using a keypunch machine and has thirty years of experience in software development. Since 1993, Dan has specialized on developing business applications on the Microsoft platform. Dan has worked at Magenic since 2004 specializing in customer software development and ALM consulting. In addition to a BA from the University of Illinois, Dan has a MCSD.NET and MCTS in Team Foundation Server 2010. Dan also is a professional trombonist performing regularly with the B.S. Brass Band and The Prohibition Orchestra of Chicago. Dan has two children: Joella age 7 and Elijah age 2.

Date:              Wednesday July 31st 2013

Location:         Microsoft-Chicago 200 E Randolph, 2nd Floor, Chicago

Agenda:          6:30PM Dinner followed by a presentation and demo at 7pm

Registration:      http://chicagoalmug.org/

As always, please be sure to register as Aon Center security will NOT allow individuals to access the building without being pre-registered.

Tags:

development | database management | Visual Studio 2012 | Visual Studio | Team Foundation Server | TFS 2012 | SQL Server 2012 | SQL Server | SDLC | SDET

0

Are you managing your database along with your source code? Why not?

by Angela 23. April 2013 17:17

This is both a call to arms and a last notification of the awesome topic being covered at the Chicago Visual Studio ALM User Group tomorrow night.

In my day to day dealings with companies I often find that they are not managing their database in any way  ::commence slow head shake:: And in my head I am screaming while I politely smile and calmly ask how they keep track of database changes, how they test updates to the schema, and what their rollback process is. Some companies do actually have some solid processes around those types of things, but many have nothing but a rosary and a case of Redbull. They just backup their servers nightly, and rolling back changes is a nuclear option. There is a better way people!

Ideally, you have you database schema, and any executable database code checked into SOME source control management system. By which I mean you have the SCRIPTS necessary to create those things in source code (see screenshot below). Without a good tool, establishing that can be tedious, daunting, and usually isn’t done, period. One of the things I love about Visual Studio  is its slick handling of database asset management (which has been around since VS 2008). In no time at all you can reverse engineer a database schema and all dependent objects into a database project in Visual Studio and check it in. Yes, just like that. That’s of course just the beginning but I’ll keep this soapbox rant short and expand in future musings.

The tools get better and better with each new version and the SDET tools that plug-in to VS 2012 are the best yet. Here is a quick preview of what that experience looks like in Visual Studio 2012.  I am running Ultimate but you would have the same look and feel in just plain old Professional as well.

image

 

Now if you are still a hard core SSMS user, fear not. You can still get some of the awesomeness of TFS working for you in SSMS, but finding out where to set that up can be tricky. Quick tip, if you already have TFS installed at your company, really you just need the TFS connector and to flip the switch

image

And now for the info on the user group, there’s still a little time left to sign up. Do it, DO IT NOW!!

Visual Studio and TFS 2012 for managing your SQL Server Database Assets

Do you have SQL Server database assets you should be managing? If you have a SQL Server database you certainly do! Do you use TFS to manage your other software assets like architectural diagrams, source code and build scripts? Are you using that same great toolset to manage your SQL scripts?  If not, you SHOULD be.

Did you that know some of the same great ALM features that you love about TFS for your source code can be applied to SQL 2005/2008/2012 stored procedures, table definitions, functions and other schema objects? And that's not all, there are also tools for doing schema comparisons, static analysis, unit testing and deployment of your database assets.  Jim will be giving an overview of the database tools available with VS and TFS 2012.

This is a meeting NOT to be missed.

Join Us Wednesday, April 24, 2013 from 6:30 PM to 8:30 PM
Location:Microsoft-Downers Grove 3025 Highland Pkwy, Ste 300, Downers Grove

Speaker Bio: Jim Szubryt is the TFS Product Manager for the Enterprise Workforce at Accenture in Chicago and is a Microsoft ALM MVP. His TFS Team supports 2,500 developers in the global development centers and works with teams on implementing ALM processes. His blog can be found here.

Agenda:6:30PM Dinner followed by a presentation and demo at 7pm

0

ThatConference – Mark Your Calendars and Call for Speakers is OPEN

by Angela 1. April 2013 16:43

So as a Midwesterner I often feel like we get screwed when it comes to big, cool tech conferences.  ALM Summit is always in Redmond, TechEd is always in Vegas or L.A. (blech), and there are a large number of other big tech conferences that are primarily only held on the West Coast (Mix, VS Live, etc.). So this big news so far this year has been that VS Live is coming to Chicago in May, for one. I’m pretty excited about that, especially with the sweet discount I was able to get for it (see the blog post I linked to above for a $500 discount code to VS Live Chicago). 

Now don’t get me wrong, we have a lot of great, smaller conferences, for instance Chicago Code Camp in a few weeks, and Deeper in .NET in Milwaukee next weekend, are both very good conferences and are both FREE to boot. But another awesome conference you may have missed out on last year was ThatConference. What conference? ThatConference. Yeah, I know, the name is clever, and sometimes confusing, but mostly clever.  It is the next big thing in my opinion, because not only is it owned by, organized by, and delivered by people you know from your local community, but the range of topics is pretty amazing too.  .NET, Ruby, Java, iPhone, Android, Windows Phone, Tablet, Surface, iPad, you name a technology/platform and it is probably going to be represented there.

As an added bonus, it is a VERY family friendly conference being held at an awesome water park in the Wisconsin Dells, just 3.5 hours from Chicago if you live in my neck of the woods.  Kalahari Resort also has go-karts, laser tag, a large arcade, an indoor ferris wheel, a number of great restaurants and bars, and even a salon and spa if you need a little R&R with your tech!  Stay a few extra days, the room rates are amazing and last year we also got some pretty nice perks (a.k.a. free stuff) from the resort because we were attending the conference.

Call for speakers just opened today and is only open for 2 weeks so hurry up and get your submissions in! Don’t worry if you think your topic is too broad, too niche, too whatever, just get it in there.  There is a great submission guide available on the session submission site too so check it out! The range of topics being accepted is pretty large, as we hope to provide a really well rounded set of options for attendees.  If you have more questions, or would like some help creating your session write-up, join us every Wednesday at noon CST for Q&A on G+.

 

Hope to see you, and your sessions, at ThatConference this summer!

August 12th - 14th, 2013

Kalahari Resort, Wisconsin Dells, WI

 

ThatConference is also on facebook, or Google Groups if you have questions or comments for the world at large.

2

Installing TFS 2012 on SQL 2012? You might run into some problems

by Angela 9. January 2013 05:27

So, like all TFS upgrade projects I work on, I got a last minute request that added a major wrinkle to our neat little TFS upgrade plan. “Can we just use SQL 2012 SP1 instead of SQL 2008 R2 SP1 for TFS 2012? It shouldn’t change anything right?”  FAMOUS. LAST. WORDS. Notice they were not MY words. I had the foresight to say that no, it absolutely WOULD change things because I hadn’t based any of my estimates or my plan of attack on upgrading the DT software to a new major release. And I also stated that while it was a supported configuration for TFS 2012, since no one here had validated that SQL Server 2012 SP1 would work on their custom VMWare implementation, anything could happen and so my estimate and plan was out the window. It was supposed to be a quick, neat, in-place upgrade that required almost no patching or updating OTHER than TFS itself. And then they decided they wanted to be on the latest and greatest everything all at once. Awesome. That always goes well.

So as I expected, everything went smoothly UNTIL we got to the part where I upgraded SQL Server 2012. So let me back up in case you are wondering how I got to that point… I pinged some colleagues on the TFS product team to verify that I could more or less follow my original plan, but work in an upgrade of the SQL Backend to SQL 2012 along the way. We came to the conclusion that to minimize risk and isolate sources of potential issues, that I should follow my original plan and upgrade to TFS 2012 on SQL 2008 R2 *first*.  Then after I verified that configuration was working properly, I would upgrade the database to SQL Server 2012.  I had a plan, and lots of caffeine. I also had this awesome blog post to reference from Martin Hinshewood with some helpful nuggets in it too.  This might even work…

The upgrade to TFS 2012 on SQL Server 2008 R2 went without a hitch. In case you are curious, they are on SQL Standard x64. I was able to hit the server, fire up the collections, connect to Team projects, SharePoint and reporting.  I followed the advice of many blog posts and started with the SQL 2012 Upgrade Advisor.  The only issue I ran into there was that I had to install .NET 4.0 and a specific prerequisite. I love, LOVE when error dialogs give you links that you cannot click on or copy and paste into a browser too. So helpful SQL dudes! So here you go:

clip_image002

http://go.microsoft.com/Fwlink/?LinkID=216742

Once I thought I had all my prerequisites in order (wait for it), I ran the upgrade advisor tool, counted my green check marks, and started the upgrade to SQL Server 2012. Somehow the Upgrade Advisor DIDN’T make sure that SQL 2008 R2 SP1 was installed before it let me waste 30 minutes walking through dialogs

image

Once I got past that installation, the SQL Upgrade finished without another hitch.You will need to restart the server again, but since TFS has been down the whole time anyway it’s not like it matters at this point. Then I started the SQL 2012 SP1 install and it got 99% of the way through the install and ::insert sad trombone:: “The NT service ‘MsDtsServer110’ could not be started”. Who did what again? I searched on it exactly as stated, and SHOCKINGLY got nothing useful back. Again, AWESOME.

image

 

After a bit more digging I found some telling information in the event log under System Events:

image

The service account does not have the required user right “Log on as a service.” So the NT Service\MsDtsServer110, which I have no knowledge of through past experiences, is missing a permission and so SSIS keeps failing. I was unfamiliar with the Service account “NT Service\MsDtsServer110” so did some digging around to see what popped up in regards to SQL 2012 installs.  Finally hit a TechNet post that described my exact issue.  For whatever reason, most of the SQL Services run as Network Service, (or some other known service account), but the SSIS service runs as this new guy in SQL 2012, and due to local domain security policy here at this client (just like the article warned), my Setup account was not allowed to provision that account properly.  So we followed the article’s advice for a workaround, reset the logon account to a known service account, started up all the services for SQL Server, and was able to complete the TFS 2012 DT upgrade. WHEW!

So, lots of potential gotchas, none of which were TFS or SQL’s fault, but since most of my friends work for large corporations with complicated rules about access and domain policies coming out of their ears, I thought this might be helpful. Hope it was!

Tags:

ALM | Application Lifecycle Management | MSDN | SDLC | SQL Server 2012 | Team Foundation Server | TFS 2010 | TFS 2012 | TFS Administration | TFS Upgrade | Visual Studio 2012 | VMWare

Powered by BlogEngine.NET 2.7.0.0
Original Design by Laptop Geek, Adapted by onesoft