Welcome to MSDN Blogs Sign in | Join | Help

Announcing the Fall 2008 MSDN Tiki Hut Road Show Series

 Tiki_3TikiHutMSDN Crowd_1

http://www.dotnettikihut.com

That's right - the MSDN Tiki Hut Road Show is back for the Fall 2008 tour - and ready to unleash some cool technical presentations, demos, and code samples with a tour all over the great State of Florida. 

  Men's Flamingo <br>Hawaiian Aloha Shirt (Black)<br> 100% Cotton<br>410-3416Men's Flamingo<br> Hawaiian Aloha Shirt (Sage) <br>100% Cotton<br>410-3416Men's Bird of Paradise <br>Hawaiian Aloha Shirt (Blue)<br>100% Cotton<br> 410-3446

And since we're in Florida - why not do it in Florida Style? Wear your ugliest Hawaiin shirt and win valuable prizes! 

Menu at the Hut:

Join your official Tiki Tour Guides; Joe Healy, Russ Fustino, and Jeff Barnes as we explore the following topics:

  • What’s New in SQL Server 2008 for Developers

  • Build next generation applications with Silverlight 2.0

  • Silver GPS - How to create an end-to-end Mobile GPS tracking application using the .NET Compact Framework, WCF, LINQ, Silverlight, Deep Zoom, and Virtual Earth

  • Power up your Office applications with VSTO (Time Permitting)

 

Event Dates and Registration:

 

Monday, October 06, 2008 6:30 PM - 9:00 PM

University of Miami - School of Business
Storer Auditorium 5250 University Drive
Coral Gables, Florida 33146

Register: http://msevents.microsoft.com/CUI/Register.aspx?culture=en-US&EventID=1032389186&CountryCode=US

Tuesday, October 07, 2008 1:00 PM - 4:00 PM

Spanish River Library
1501 NW Spanish River Blvd
Boca Raton Florida 33431

Register NOW: https://msevents.microsoft.com/CUI/Register.aspx?culture=en-US&EventID=1032389330&CountryCode=US

Wednesday, October 08, 2008 6:30 PM - 9:00 PM

Embarq Auditorium
Academic Building 5 Room 112
10501 FGCU Blvd South
Ft Myers Florida 33965-6565

Register NOW: https://msevents.microsoft.com/CUI/Register.aspx?culture=en-US&EventID=1032389928&CountryCode=US

Tuesday, November 11, 2008 1:00 PM - 4:00 PM

Jacksonville Community College
Nathan H. Wilson Center for the Arts - Lakeside Room
11901 Beach Blvd
Jacksonville, Florida 32246

Register NOW: https://msevents.microsoft.com/CUI/Register.aspx?culture=en-US&EventID=1032389331&CountryCode=US

Wednesday, November 12, 2008 1:00 PM - 4:00 PM

Tallahassee Community College
Grand Banquet Hall
444 Appleyard Drive
Tallahasee Florida 32304

Register NOW: https://msevents.microsoft.com/CUI/Register.aspx?culture=en-US&EventID=1032389332&CountryCode=US

Thursday, November 13, 2008 1:00 PM - 4:00 PM

Seville Quarter
Heritage Hall
130 East Government Street
Pensacola Florida 32502

Register NOW: https://msevents.microsoft.com/CUI/Register.aspx?culture=en-US&EventID=1032389555&CountryCode=US

For more information - visit the Official MSDN Tiki Hut Road Show Web Site: http://www.dotnettikihut.com/default.html

We'll see you at the Hut!

Technorati Tags:

FREE! SQL Server 2008 {JumpStart} Training

Looking to get a head-start on ramping-up for SQL Server 2008? 

image

Well, here is a great jump-start site with lot's of great content (ppts, demos, HOLs, VPC's, etc.)

Here's the complete laundry list:

Overview Sessions
0. SQLServer08_ExecutiveUpdate.pptx  download
1. SQLServer08_DataPlatS+S_Final.pptx  download
2. SQLServer08_MissionCritical_Final.pptx  download
3. SQLServer08_Manageability_Final.pptx  download
4. SQLServer08_BusinessIntelligence_Final.pptx  download
5. SQLServer08_NextGenDataApps_Final.pptx  download
Database Infrastructure Track
DBIS Module 1 - Overview.pptx  download
DBIS Module 2 - Availability Enhancements.pptx  download
DBIS Module 3 - Security Enhancements.pptx  download
DBIS Module 4 - Policy-based Management and Multi-server Administration.pptx  download
DBIS Module 5 - Throttling and Troubleshooting.pptx  download
DBIS Module 6 - Features To Manage Part 1.pptx  download
DBIS Module 7 - Features To Manage Part 2.pptx  download
DBIS Module 8 - Scalability Enhancements.pptx  download
DBIS Module 9 - Query Optimizer Enhancements.pptx  download
DBIS Module 10 - Performance Studio.pptx  download
L01_SQL Server 2008 Using Policy-based Management.docx  download
L02_SQL Server 2008 Using Performance Studio.docx  download
L03_SQL Server 2008 Database Mirroring in Action.docx  download
L04_SQL Server 2008 Peer to Peer Replication.doc  download
Business Intelligence Track
Part1_01.Microsoft BI Strategy Overview.Presentation.pptx  download
Part1_02.IntroDimModelTechniques.Presentation.pptx  download
Part1_03.IntroToETL.Presentation.pptx  download
Part1_04.IntroToSSRS.Presentation.pptx  download
Part1_05.Publishing and Accessing Reports.Presentation.pptx  download
Part1_06.IntroToUDM.Presentation.pptx  download
Part1_07.AccessingUDM.Presentation.pptx  download
Part1_08.IntroToDataMining.Presentation.pptx  download
Part1_09.Building Dashboards.Presentation.pptx  download
Part2_01.Improving Integration.Presentation.pptx  download
Part2_02.More Flexible Richer Reports.Presentation.pptx  download
Part2_03.Using SSRS Management Tools.Presentation.pptx  download
Part2_04.Leveraging SSRS Programmability.Presentation.pptx  download
Part2_05.AcceleratingSSAS.Presentation.pptx  download
Part2_06.ManagingSSAS.Presentation.pptx  download
Part2_07.UnderstandingSSASQueries.Presentation.pptx  download
Part2_08.DataMining.Presentation.pptx  download
Part1_03.IntroToETL.LabGuide.docx  download
Part1_04.IntroToSSRS.LabGuide.docx  download
Part1_05.Publishing and Accessing Reports.LabGuide.docx  download
Part1_06.IntroToUDM.LabGuide.docx  download
Part1_08.IntroToDataMining.LabGuide.docx  download
Part2_01.ImprovingIntegration.Demo.docx  download
Part2_02.More Flexible Richer Reports.Demo.docx  download
Part2_03.Using SSRS Management Tools.Demo.docx  download
Part2_04.Leveraging SSRS Programmability.Demo.docx  download
Part2_05.AcceleratingSSAS.Demo.docx  download
Part2_06.ManagingSSAS.Demo.docx  download
Part2_07.UnderstandingSSASQueries.Demo.docx  download
Part2_08.DataMining.Demo.docx  download
Developer Track
01_Introduction.pptx  download
02_TSQL.pptx  download
03_Beyond Relational.pptx  download
04_ServiceBroker.pptx  download
05_SQLCLR.pptx  download
06_VisualStudio.pptx  download
07_ClientProgrammbility.pptx  download
08_EntityFramework.pptx  download
09_HTTPProgramming.pptx  download
10_OCS.pptx  download
L01_SpatialLabsInstructions.docx  download
L02_DatabaseClients.docx  download
Dev Track Scripts.zip  download
Upgrade Track
00.OpeningAndWelcome.pptx  download
01.UpgradeTechnicalValueProposition.pptx  download
02.AnatomyOfAnUpgrade.pptx  download
03.UpgradeAdvisor.pptx  download
04.ApplicationCompatibilityTesting.pptx  download
05.PlanningYourUpgrade.pptx  download
06.HandsOnLab.docx  download
06.HOLManual.pptx  download
Videos
Video Clip 1-Man on Street_What Is-5MB.wmv  download
Video Clip 2-Soldering-5MB.wmv  download
Video Clip 3-Man on Street_Why Upgrade-5MB.wmv  download
Video Clip 4-Oscilloscope-5MB.wmv  download
Video Clip 5-Gruunfelter Company-5MB.wmv  download
Summary
All Overview Session Materials.zip  download
All Business Intelligence Track Materials.zip  download
All Database Infrastructure Track Materials.zip  download
All Developer Track Materials.zip  download
All Upgrade Track Materials.zip  download

SQL Server 2008 Demo

