0

Chicago Suburban SQL Server User Group - June 2017 Meeting Announcement

by Angela 6. June 2017 15:54

Just wanted to share an event that I’ll be speaking at later this month, it will be my first time ever with this group so I’m excited to be able to meet a bunch of new tech-minded folks in the Chicago area! I’d love to see some familiar faces as well, and who among us doesn’t need better database skills? Polaris Solutions is also sponsoring this meeting, so dinner is on us Smile

Chicago Suburban SQL Server User Group
-------
DATE:

Tuesday June 20, 2017

AGENDA:
5:30PM - Doors Open
6:00PM - Meeting Start with Dinner, Networking, & Open Q&A (bring your questions!)
6:30PM - Announcements, Sponsor Presentation, & Main Presentation

REGISTER:
https://www.eventbrite.com/e/chisub-ssug-june-meeting-tickets-35162771797

TITLE: Fear and (Self) Loathing in IT – A Healthy Discussion on Imposter Syndrome
ABSTRACT

Many of us feel nervous or fearful about raising our voices or speaking our opinions out loud - whether at a business meeting, a team retrospective, a conference, or even from your cubicle chair. We sometimes feel hesitant to fully engage with our team and be ourselves lest we be “found out” as someone who really doesn’t belong, isn’t smart/experienced enough, or who doesn’t deserve to be there. If you’re wondering what Imposter Syndrome is, or how you would even know if it affects you or a team mate, think about the following questions:
* Do you feel like no matter how much you study or prepare for a new challenge, that you’ll just never be ready for it and that people are crazy to even trust you with real responsibilities?
* Do you panic at the idea of asking for help when you get stuck on a challenging problem because everyone will think you have no idea what you’re doing? 
* Do you continually beat yourself up about minor mistakes that likely no one else even remembers, or noticed in the first place?
* Are you constantly comparing yourselves to peers, friends, or event Twitter followers and finding that you just never seem to stack up?
If you answered yes to any (or maybe all) of these questions, you might be experiencing Imposter Syndrome. You may even recognize some of these behaviors in loved ones, coworkers, and friends. And it’s not silly, trivial, or something you’ll “just grow out of”. Many people have been experiencing Imposter Syndrome since childhood. But when does this anxiety become unhealthy? Is Imposter syndrome something we really even NEED to cure? I’d like to share some of my own adventures in embracing my fears, learning to trust myself and others, getting comfortable with asking for help, and developing shame resilience. I’ll also talk about the unexpected and very positive outcomes that followed taking the leap to embrace my “phoniness”.
So whether your roles in life include team lead, manager, scrum master-in-training, tester, project manager, significant other, and/or parent - recognizing Imposter Syndrome in yourself and others and knowing how to thrive with it is an important skill to develop!


SPEAKER BIO:
Angela Dugan is a Principal Consultant for Polaris Solutions, a software technology and agile/DevOps process consulting firm based in Chicago. Her focus as a Principal Consultant is supporting her clients in increasing their agility and improving their DevOps capabilities through training and coaching their people, streamlining their processes, and implementing modern automation and collaboration tools. Angela has been in the software industry since 1999, is an active tech community contributor, and organizes a number of local meetups and conferences including IAMCP Women in Tech, Chicago Code Camp, ThatConference, and St. Louis DevUp. She is a Microsoft ALM MVP, a Certified Scrum master, and a SAFe Program Consultant.
Outside of wrangling organizational transformations, Angela is an avid board gamer, an accidental Crossfitter, an aspiring crafty diva, and a Twitter addict. She is constantly working on her 1910 house in Oak Park with her husband David, where they raise two ornery chickens Betsy and Gertrude and a rambunctious GSP named Sadie.

Tags:

SQL Server | Imposter syndrome | SQLPass

0

Free eBooks on Azure From Microsoft Virtual Academy

by Angela 18. May 2015 08:10

I was just lamenting that I needed to get caught up on Azure stuff, and then saw this amazing tweet from Scott Guthrie:

@scottgu: I just realized there are a bunch of *free* Azure eBooks now available to download through Amazon or online: http://t.co/g5ofSNUWJg

Whoa! It’s like they HEARD me. Creepers.  Anyway, there are a ton of free eBooks available, and some also have Kindle downloads too.  And not just Azure!  You’ll find books on System Center, Windows 10 Preview, Xamarin, SQL Server 2014, and lots more!

You can find the entire catalog of free books here, but below are the ones I am most excited about:

