Intro to the Internet of Things using Netduino

This was my presentation to the .Net Users of Fort Wayne (NUFW) on 3/8/2016.

Intro to the Internet of Things using Netduino from Dean Willson

Index Reorganization and Rebuilding for Success

On January 20, I presented an end-to-end process for SQL Server Index rebuilding/reorganization to NUFW (.Net Users of Fort Wayne). For people that manage small databases with less than a few million records per table, there are few risks and considerations. For those with large or VLDB databases such as ERP/MRP databases with hundreds of millions of records and Terabyte data file sizes, the process becomes more critical and time consuming. That is the situation for which this process was designed.

Index Reorganization and Rebuilding for Success from Dean Willson

10 Reasons to Join a PASS or .Net User Group

I am a member and leader at multiple chapters of technology-based international professional associations, like PASS (Professional Association for SQL Server) and INETA. Through that affiliation, I have experienced many, many benefits that such a small percentage of our industry takes advantage of.

1. Great people – Attendees, speakers, organizers, volunteers, sponsors, and venue hosts. Attend regularly and I promise you will make life long friends.
2. A place to talk shop with peers, learn about other organizations and practices, scope out job opportunities, help others with their challenges, and mentor people new to the field.
3. Great content – free training, new technology previews, and deep dives into specific topics.
4. Access to experts – speakers almost always provide their contact info and give you permission to ask questions outside of the presentation. Get help on your challenges from other attendees during the social networking time. Sometimes you even get to meet Industry celebrities and national conference presenters, such as Brent Ozar, Brad McGehee, and Scott Guthrie.
5. Food and beverage
6. Free swag – books, software (Development software, Operating Systems, 3rd party tools, Xbox games, and more), hardware (keyboards, mice, web cams, etc.), training vouchers, discount coupons, quirky and unusual items (such as Bucky Balls),  travel mugs, tote bags, back packs, and the list goes on.
7. News and announcements about other events and happenings in the industry – training conferences like the PASS Summit and SQL Cruise, all day training opportunities, such as Day of .Net, Codemash, SQL Saturday, virtual training events, contests, free eBooks promotions, Job opportunities.
8. Save money travelling to regional training or events by carpooling with your fellow user group friends.
9. Opportunities to present – show off your own proficiency in your craft, get experience to prepare you to speak on regional or national level, establish credibility as a teacher/communicator.
10. Opportunities to be a board member or volunteer to hone your leadership and logistical skills enhances your career marketability. Also, volunteering or leading a local chapter or regional event is great way to prepare you to become a board member on a national scale, if that is of interest to you.

Really there are few reasons not to attend, join, volunteer, or lead a professional organization. If you’re interested in professional organizations in general, read my popular post about 10 reasons to join a professional association.

What have I missed?

Creating a Windows Phone 7 app using WCF, and SQL Azure

Last night I gave a presentation with demos for fwPASS creating a Windows 7 app displaying a list of gymnasts from a SQL Azure database using WCF (Windows Communication Foundation). The WCF service used the Entity Framework and the .Net Membership provider.

Windows phone 7, WCF, and SQL Azure

View more presentations from Dean Willson

The application was surprisingly easy to create despite the fact that were a lot of moving pieces with integration between all the different components.

The presentation covered the following tools:

• Windows Phone Marketplace App Hub 
• Visual Studio IDE
• SQL Server Management Studio (SSMS)
• Windows Azure Platform Management Portal
• SQL Azure Migration Wizard
• Windows Phone 7 Emulator

 

All that in 70 minutes. Yes, I talk fast. This was a first time presentation. Below is the demo script I used:

Marketplace

1. Preview App Hub http://create.msdn.com

· Show app details text, iconography

Database

1. SSMS – show local ChalkChimp database

· Show script for creating additional users?

2. http://windows.azure.com SQL management interface

· No query designer

3. SQL Azure Migration tool

· Scripts out db

· Shows unsupported features

· deploys

4. Azure limitations in SSMS

· No query designer

· Admin account (other users don’t have access to the master database)

WCF

1. Create new project WCF Application

· Highlight Framework version 3.5

· Change binding to basicHTTPBinding

2. New Item à ADO.Net Entity

· Azure connection

3. Switch to finished project

4. Modify Iservice.cs, modify Service.cs implementation