SQL Server 2008 Demo VPC - Release 2.part01.exe  download
SQL Server 2008 Demo VPC - Release 2.part02.rar  download
SQL Server 2008 Demo VPC - Release 2.part03.rar  download
SQL Server 2008 Demo VPC - Release 2.part04.rar  download
SQL Server 2008 Demo VPC - Release 2.part05.rar  download
SQL Server 2008 Demo VPC - Release 2.part06.rar  download
SQL Server 2008 Demo VPC - Release 2.part07.rar  download
SQL Server 2008 Presenter Script - Release 2.docx  download

Hands-On Lab VPCs and Lab Manuals
NOTE: There are TWO Hands-On Lab VPC and Lab Manual Collections:
COLLECTION 1: SQL Server 2008 HOLs which has 19 associated Lab Manuals, AND
COLLECTION 2: SQL2008AlwaysOnHOL which has 10 associated Lab Manuals and 1 Readme file


COLLECTION 1
Collection 1: SQL Server 2008 HOLs VPC Image

SQL Server 2008 HOLs.part01.exe  download
SQL Server 2008 HOLs.part02.rar  download
SQL Server 2008 HOLs.part03.rar  download
SQL Server 2008 HOLs.part04.rar  download
SQL Server 2008 HOLs.part05.rar  download
SQL Server 2008 HOLs.part06.rar  download
Collection 1: SQL Server 2008 HOLs Lab Manuals
Data_Mining_withSS2008_HOL.doc  download
Delivering_SSAS_Capabilities_Through_MSOffice_HOL.doc  download
Partition_Processing_for_DW_HOL.doc  download
Plan_Freezing_HOL.doc  download
Resource_Governor_HOL.doc  download
Spatial_Data_and_VE_HOL.doc  download
Spatial_Data_HOL.doc  download
SQL_Server_2008_ChangeDataCapture_HOL.doc  download
SQL_Server_2008_DATETIME_Data_Type_HOL.doc  download
SQL_Server_2008_TableValuedParameters_HOL.doc  download
SQL_Server_2008_Using_Performance_Studio_HOL.docx  download
SQL_Server_2008_Using_Policy-based_Management.docx  download
SQL_Server_Compact_Building_Occasionally_Connected_SystemsHOL.docx  download
SSAS_Designing_Analysis_Services_Solutions_HOL.doc  download
SSAS_Managing_Analysis_Services_Solutions_HOL.doc  download
SSRS_Authoring_Reports_Using_Reporting_Services_HOL.docx  download
SSRS_Managing_the_Report_Services_Infrastructure_HOL.doc  download
Transparent_Data_Encryption_HOL.doc  download
What_Is_New_For_DBAs_in_SQL_Server_2008_HOL.doc  download

COLLECTION 2
Collection 2: SQL2008AlwaysOnHOL VPC Image

SQL2008AlwaysOnHOL.part01.exe  download
SQL2008AlwaysOnHOL.part02.rar  download
SQL2008AlwaysOnHOL.part03.rar  download
SQL2008AlwaysOnHOL.part04.rar  download
SQL2008AlwaysOnHOL.part05.rar  download
SQL2008AlwaysOnHOL.part06.rar  download
Collection 2: SQL2008AlwaysOnHOL Lab Manuals
ReadMe1st.txt  download
Data Recovery Preventative Techniques.doc  download
Database Mirroring.doc  download
Database Snapshots.doc  download
Instant Initialization.doc  download
Online Operations.doc  download
Peer to Peer Replication.doc  download
Service Oriented Database Architecture.doc  download
Snapshot Isolation.doc  download
Table and Index Partitioning.doc  download
Transparent_Data_Encryption_HOL.doc  download

Technorati Tags: ,
Posted by jbarnes | 1 Comments
Filed under:

Silver GPS - Part 1

Ok, here is part 1 of a multi-part installment to cover the Silver GPS application.  I thought we would start by examining the "Big Picture" below.

image

This first segment will focus on the Mobile GPS Tracker client - which includes the ability to capture GPS data and store it locally on the device in a SQL Server Compact database.  Before we begin, here is the software you will need to complete this piece of the application:

The starting point for this application will be the "GPS Sample" application that gets installed with the Windows Mobile 6 SDK at:

C:\Program Files\Windows Mobile 6 SDK\Samples\PocketPC\CS\GPS

You can get a feel for how the "FakeGPS" SDK tool works by  copying the "FakeGPS.CAB" file from the following folder:

C:\Program Files\Windows Mobile 6 SDK\Tools\GPS

to the GPS Sample project.  Then "include" the FakeGPS.CAB file in your project and right-click, mark the "Build Action" property as "Content" - so it gets deployed to the device.

 image