Microsoft Azure Essentials: Fundamentals of Azure: The “Microsoft Azure Essentials” series helps you advance your technical skills with Microsoft Azure. “Microsoft Azure Essentials: Fundamentals of Azure” introduces developers and IT professionals to the wide range of capabilities in Azure. The authors—both Microsoft MVPs in Azure—present conceptual and how-to content for seven key areas and describe management tools and business cases.

Rethinking Enterprise Storage: A Hybrid Cloud Model: Discover how a hybrid cloud model—combining cloud storage services with traditional on-premise storage—can solve multiple storage challenges cost-effectively, all under a single data management system. Focusing on the Microsoft hybrid cloud storage solution, this book offers concise insights on technical, strategic, and practical considerations—so you can begin evaluating potential benefits to your organization.

Managing Agile Open-Source Software Projects with Microsoft Visual Studio Online: With this ebook, the ALM Rangers share their best practices in managing solution requirements and shipping solutions in an agile environment, an environment where transparency, simplicity, and trust prevail. The ebook is for Agile development teams and their Scrum Masters who want to explore and learn from the authors’ “dogfooding” experiences and their continuous adaptation of software requirements management.

Get them while they are still free!

 

Tags:

Azure | Application Lifecycle Management | .NET | Cloud Computing | Mobile | Microsoft | SQL Server | System Center | Xamarin | SQL Server 2014

0

A Little Story about How PowerBI Got into My TFS

by Angela 9. April 2015 14:29

So a few months ago I ran into an old friend from my Software Architects days who now runs the BI practice at another local consulting firm here in Chicago. I’ve always been a bit of a nerd when it comes to data and analytics, and as he started to describe this cool new thing called PowerBI to me, I got this idea.  What if we found a way to use PowerBI to slice, dice, and analyze TFS data, specifically VSO?! We needed to figure it out, then share it with the world, because how cool would that be?!

 

Sadly, we quickly discovered that there was no VSO connector available yet for PowerBI, but that didn’t stop us. We figured out that we could use the Office 365 Power BI tools against an on-premise TFS database and do some pretty neat analytics.  To make sure it was something that anyone following along at home could recreate, we even used the data from the publicly available Brian Keller ALM demo image. We started by pulling in work item data, and created a few dashboards, the first being a basic work item overview dashboard:

image

Once we created a few charts, the fun began. We could select work item types, teams/areas, and watch the data change. For instance, by simply clicking on a team (Devices), all of the charts on the page would refresh with the portion of them relevant to the selected team visible.Cool right? As someone who often managed a product portfolio in TFS, the ability to see the big picture and drill in with a matter of a click or two is really valuable!

image

Now imagine the ability to show scatter graphs to highlight patterns in your data, geo spatial coordinate data to map out where certain events are happening, the possibilities are endless. Obviously there is a lot more to share about the capabilities of PowerBI and TFS. So fast forward to today. Tom and I just wrapped up our TFS + PowerBI webinar, and recorded it.  So if you missed it, watch the full video here to find out more about PowerBI and how it can be used to drill into TFS data. You can also get a copy of our slide deck here.

And stay tuned over the next few weeks for exciting announcements on how PowerBI will be capable of connecting to VSO!

Tags:

ALM | Application Lifecycle Management | Microsoft Office | MSDN | o365 | Office 365 | PowerBI | SDLC | SQL Server | TFS | TFS 2013 | TFS Service | Visual Studio | Visual Studio 2013 | VS 2013 | VSOnline

0

It’s THAT Time Again! ThatConference Call for Speakers is Open for Just 2 Weeks

by Angela 31. March 2015 08:30

I can’t believe it is going to be our 4th year. Seriously. Craziness.

I still remember that fateful day almost 6 years ago. I was driving out to Detroit for a conference and I get a call from my buddy Clark. He’s telling me about this crazy idea to create a conference for everyone. It would have family stuff, include all kinds of technology, and it would be in a freaking water park in Wisconsin! What was not to love? And most importantly, did I want to help?? I had over a year at that point before the the kickoff of the inaugural ThatConference. It seemed like a lifetime away, and yet here we are. Every year I flop down on my bed after the last session and think GOD THAT WAS A LOT OF WORK, and then volunteer for next year because I can’t imagine NOT being involved in something this great. On to my point before I start getting all misty eyed. WHAT?

Call for speakers has just opened for ThatConference 2015. We’re going to be bigger, awesomer, geekier, and yes awesomer is a word because I said so! Smile We need great speakers. We need you. We need your KIDS to submit. I know, who knew? Last year we had an astounding number of geeklets presenting, leading open spaces, and coming up with some amazing ideas for this coming year. I am personally so stoked to see what the kids have ins store for US this year. No technology is off the table. No talk related to anything that anyone in the tech community would be interested in is off the table. Personally I plan to submit talks around not just TFS, and agile, but around fear and how many of us battle imposter syndrome. So be creative.

Next, please, check out our conference site, check out speakers and sessions from previous years, and then submit something that moves you. Here is a preview of our speaker submission “rules of the road”:

 

Tips for making your abstract epic:

  • Counselors have roughly 60 minutes to teach their fellow campers.
  • Descriptive and edgy titles are best. Bonus points for Summer Camp Geek references.
  • Make sure your abstract description contains enough detail so we know what you're going to talk about. Don’t worry if you make any mistakes we will have the opportunity to fix it later.
  • Try not to pull any switch-a-roos last minute and talk about something completely unrelated. Campers don't like that. If something changes, please work with That Conference.
  • We can't make too many promises but if there are issues with the final speaker schedule we will do our very best to accommodate you.

Do:

  • Be passionate about your chosen topic.
  • Feel free to submit more than one abstract. We have to maintain a balance across all of the tracks and their topics. It will just help us and potentially you.
  • Consider how your presentation is relevant to all technologists, but don’t feel constrained to avoiding a talk on one specific programming language, platform or technology.
  • Consider what discussions could be sparked by your presentation. That Conference is all about meeting people and discussing ideas; consider what people will talk about after your presentation.
  • Explain what benefit your presentation will bring to the audience.
  • Tell a story.
  • Show real world examples, especially your own experiences, to support your ideas. Show code samples or demonstrate product capabilities only where appropriate.
  • Make sure you can keep the documented session time limit.
  • Stay near the stage or podium after your presentation, encourage the audience to come up and discuss the presentation with you.
  • Please invite the audience to discuss your talk with you face to face rather than just at the end. Better yet, continue the conversation in our Open Spaces.
  • Respect our anti-harassment policy.

Don’t:

  • Use your presentation to specifically promote the superiority of one platform, language or technology over all others. Instead talk about pros and cons of the demonstrated subject, and invite the audience to share their own experiences related to your discussion.
  • See your presentation as a platform to market your company or product.
  • Include unnecessary animation or sound effects in your presentation that will distract from your content.

 

So seriously, don’t wait! Submit your talk, or talks, TODAY and don’t miss the opportunity to be a part of something truly awesome: https://www.thatconference.com/

Tags:

Agile | ALM | Application Lifecycle Management | personal growth | technology | development | Windows Phone | Visual Studio | ThatConference | Team Foundation Server | Scrum | SQL Server | Mobile development | Cloud Computing

0

FREE webinar on April 9th - Lifecycle Analytics with TFS 2013 and Office 365

by Angela 16. March 2015 13:34

More and more businesses that I work with rely on software for their growth and success, today more than ever before. But businesses often feel a lack of control and visibility around their software processes, and fail to achieve the agility and efficiencies needed to succeed.

Microsoft has revolutionized software Application Lifecycle Management with a robust and highly collaborative toolset focused on transparency, quality, and efficiency. Visual Studio ALM provides a powerful collaboration and automation platform in Team Foundation Server (TFS), while offering a wide variety of interfaces to TFS including Visual Studio, Microsoft Test Manager, cross-platform development tooling such as Eclipse, and Office.

Microsoft Power BI is a complete self-service business intelligence solution that can be used to visualize the patterns and trends in your TFS data.

Please join us for this free online webinar to learn how to harness the powerful integration and reporting capabilities available in this suite of Microsoft tools to not only manage your software ALM, but to improve it!

Key Experiences:

· Overview  of Visual Studio ALM

· Overview of Power BI

· Capturing the right data in TFS

· Applying analytics and business intelligence to inspect and improve your processes

When:   Thursday, April 9th from 11:00 AM – 12:30 PM

Register Now

Presenters:

clip_image002Angela Dugan is the Microsoft ALM Practice Manager for Polaris Solutions.  She has been working in the software industry for 16 years, is a certified scrum master, and a Microsoft ALM MVP.

clip_image004Tom Jaskula is the Data Analytics Practice Manager for Peters & Associates and is the president of the Chicago BI PASS chapter.   He has been architecting and implementing solutions using Microsoft SQL Server and Microsoft Business Intelligence products for 16 years.

Tags:

ALM | Application Lifecycle Management | VS 2013 | Visual Studio | Visual Studio 2013 | Team Foundation Server | TFS 2013 | SQL Server | SQL Server 2012 | Business Intelligence | Office 365 | o365 | PowerBI

0

What Conference? Yeah ThatConference

by Angela 15. May 2014 08:49

With so many conferences, it’s easy for one to get lost in the noise. But don’t let that happen with ThatConference. I know, “but Angela you’re on the conference committee, of course you think I should go”. It’s true, for several years now I’ve been working with the ThatConference gang to keep this thing growing and thriving, but it’s because I believe in it. We don’t get paid, we get nothing out of being on the committee other than knowing we got to help provide this awesome event to the community we are so proud to be a part of. OK, now I’m getting all sappy so let’s move on. The point is, this conference is literally organized by a bunch of us techies and geeks like you, not huge corporations or software vendors with an agenda or licenses to sell.  We strive to make the conference fun, educational, and family-friendly. So I mean it when I say this conference is FOR YOU.

Tickets went on sale today, and you may have noticed a slight uptick in prices. Yeah, things get more expensive every year, that’s life, but is STILL an incredible value at $399. That includes 3 full days of amazing sessions (125+ to choose from!) AND lots of networking opportunities AND a pig roast AND a private water park party just for ThatConference attendees AND a Bacon bar AND multiple social events AND a game night (I might be biased as I am running this one, but seriously, BOARD GAMES!!). That was a lot of ANDs for your money. And if you buy soon you can get an Early Bird discount of $25 making the conference just $374.99. You also get a discounted nightly rate at the water park resort if you’re not a local, which gets you some nice additional perks (last year we got free passes to the Ducks and Tommy Bartlett show with our room). That’s an incredibly inexpensive conference that you can combine with a great family summer vacation in the Wisconsin Dells! The topics being covered this year are incredibly diverse, I’d need a few paragraphs more just to cover them all and no one wants to read that much so check out the full conference schedule here. And don’t be afraid to ask your boss to sponsor your ticket, and maybe send a few of your coworkers too!  If they have any budget set aside for training, I can’t think of a better way to use it.  You’ll get exposed to a far wider range of topics and our food is WAY better too ;)

As you might know if you are a returning camper, we also have a great program for the families, so bring the significant others and kids if you have them. It’s a last hurrah before school at a water park and indoor amusement park. You’ll be a HERO and you still get to go geek out at a tech conference! If you purchase family tickets along with your conference ticket, family members are just $39.99 per person, or $29.99 if purchased before 5/22. That means the entire family can join us at ThatConference social events, the pig roast, game night, a craft night that I organize just for the kids, and of course an entire track devoted to family friendly geekery. And trust me when I say the family sessions will blow their minds! Last year my 10 year old nephew was introduced to programming for the first time (he even used Visual Studio for one session!), and ended up stealing my laptop so he could play around with it some more. How cool is that?!  This year we even have a couple of session being run by kid campers from last year! There’s even a session on writing Minecraft Mods. I know right? The family schedule is here, and it’s REALLY good so look it over, show it to your kids, then sign them up!

Hope to see you In August! Now go sign up, seriously right now, go do it.

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

Free Training When You’re Snowed In, What’s Not To Love

by Angela 2. January 2014 12:15

So it’s been snowing in Chicago, a LOT. I am in Oak Park, specifically, and holy moly did we ever get dumped on. Here, in case you think I’m being a big baby, this was my back deck at 7am this morning and it’s STILL snowing quite hard. There’s almost 10 inches of snow on those chairs right now, and there’s a pergola over them!

WP_20140102_07_54_12_Pro

Anyway, that’s not my point. My point is that I get to work from home this week, thank goodness, and ran across a great set of training classes on Microsoft Virtual Academy to fill some time. It’s free, yes FREE, and there are a LOT of technologies to choose from including ALM.  Although I’ll admit the ALM stuff is pretty light and scarce, and mostly focuses on 2012, so I’ll be nagging some folks about that soon. But there are also classes on Azure, HTML 5, even licensing!

Here is the current list of tools and technologies covered:

image

Clicking on Visual Studio I find a lot of great classes to get me up to speed on Windows development, HTML 5, you name it! What you see below is just the first few that came up, it’s a LONG list.

image

Best part is you can build up a nice little wish list since you may not have time to take everything today. So build a training plan, or several, and save the classes you like and take them at your own pace. Easy!  I already had one started from a while ago, but need to go back through and update it with some new classes, obviously :-P

image 

So dig in by starting here. And get some of those Microsoft certifications knocked out while you’re trapped in your house by snowmageddon.

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

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