5. Show .Net membership bits in web.config

6. View in browser (copy url)

WP7 client

1. Open Visual Studio (another)

2. New Project à Windows Phone 7 application

3. New item à Phone portrait page

4. Add Service reference

· Show service methods

· Advanced show generate async methods

5. Switch to finished project

· Show xaml bindings

· Show async methods and completed event handlers

· switch device to emulator

6. Run it

Optional

· Show property pages and iconography

 

Technorati Tags: Windows Phone 7,WP7,WCF,Silverlight,SQL Azure

Do You Have Control of Your Database?

I prepared the following talking points to facilitate a round table discussion on Database Source Control titled “Do you have [source] control of your database” with a local chapter of Professional Association for SQL Server.

Most software developers use some form of source control for their software code, but it seems less common to take the same precautions with their databases.

Database Source Control

View more presentations from Dean Willson

Career Transitions Presentation to Ball State University

I was asked to speak to the Six Sigma Student Organization in the Whitinger Business Building about the transitions a person may fear while changing roles of a student to professional as well as transitions that may take place while a person is pursuing their career. The talking points from my presentation are below.

Career Transitions - Ball State University, Six Sigma Speakers Series

View more presentations from Dean Willson

SQL Saturday #67 Chicago

Most of the sessions I attended involved improving performance. Whether it was proactive (design for performance) or reactive (troubleshooting), most sessions included some coverage of indexes. Surprisingly there very little duplication of content by the different speakers. Because of the quality and relevance of the all sessions offered, it was difficult to decide which sessions to attend. Below is a brief recap of the ones I chose.

Sessions

Performance Tuning Made Easy with Thomas LaRock

Being a certified Six Sigma Black Belt, I appreciated the way Tom (blog|twitter) described a simple systematic process for performance tuning based on the Six Sigma DMAIC (Design, Measure, Analyze, Improve, Control) approach.

The Optimizer, Statistics, and Indexes with Grant Fritchey

Grant (blog|twitter) gave a great primer to the internals of the Relational Engine, the components of which have really cool names like Query Parser, Algebrizer, and Optimizer. He also spent more time discussing the Statistics histogram, which appeals to my six sigma senses, than I generally see in an hour long presentation.

WIT (Women in Technology) Panel: Energizing the Next Generation

This session seemed to have a balanced number of men and women in attendance. It was nice to hear the perspective of multiple women with different backgrounds sharing their experiences in the field. I’m really happy that most of their experiences sounded positive even in the face of adversity.

Refactoring SQL with Jeremiah Peschka

Jeremiah (blog|twitter) really highlighted the importance of using consistent naming conventions and common alias names. He touched on SQL unit testing and some open source test frameworks. He also showed refactoring examples such as, re-writing where clauses to move functions from the left side of the operator to the right side for performance gains.

Database Design Contentious Issues with Karen Lopez

This was one of my favorite sessions. It was interactive as the participants had to walk to the front of the room and anonymously vote (via post-it note) on a scale of 1 to 5 on our opinion/view of two issues which people often passionately argue about, such as, surrogate keys vs. natural keys. People that admitted to voting on the extremes (one or five) were asked to explain why they voted the way they did and open the topic for group discussion. Karen liberally made effective use of Canadian SWAG (like ketchup flavored Pringles) to persuade the edge-case voters to plead their case in the face of possible peer criticism. Karen (blog|twitter) expertly moderated the discussion and provided great pro/con examples on both sides even where it conflicted with her own views. It was both fun and educational.

Index Internals for Mere Mortals with Michelle Ufford

At a lightning quick pace, Michelle (blog|twitter) brought a great deal of insight to index internals. She showed actual representations of index pages and pointed out key elements of it, including the “uniqueifier”. She covered a great deal of information in the short one hour, but it was very clear, understandable, and educational.

Lunch

The lunch was provided by Meaty Balls. It was plenty of tasty meat and mushrooms for the price.

Check-in

The organizers offered a “Speed Pass” option where I printed my name tag, lunch ticket, and raffle tickets off in advance which meant I could sleep in a little before heading to Chicago.

Venue

The conference was hosted at the DeVry University Addison Campus which had great classroom spaces. There were ample power outlets available on the table tops for each attendee to plug in, if desired. I wish I had remembered to bring the AC adapter for my GPS for the trip home since my car lighter adapter stopped working before the trip.

Networking

I was within a SWAG keychain throw of several SQL Celebrities like Kevin Kline (blog | twitter) and Brent Ozar (blog|twitter). Brent was sitting behind me in three out of five sessions I attended - and no, I’m not a SQL Stalker.

I finally got to meet Wendy Pastrick face-to-face after several email and twitter conversations over the last year.

Credit-worthy

I’ve been running the fwPASS User Group for a few years and to do just an average job takes a surprising amount of time and effort. See my case study on continuous improvement in a professional association for more information. The organizers did an exceptional job that deserves more thanks than I can provide. I’m not sure if this is inclusive of all the organizers (which I copied from Doug Lane’s blog), but THANK YOU:

Wendy Pastrick (blog|twitter)
Ted Kruger (blog|twitter)
Norman Kelm (blog|twitter)
Jes Borland (blog|twitter)
Bob Pusateri (blog|twitter)
Aaron Lowe (blog|twitter)
Bill Lescher (twitter)
Rich Rousseau (twitter)

Project Phoenix Helps Non-Profits and Underemployed Developers

Unemployed or underemployed software developers have an opportunity to receive/earn a Visual Studio Ultimate license with MSDN among other great tools and learning opportunities. To qualify, the developer proposes a software project for a 503c non-profit, school, or church. See Arnie Rowland’s Like a Phoenix rising from the ashes post for full details about the program. The community benefits by receiving a service (software development) that might not otherwise be available to them.

Programs like these can only happen through the generosity of the MVP’s, and the numerous sponsors that have teamed up donating their time, talents, and/or products and services to the project.

photo credit: Gabi Agu CC BY 2.0

Case Study on Continuous Improvement in a Professional Association

I wrote this case study as an effort in process journalism so other current and potential future group leaders would have a process improvement reference. Download the Case Study on Continuous Improvement Running a Non-Profit Professional Association chapter.

You might also be interested in my popular post about 10 Reasons to Join a Professional Organization.

IndyTechFest 2010

I am a Windows 7 phone programmer. At least that’s what Dave Bost, Bill Steele, and Jesse Liberty told me. That makes me feel pretty trendy.

With eight tracks of sessions I found myself wanting to attend two or three presentations simultaneously every hour. Unfortunately I had to choose just one.

Sessions I attended

A. Keynote with Jesse Liberty.

1. Windows Presentation Foundation for Developers

2. Introducing Windows Phone 7 Series

B. Lunch: Networking. It’s pretty fun to go to a regional event with over 400 attendees and realize that you know about 10% of the people there. I wanted to attend the Building a Company and Operating a Consultancy lunch and learn, but the room was packed full by the time I got my lunch.

3. Building Applications on Windows Phone 7 with Silverlight

4. Building a Data Mart 101

5. Application Development with Silverlight 4. Jesse mentioned Adam Kinney’s name in this session. That always makes me think I know a celebrity.

Thank you!

A big thanks goes out to the organizers, speakers, sponsors, volunteers, attendees, and anyone else that had their hand in the event! Thank you to my buddy Dave Fancher for giving me a ride from the Marriott North to the Marriot East.

The logistics, food, venue, prizes, etc. get better every time they hold the IndyTechFest. There were so many prizes from the sponsors it literally took an hour to raffle them all off – and they were even doing it quickly and efficiently.

Data Mining with SQL Server 2005

I presented this topic to fwPASS on January 26. There was a pretty good turnout. The video was edited for brevity.

Data Mining with SQL Server 2005

View more presentations from DeanWillson.

If you are interested in the topic, I highly recommend the MSDN Webcast: Applying SQL Server 2005 Data Mining to Enterprise Business Problems which I used in preparation for my presentation. The book I referenced in the presentation is Programming SQL Server 2005, Microsoft Press by Andrew J. Brust and Stephen Forte, specifically Chapter 20.

*The presentation was video taped and the audio was recorded separately with a high quality mic, but somehow the audio file vanished into thin air (read: accidentally deleted) the day after the event so the audio is straight from the camcorder, oh well. The lighting was not good in the video  because the overheads were dimmed for better visibility of the screen.

Designing Applications for the Occasionally Connected Scenario – NUFW Presentation

