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

Free Tech Event Coming to Chicago April 30th–Code Mastery

by Angela 19. April 2013 13:19

 clip_image001[4]

Magenic is hosting a FREE Code Mastery event at the Chicago Microsoft Office on Tuesday April 30th from 8:30AM – 4PM

Code Mastery delivers high-quality technical content, designed to present you with meaningful and insightful learning experiences. Come spend a day with Magenic's best and brightest - you'll be glad you did. Our featured speaker is Rockford Lhotka, Magenic's CTO, Microsoft MVP, and creator of the popular CSLA.NET framework.

The event is free and food will be provided. Learn More OR Register Now!

Featured Topics:

· Introduction to Web API

· Understanding Azure Mobile Web Services

· Mobile Enterprise Deployment

· ASP.NET with MVC

· HTML5/CSS3/JS

· Effective Design for Mobile Apps

· Integrating iOS with Azure Mobile Services

· Getting Started Building Amazing Windows Phone 8 Apps

Tags:

.NET 4.5 | MVC | iOS | Azure | Mobile development | HTML5 | Windows 8

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.

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