To see this in action - Press F5 to run the application - Select "Windows Mobile Professional Emulator" as the deployment device.

image

The application will then be deployed to the device and you will see the following screen:

image

Click on Start / File  Explorer / MyDevice / Program Files / gpssample to navigate to the installation folder.

Double-click on the "FakeGPS.cab" file - this will install the FakeGPS tool on the emulator device.

image image

Once installed, you will find the FakeGPS application under Start / Programs on the emulator device:

image

After double-clicking, select the listbox item to "Enable" the FakeGPS tool and use the "FakeGPSData.txt file for GPS emulation data points.

 image

At this point, you are ready to "Start" the GPS sample application and you will see  that is starts registering GPS information via the emulator device...

image image

We will use this base GPS application as a starting point for building the Silver GPS mobile application.  In addition to this core GPS functionality, we will add the following items to the solution:

  1. Add a new SQL Compact Database to the solution
  2. Design the layout of the SQL Compact Database
  3. Add a Timer control
  4. Add code to "Save" the data to the SQL Compact database
  5. Add new menu items to start/stop saving GPS data to the SQL Compact database

 

(1) - Add a new SQL Compact Database to the solution:

  • Right-click on the solution, "Add New Item" - > Database File -> Name it GPSTracks.sdf

image

(2) - Design the layout of the SQL Compact Database:

  • Open the Database designer and add these fields:
  • image
  • Note the use of the "Identity" field type for the ID field above.

(3) Add a Timer Control:

  • Add a timer control to the main form and logic to save to the database every 2 minutes (120,000 milliseconds):
  • image

(4)  Add code to "Save" the data to the SQL Compact database

  • image
  • image

(5)  Add new menu items to start/stop saving GPS data to the SQL Compact database 

  •  image image image

And there you have it - a complete, ready-to-use GPS tracking application that saves your GPS data to a local SQL Compact database.

image

Here is the link to the code: SilverGPS_Part1.zip

and here is a link to a 15 minute overview with a Silverlight 1.0 Pop-Up Player: http://www.dotnettikihut.com/SilverGPS/

(Be sure to float over the top & bottom of the player to activate the controls and markers)

 image

Well see you next time for Part 2 in the SilverGPS series:

"Creating a WCF host Web Service and Mobile NET CF Client"

 

SilverGPS - Background

One of my inspirations for putting together this sample application was being part of an interesting case study that was recently published on Microsoft.com about how a large global security company was using mobile applications built on the Microsoft platform to gain a technical advantage in a very competitive marketplace.  They also had a unique application that leveraged Virtual Earth to create a "Geo-Fence" around the perimeter to detect when a guard entered an exited the secure area or even moved on the grounds...

image image

They leveraged the .NET Managed GPS layer in the SDK to quickly create  very compelling mobile applications in a very short amount of time. 

image image

One of the most unique aspects was how they leveraged every aspect of the device's capabilities (from monitoring battery power to leveraging SMS text messaging to trigger device alerts): 

 

So, we finally come to my personal reasons for creating this application and the cool new features in VS2008: 

 image image

Stay tuned for Part 1 in the Series - "Building the SilverGPS .NET CF Client GPS Tracker Application"

 

Technorati Tags: , , ,

Silver GPS

Overview of an End-to-End Mobile GPS tracking application using the .NET Compact Framework, WCF, LINQ, Silverlight, and Virtual Earth

A huge THANKS! for those of you who attended last night's South Florida Architecture meeting - which ended-up being virtually delivered over LiveMeeting.  Special thanks to our sponsors - Dave Noderer from www.FlaDotNet.com and tropical storm Fay.    

 image image

I plan to release the entire project via a series of upcoming blog posts with all the links to the detail deck pieces, short video walk-thru, and demo code.  For starters - here is the link to my overview presentation deck:

http://cid-e80ea9288abd4452.skydrive.live.com/self.aspx/Silver%7C_GPS

Next stop is the Jacksonville Code Camp on Saturday, August 23, 2008 - where you can catch the session live: http://www.jaxcodecamp.com/Schedule.aspx

Technorati Tags: , , , ,
Posted by jbarnes | 2 Comments

Track the Olympics Race for the Gold with Silverlight

Check-out this Uber-Cool Olympic Tracker Silverlight2 application by ComponentOne at:

http://demo.componentone.com/Silverlight/OlympicTracker

You can track the medals by Geography:

image

Or Track them by Country:

image

Or Track them by Country & Medals:

image

Technorati Tags:

Windows Live Tools for Microsoft Visual Studio 2008