The presentation slides from my presentation at NUFW last night are below. It’s not much value without the demo’s and audio except for the links which I used to research and debug while creating the demo application. I have the presentation audio and may turn it into a webcast at some point in the future.

Designing For Occasionally Connected Apps Slideshare

View more documents from DeanWillson.

Encoding Media with Expression Blend and Encoder 2 SDK

This week I presented for the Fort Wayne .Net Users Group (NUFW). There were about ten people in attendance and the presentation lasted about one and a half hours with an Encoder GUI walkthrough and two demos. The Power Point presentation and source code can be downloaded here. The theme of the main Demo was ZooTube a simple WPF app to encode media with an Intro and an in-video watermark (screenshot of app is below the video). The code was based on the VB sample code that is included in the Encoder 2 SDK download. The finished video is shown below.

Smiling and Profiling – Potpourri of Profiler Utility

Last night I presented for the Fort Wayne chapter of PASS (Professional Association for SQL Server). You can download the presentation titled Smiling and Profiling - A Potpourri of Profiler Utility. The meeting was held in downtown Fort Wayne at the Pint and Slice in their spacious upstairs meeting area. It was a small group, but that always promotes great conversation.

Technorati Tags: SQL Server Profiler,Professional Association for SQL Server

Fort Wayne SQL Server Presentation - Performance Monitoring and Baselining

Click here to download my FWPass presentation from November 25, 2008. The meeting was held upstairs at the Pint and Slice in downtown Fort Wayne, Indiana. The meeting format was a little different because someone apparently walked off with their VGA cable for the overhead projector. The backup plan was to use the big flat panel display, but my laptop didn't have S-Video output. In leiu of everyone peering over my shoulder at the laptop display, we just discussed the material. The atmosphere and food were great. It was a small informal group of six or seven, but it was still fun.

IndyTechfest 2008 - Another Great Indy Event

The indytechfest 2008 was again a spectacular event. The logistics were even better this year than last year. The speaker lineup was excellent with an impressive thiry tracks. The organizing team (Brad Jones, Dave Leininger, John Magnabosco, Mark McClellan, and Bob Walker) managed once again to secure enough valuable sponsors to make this a free all-day event for the nearly 500 attendees. I believe over 800 registered in the first week after registration opened. There was even a delicious catered lunch and pletty of Swag and raffle items.

I attended the following events:

• Session 1 - Business Intelligence Track: SQL Server Integration Services 2008 (Arie Jones)
• Session 2 - DBA Track: How to Become a Profiler Master (Brad McGehee)
• Lunch and Learn: Lessons on Event and Error Logging (David Leininger)
• Session 4 - .NET Today: Developing with the Live Platform (Brian Gorbett)
• Session 5 - Web Development with ASP.NET MVC (Aaron Lerch)
  

I look forward to the next indytechfest event... providing I can sign up before registration closes!

NUFW Presentation - .Net Role Based Security

Last night I presented .Net Role Based Security (using the built-in Membership and Personalization provider model) for the Fort Wayne .Net User Group. Click Here to download the presentation and code samples. Armanda Turney added to the discussion the use of the SiteMap file with the enabling of security trimming to further programatically enhance the user experience by limiting the navigation menu options based on user roles. The .Net membership and personalization model provides a quick and easy method to add and customize membership and role based security in a way that is accessible even to beginner programmers.

IndyTechFest 2007

Last Saturday I attended the Indy TechFest event. The event was well organized and well orchestrated. The team that handled the logistics did a phenomenal job. The keynote was a pleasant surprise with the addition of a presentation by Buck Foley, Motivational Speaker, who did an effective job of waking up the early crowd of programmers and DBA's. He was hilarious! There was a wealth of sponsor giveaways including one of my personal favorites over 150 technical books. They had 5 tracks with 5 sessions each which is a tall order to fill with technical and interesting speakers. They definately pulled it off. There was even a very interesting Lunch and Learn covering getting published by Brad Jones which was well worth skipping the lunch naptime.



I attended:

1. Troubleshooting SQL Server Performance by Brad McGehee
2. Upgrading your DTS packages to SQL Server Integration Services by Tom Pizzato
3. An Overview of Linq by Dave Bost
4. Tips and tricks for a VB developer including VB9 by Bill Steele
5. SQL Server Database Design and T-SQL Best Practices by Arie Jones