The Windows LiveT Tools for Microsoft® Visual Studio® 2008 are a set of control add-ins to make incorporating Windows Live services into your Web application easier with Visual Studio 2008 and Visual Web Developer 2008.

What's in the New Toolbox?

  • Virtual Earth Map Control *new!* (reference TBD)
  • Contacts Control (reference)
  • IDLogin Control (reference)
  • IDLoginView Control (reference)
  • MessengerChat control
  • SilverlightStreamingMedia Control (reference)

Virtual Earth Control Drill down:

ASP.NET developers can now integrate Microsoft Virtual Earth Maps simply by dragging and dropping an ASP.NET Server Control in Visual Studio and Visual Web Developer.

 

Integrating interactive, immersive maps no longer requires JavaScript, it can be done by ASP.NET developers simply. For smooth interactions this control can be combined with ASP.NET AJAX capabilities to provide the power of ASP.NET Serverside processing without the development overhead of coding JavaScript.

 

Visual Studio toolbox - Map control is available right in your toolbox of Visual Studio

image

Drag and drop control onto your web page - You can drag and drop the control from toolbox onto your web page and set some properties and you are ready to go.

image

image image

Server side events - Server side events for panning/zooming, find/directions are available in addition to client side events for the map control.

 

image image

Display and control the map - You can control how map displays on your web page with standard functionalities like MapMode (2D/3D), MapStyle(Road/Aerial), displaying dashboard and setting its size, setting the zoom levels, zooming in/out, panning etc.

Adding shapes to the map - You can add shapes to map from ASP.NET Server Side using provided methods. You can query different shapes/layers in the Map and delete them as well.

Using directions - You can get the directions between multiple points using methods GetDirections. You can specify different routing options like distance unit, color etc. Once the direction information is received, Map control raises event OnServerDirections where you can process/render the returned information in way that suites your scenario.

image

image

image

Using local search and mapping results - Map control provides with find method where you can search for local businesses in a specified location.

image

image

Working with bird's eyes - Map control has support for bird's eye view similar to JavaScript control.

Getting Traffic information - You can get traffic information and display on your web page. For this, you need to have an account with Virtual Earth Platform. You first need to get a client token:

image

You can then use this client token to display the traffic of the location you are interested in:

image

CTP Preview Disclaimer:

 

The suite of tools is currently a community technology preview, which means we would love feedback, but strongly discourage any web site from going live using these controls.

Download it here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=D7C6DF11-2283-4CAC-9723-172F5C33EFBB&displaylang=en

Internet Explorer 8 - Is your Web site ready for IE8?

IE

The Good:

Microsoft will be releasing Internet Explorer 8 to render content in its most standards-compliant way by default.  Giving top priority to Web standards interoperability will help web developers and designers drive toward the ideal of "write once, run anywhere", freeing up more time to innovate rather than modify content for different browsers.  This commitment also addresses several development and design pain points from previous Internet Explorer releases.

The Bad:

Browsing with the default new settings in IE8 may cause content written for previous versions of Internet Explorer to display differently than intended.  This creates a call to action for site owners to ensure their content will continue to display seamlessly in Internet Explorer 8.  As such, we have provided a meta-tag usable on a per-page or per-site level to maintain backwards compatibility with Internet Explorer 7. 

Adding this tag instructs Internet Explorer 8 to render content like it did in Internet Explorer 7, without requiring any additional changes.  Note that in most cases, the immediate workaround can be as simple as embedding the following HTML tag into the top of the HEAD element of your web pages:

<meta http-equiv="X-UA-Compatible" content="IE=7">

The Ugly:

Notice how even the wildly popular site, www.DotNetTikiHut.com renders today under IE8 Beta 1 below - there are at least 3 issues with visual image overlaps on the home page:

TikiHut_IE8

And this is what the site looks like under IE7 Today:

TikiHut_IE7

What can you do?

Get your sites ready now for broad adoption of Internet Explorer 8, as there will be a beta release in the third quarter of this year targeted for all consumers.  To learn more and get started, please follow the step-by-step instructions located at the following link:  http://go.microsoft.com/fwlink/?LinkId=120024 .

But don't just aim for the IE8 compatibility "low-bar" and rest on your laurels - learn about and take advantage of some of the cool new features like "Web-Slices" and "Activities".  Here are some more links & resources to get you started:

Microsoft:

MIX 08

IE Blogs:

I have also up-loaded all the other publicly available IE8 materials & content to my Skydrive folder at  http: