Register   
Login
   
You are visitorĀ 124986
    
  The BenkoBLOG 

Launch Demo Code Posted

HeroPage

I have been on the Visual Studio Launch Tour visiting Chicago, Des Moines, Madison, Omaha, Kansas City and St. Louis over the last couple months. As part of that we've been showing new features of Visual Studio for web development.

I've uploaded the sample web site code from the Visual Studio Launch events onto http://www.benkoTips.com/code. This includes the examples showing style sheets, LINQ and Ajax. If you were able to join me at the launch you've seen the demos, but I'm also working on some screencasts of these which registered users can view by clicking in the link  below (note that you will need to have Silverlight installed to view the demos).

 

BQT

Enjoy!

Technorati Tags: ,,
[Tue, 06 May 2008 15:42:28 GMT]

Encrypting the Web.config in VB

I got a request for how to do the encryption of the web.config but this time in VB, so I thought I'd post it here on the blog as well. The logic is about the same, although I found that in VB I had to add a line to the configuration to save the new settings.  The code for this in vb.net (adding to the global.asax file in the "Session_Start" subroutine:

Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs)

    ' Code that runs when a new session is started

    EncryptSection("appSettings")

End Sub

 

Private Sub EncryptSection(ByVal sSection As String)

    Dim config As Configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(Context.Request.ApplicationPath)

 

    Dim configSection As ConfigurationSection = config.GetSection(sSection)

 

    If configSection.SectionInformation.IsProtected = False Then

        configSection.SectionInformation.ProtectSection("DataProtectionConfigurationProvider")

        config.Save()

    End If

 

End Sub

[Wed, 16 Apr 2008 17:45:38 GMT]

How to encrypt the Web.Config

In the security session we did I showed in one of the sample how you can encrypt the web.config file by adding code to the global.asax file. The cool part of this is that using this technique you can secure application specific settings like connection strings and other data in the unlikely event that someone is able to get a copy of the configuration file (like by copying it to a thumb drive from the host machine or something similar).

The basic logic is to create a variable that points to a configuration section, then checking that the section is protected (i.e. encrypted). If it isn't, then call the ProtectSection method to encrypt the contents.  The server uses the local DPAPI (Data Protection API) to encrypt the configuration section with a machine specific key, so only that machine can decrypt the contents. The code for this is:

 

  

    public class Global : System.Web.HttpApplication
    {
       
protected void Session_Start(object sender, EventArgs
e)
        {
            EncryptSection("
appSettings
");
        }

    
       
private void EncryptSection(string sSection)
        {
           
Configuration
config = System.Web.Configuration
                                   .WebConfigurationManager
                                   .OpenWebConfiguration
                              (Context.Request.ApplicationPath);


           
ConfigurationSection configSection =
                               config.GetSection(sSection);

           
if
(!configSection.SectionInformation.IsProtected)
            {
               configSection.SectionInformation.ProtectSection
                         ("
DataProtectionConfigurationProvider
");
                config.Save();
            }
        }

Happy Coding!

[Fri, 11 Apr 2008 17:23:20 GMT]

Silverprint a webcast on the SharePoint Silverlight Blueprint

Here's some links from today's webcast...SLlogo

Notes from what it takes to get the Blueprint working on a typical SharePoint installation

  1. Install the Silverlight 2 add-in
  2. On a server only installation add the Silverlight 2 SDK...
    - or - For a developer environment with Visual Studio 2008 install the Silverlight 2 tools
  3. Run GacUtil to install the 'system.web.silverlight.dll' assembly into the global assembly cache

        c:\> cd \prog*\*sdk*\sil*\v*\li*\ser*
        c:\Program Files\Microsoft SDKs\Silverlight\v2.0\Libraries\Server> gacutil /i system.web.silverlight.dll
  4. Start the Windows SharePoint Administration Service (used by the installers for the BluePrint)
  5. In WSS Central Admin create a site/application and site collection to test the web parts in
  6. Download the package from the Blueprint you're interested in...in our webcast we looked at the code from HelloSilverlight1 and HelloSilverlight2
    - To run HelloSilverlight1 simply run the setup in the download
    - To run SilverLight2 demos we need to make some changes to the web.config of the target site

Configuration changes to build & run HelloSilverlight2

  1. Open code solution
  2. Edit Install.bat to fix gacutil locations & set correct target site
  3. Modify site web.config to include settings from sample web.config on Patrick Tisseghems post

I'm still working out some of the bugs, but that's where I'm at.

Good luck & hope this helped!

Mike

[Thu, 27 Mar 2008 15:31:04 GMT]

SharePoint and AJAX Style Web Parts

In yesterday's webcast I had the pleasure of having an expert on SharePoint and AJAX talk about bringing these two compelling technologies together. Todd Bleeker (from MindSharp, a SharePoint consulting firm based in Minneapolis) when thru the various steps required to create AJAX web parts in SharePoint. We looked at the basics of how to build web parts, as well as deployment steps to make sure it works. This included:

  1. Compile the code into an assembly
  2. Make sure the assembly is signed (using sn.exe as needed to create keys)
  3. Mark the assembly as Safe in the web config of the app
  4. Make sure it's Trusted
  5. Deploy the assembly to the site

There were some great questions around how to work with Code Access Security with these and Todd suggests looking at a white paper by Brett Lonsdale.

I just posted the code Todd created on www.BenkoTIPS.com/code, so go ahead and check it out.

Enjoy!

[Fri, 21 Mar 2008 13:56:17 GMT]

SharePoint for Developers Webcast Series

Because building it just got easier!

What's the deal with Windows SharePoint Server (WSS 3.0) and Microsoft Office SharePoint Services?Lynn Langit and I are doing a webcast series on Windows SharePoint 3.0 as a platform for developers and looking at the tools and technologies available for customizing portals and sites.

In April we are on Mondays, but it looks like May we will be switching to a Friday format. As always I will post the links and code as they become available. Here is our schedule so far:

New Stuff!

  • 3/6/2008 - Part 13 - Customizing SharePoint: Ever imagewondered how you can use SharePoint but have your own custom look and feel? In this webcast we will look at the site customization techniques of creating custom MasterPages, Themes and Layouts to give your web site your own look and feel.
  • 3/13/2008 - Part 14 - SharePoint and Authentication: In this  session we cover the basics and how to use the Authentication and Membership Providers. We look at creating a custom provider and CardSpace can be used to login to your SharePoint site. This session will look at the advanced tools available in IIS 7.0 for configuring and deploying SharePoint.
  • 3/20/2008 - Part 15 - SharePoint and AJAX: Explore the world of modern web development techniques by looking at how Microsoft’s AJAX library and SharePoint can be used together to deliver compelling user experience. In this webcast we show the various approaches to integrating AJAX in WSS 3.0 and then cover what’s improved in sp1.
  • 3/27/2008 - Part 16 - SharePoint and SilverLight: Rich User Experience is getting easier to create with the release of Silverlight. In this session we show how Silverlight takes advantage of XAML and provides an easy way to build compelling user interfaces. We will demonstrate using the 1.0 version of Silverlight as well as what’s new in 2.0 that allows the developer and designer to collaborate to build exciting new applications.

Links to the original 12 webcasts:

  • Part 1 – SharePoint for Developers 4/13/2007 1 pm PST: Join the first webcast of this four-part series to find out what you need to know about Microsoft Office SharePoint Server 2007 as a developer. We cover the basics of SharePoint Server 2007, and we show how you can use this new product to simplify collaboration, development, and management of your software projects. Learn what it takes to set up SharePoint Server 2007, customize the master pages, and how you can use other tools to develop custom applications. Attend this session to discover compelling reasons for choosing the new 2007 Microsoft Office system and SharePoint Server 2007 for your solution development needs.
  • Part 2 – SharePoint Designer 2007 4/16/2006 1 pm PST: There are many tools to choose from for developing Web sites; in this second installment of our series, we look at Microsoft Office SharePoint Designer 2007, a new product for creating standards-based Web sites. See how you can build powerful applications on the Microsoft SharePoint Products and Technologies platform to enhance your productivity and deliver rich-looking sites. Join this session to learn how you can use SharePoint Designer 2007 to take advantage of Microsoft ASP.NET version 2.0, Web Parts, and integration with SharePoint Products and Technologies.
  • Part 3 – Migrating to SharePoint 4/23/2006 1 pm PST: Do you have a portal site that you would like to host in Microsoft Windows SharePoint Services? In this third installment of our series on Microsoft SharePoint Products and Technologies for developers, see what is involved in the process of moving a portal site to Windows SharePoint Services. Topics we cover include: using Microsoft Office SharePoint Designer 2007 to customize the master page, creating new content types, and working with workflow.
  • Part 4 – SharePoint and Access 2007 4/30/2007 1 pm PST: So far in this webcast series, we covered how Microsoft SharePoint Products and Technologies serve as powerful collaboration tools. In this final session, we take a look at how Microsoft Office Access 2007 integrates with Microsoft Windows SharePoint Services. Join this session to learn how Access 2007, the popular data management application, and Windows SharePoint Services enable you to centralize and simplify data management, and share data across your organization.
  • Part 5 – SharePoint and Workflow 5/11/2007 1 pm PST: In this webcast, we discuss the ability to use, update, and create custom workflows that you can employ in your Windows SharePoint Services site. We show the built-in workflow capabilities in Windows SharePoint Services, and we also demonstrate what customizations are available. In addition, we describe how to use Microsoft Office SharePoint Designer 2007 to open, view, and modify included workflows. We conclude the presentation with a detailed demonstration of the capabilities of the Workflow Designer in SharePoint Designer 2007.
  • Part 6 – SharePoint and Content Types 5/18/2007 1 pm PST:  Join this webcast as we review the concept of content types as they relate to Windows SharePoint Services sites. We explain the default (included) content types first. We then discuss why you may want to update the built-in content types or create your own. We also demonstrate how to create custom content types and provide several business examples of why and where you might wish to do this. We conclude this session by showing some of the newly created content types in action on a Windows SharePoint Services site.
  • Part 7 – SharePoint and Forms Services 5/25/2007 1 pm PST:  In this webcast, we explore Microsoft Office InfoPath 2007 as a form tool and describe how you can host forms centrally via the InfoPath Forms Services feature of Windows SharePoint Services version 3.0. We provide an overview of InfoPath 2007, demonstrating both how to customize an included template form and how to create a custom form that connects to Microsoft SQL Server. Next, we illustrate how to configure the Windows SharePoint Services administrative Web site, which is required to set up appropriate permissions (and other settings) to use InfoPath Forms Services.
  • Part 8 – SharePoint and the Business Data Catalog 6/1/2007 10 am PST: Join this webcast as we explain the concepts surrounding the Business Data Catalog (BDC), a new business integration feature in Microsoft Office SharePoint Server 2007. We demonstrate the use of an application definition file (ADF) to create the connection between your Windows SharePoint Services site and a custom data source, and we show you how to use an ADF creation tool. Learn to use BDC-derived data with included Web parts, such as the filtering Web part. We conclude this webcast with a discussion of the various ways we have worked with the BDC in production.
  • Part 9 – Web Parts and Work Flows 6/8/2007 10 am PST: In this webcast, we discuss and demonstrate the creation of Web parts and workflows for Microsoft Office SharePoint Server 2007. We use Microsoft Visual Studio 2005 Extensions for Windows SharePoint Services and the Microsoft .NET Framework version 3.0 workflow extensions to customize and create both Web parts and workflows. Join us to learn about the concept of features as they relate to SharePoint Server 2007 Web Parts.
  • Part 10 – Sites and Templates 6/15/2007 10 am PST: In this webcast, we dive into how the Microsoft Visual Studio 2005 Extensions for Windows SharePoint Services can enable you to take Microsoft Office SharePoint Server 2007 even further. We start with an overview of project types and show how you can add event handlers, site definitions, and more into your tool belt. We look at creating site templates and master pages for SharePoint Server 2007, and we provide an example of how to customize and replace templates
  • Part 11 – SharePoint and Business Intelligence 6/22/2007 10 am PST: In this webcast, we discuss business intelligence (BI) (advanced reporting) integration with your Microsoft Office SharePoint Server 2007 Web site. We demonstrate configuration of Excel Services in SharePoint Server 2007, key performance indicators (KPIs), and more. We use the Report Center template and show you how you can easily integrate line-of-business (LOB) data into your site
  • Part 12 – Developing SharePoint Workflows 7/6/2007 10 am PST: Windows SharePoint Services provides excellent facilities for working with business processes. In this "webcast by request," we review the workflow development processes associated with Windows SharePoint Services. We look at the included workflows, modifying workflows in Microsoft Office SharePoint Designer 2007, and creating and modifying workflows in the Microsoft Visual Studio development system
[Thu, 20 Mar 2008 15:57:36 GMT]

SharePoint and AJAX Style Web Parts - A Webcast

For tomorrow's webcast as part of the series SharePoint for Developers (http://www.BenkoTIPS.com/wss) I will have a special guest joining me. Todd Bleeker is a SharePoint MVP who does a good amount of training around SharePoint and will be sharing what he's learned around web parts and working with AJAX in SharePoint. This session will be packed with lots of demos and concepts, so join us by clicking the link below:

  • 3/20/2008 - Part 15 - SharePoint and AJAX: Explore the world of modern web development techniques by looking at how Microsoft’s AJAX library and SharePoint can be used together to deliver compelling user experience. In this webcast we show the various approaches to integrating AJAX in WSS 3.0 and then cover what’s improved in sp1.

Look to see you there!

[Wed, 19 Mar 2008 20:33:54 GMT]

Didn't make it to MIX?

Not a problem...you can watch the sessions online by going to VisitMIX and selecting the track you're interested in. Some great technical sessions are available for download, and there's even a cool Silverlight control for picking which ones.

Very cool site:  http://sessions.visitmix.com

[Wed, 19 Mar 2008 19:06:33 GMT]

SharePoint and Membership ... a Webcast

Today's webcast will deal with membership and SharePoint, how users are able to connect and use your SharePoint site. I'm adding a post that will provide links and additional information about this, but it's not quite ready yet. I'll update this post when I'm done.

MSDN: Implementing a Membership Provider

[Thu, 13 Mar 2008 15:51:56 GMT]

Customizing SharePoint - a webcast

image

Today in the latest addition to the SharePoint for Developers webcast series I'm going to be covering what's involved in customizing a portal to fit our needs. Our project will be to build out portions of the new www.BenkoTIPS.com to provide the ability to search for webcasts by series and by presenter. This will take advantage of the Data View Web Part that we will access in SharePoint Designer, and I'll show how to link together multiple lists.  We'll also cover master pages briefly and show how we can use either the built in master pages or create our own.

Some terminology that is useful in understanding customization in SharePoint is having a grounding on the differences between sites, pages, lists and document libaries. The following is the definitions we'll work from in today's webcast (courtesy of my good friend Phillip Wheat)

  • List – the basis of all things SharePoint.  Consider this a database table that you can dynamically add tables to, and you won’t be far off conceptually.  Benefits to using SharePoint Lists – CRUD UI is already created for you (but you can customize what’s been created), mobile and RSS enablement (in 2007), audit, item level permissions, content types, and workflow are all available out of the box.
  • Document Library – A customized type of List that is focused on storing single files with metadata.  This is using the same storage as regular lists, but the UI is tweaked to focus more on the file system type experience.  One key factor – general list types can have more than one file associated with each item, Document Libraries are limited to a single file per list item.  Templates can be associated with each content type in a Document Library to enable starting documents from a known state.
  • Page – Basically an ASPX page contained inside of SharePoint.  This is a UI element and can contain static or dynamic content.  The most common type of page found on most SharePoint implementations are Web Part Pages which allow the user to manage shared or personalized content on the page and expose data that is stored in that site or site collection.  Most pages consist of a standard Master page assigned by the SharePoint infrastructure, and a content area in which the users can interact with their data.
  • Site – This is the container that everything resides in.  It’s a logical storage location – which sits under another storage called a Site Collection.  Users often confuse sites with pages, but a site can contain multiple pages and have the ability to store additional data and functionality which may not be visible to the end user (things like reusable content galleries, web part galleries, the master page and style sheet galleries, etc.)  Sites are generally of interest to end users only for two reasons – scope for content (it’s more difficult to pass information between site collections than between just sites) and that the base URL for the pages comes from the site.
  • Page Layout – This is new to SharePoint 2007, it came in with the web content management functionality.  Think of this as a way to custom format information stored in a special type of list.  This list can contain text content, images, reusable content, in general anything you can put in a standard list template.  But instead of having to customize how that information is formatted for one usage, you can select (or create) different Page Layout templates which identify where each of your columns should appear on that rendered page.  This provides the ability to put dynamic content in a fairly static rendering model so that formatting can change with very little effort, and where multiple templates can be used for different periods or usages of that data.  The same thing can be done with customized AllItems.aspx pages, but this is much easier and maintainable.

Some links that may be useful to todays webcast include:

Next week we look at Membership & Authentication and how to set up Forms Based Authentication for our SharePoint site. We'll also see how to create a custom membership provider and have some fun with that.

Hope you can join us!

[Thu, 06 Mar 2008 15:47:58 GMT]

XNA on Zune? It's not just for breakfast anymore...

If you haven't heard about it yet, we just announced some great stuff for developers working with XNA. This is the technology that you can use to develop game software on Windows and the XBox. Well, take a look at http://creators.xna.com/whatsnew.aspx if you want to see how we're taking that to new platforms!  Very cool stuff, I'll be downloading and playing with it myself very soon.

By the way, if you're in Minneapolis and are interested, we've got a very active User Group that can get you launched in the right direction. They're meeting tomorrow night, but you can get all the info about their group at:  www.twincitiesxnausergroup.com 

ENJOY!

Mike

[Wed, 20 Feb 2008 21:14:02 GMT]

More SharePoint Webcast Goodness Coming Soon!

This week as a part of the followup from an internal Microsoft Conference (TechReady 6) I have scheduled some more webcasts on SharePoint to run every Thursday morning in March. This will include 4 sessions that will dive deeper info topics like Ajax. Cardspace and Silvelight. These will include:

· 3/6 - Customizing SharePoint: Ever wondered how you can use SharePoint but have your own custom look and feel? In this webcast we will look at the site customization techniques of creating custom MasterPages, Themes and Layouts to give your web site your own look and feel.

· 3/13 - SharePoint and Authentication: In this  session we cover the basics and how to use the Authentication and Membership Providers. We look at creating a custom provider and CardSpace can be used to login to your SharePoint site. This session will look at the advanced tools available in IIS 7.0 for configuring and deploying SharePoint.

· 3/20 - SharePoint and AJAX: Explore the world of modern web development techniques by looking at how Microsoft’s AJAX library and SharePoint can be used together to deliver compelling user experience. In this webcast we show the various approaches to integrating AJAX in WSS 3.0 and then cover what’s improved in sp1.

· 3/27- SharePoint and SilverLight: Rich User Experience is getting easier to create with the release of Silverlight. In this session we show how Silverlight takes advantage of XAML and provides an easy way to build compelling user interfaces. We will demonstrate using the 1.0 version of Silverlight as well as what’s new in 2.0 that allows the developer and designer to collaborate to build exciting new applications.

 

I will be updating the links as soon as they go live.

Enjoy!

Mike

Technorati Tags: ,

[Thu, 14 Feb 2008 01:33:40 GMT]

MSDN Security Session Links

Technorati Tags:

MSDN Events is back! It's a new year and this week I'm back on the road delivering MSDN events again. The topics we're covering include ASP.NET Membership, IIS 7.0 and Hacker Tricks...we show how the exploits work and what you can do to prevent them. In the presentation we've got a number of links to more information and to make it easier I'm including those links here for easy access.

These links include the following:

IIS 7.0 - What's new for developers

iis.net - Introduction to IIS 7 Architecture

iis.net - IIS7 Configuration Reference

MSDN - Hosting in Windows Process Activation Service

iis.net - Your Web Platform Security

iis.net - Configuring the IIS7 Runtime

Mike Volodarsky Blog -  Developing IIS7 web server features with the .NET framework

ASP.NET Provider Model

MSDN - Provider Model Design Pattern and Specification, Part 1

MSDN - Microsoft ASP.NET 2.0 Providers: Introduction

MSDN - ASP.NET Login Controls Overview

MSDN - Web Site Administration Tool Overview

MSDN Mag - Client-Side Web Service Calls with AJAX Extensions

MSDN - Client Application Services

AdventureWorksLT Sample Database

MySQL Connector - NET 5.1

Security Hacks

Anti-XSS Library v1.5 Download

www.Fiddler2.com

www.HelloSecureWorld.com

Open Source Web Application Project - Top 10 Exploits 2007

Exploit: Cross Site Scripting - Paypal

Exploit: SQL Injection - www.ri.gov

Exploit: Cross Site Scripting - FTD

Exploit: Insecure Direct Object Reference - Cahoots

Exploit: Integer Overflow - Apple

[Thu, 17 Jan 2008 07:04:41 GMT]

Video Puzzle Code

When I demo what's possible with Silverlight I like to show a demo of a video puzzle. This is a fun one to do, where the puzzle pieces are animated by a video file while they can be scrambled around the screen. A lot of people have been looking for the code to this, so I've posted it to the downloads section of BenkoTIPS. Feel free to download and explore the code. It is written using Silverlight 1.0 which uses the JavaScript API.

Enjoy!

[Wed, 26 Dec 2007 15:57:46 GMT]

Enter the Mpls & Des Moines Demo Contest to Win COOL Prizes!

Contest

ANNOUNCING Visual Studio 2008 Install-Fest Demo Contest!

Want to show off your VS2008 or .NET 3.5 skills?  If you answered, yes, this is your opportunity to strut your stuff!

During the Visual Studio 2008 Install Fest & Holiday Party on December 12, 2007 at the DMACC West Campus, and on December 13, 2007 at the Microsoft office in Bloomington MN, we'll be having a demo contest in the auditorium.  Here's the scoop ...

What do I need to do?

Anything, actually! If you've done something cool with VS2008 or like/dislike some of new features or having been messing around with .NET 3.5 (LINQ, XLINQ, WCF, WF, WPF, etc).  We'll take it!!! Silverlight? Astoria? If you can code it and you can show it, enter to win. What's the rules?

  1. 5 to 10 minute time limit for demo
  2. You must show code (pre-written code ok if you explain it during the demo)
  3. The code must be your own
  4. It must run

Top Prizes go to best demos by vote of those in attendance

What do you get out of it?

Well, first, the recognition from your peers as an expert with VS2008/.NET 3.5. Second, speakers will be entered into a special drawing for two prizes donated by MS! Top prizes include XBox-360's and/or Zune. All Pre-registered demo contestants will also receive a full licensed copy of Visual Studio 2008 Pro.

How do you sign up to demo?

Great question! To register and sign up, please send me an email at Mike.Benkovich@microsoft.com with your topic! Limited to 10 entrants per contest.

Anything more?

That's it! If you have any questions, please feel free to email me.

We hope you will join us!

[Fri, 07 Dec 2007 21:25:22 GMT]

Today's webcast will be talking about the components that make AJAX work. Specifically we'll look at doing 2-3 demos including showing how you can debug client side scripting from Visual Studio 2005. It will be a lot of fun, and as usual I've posted the code to www.BenkoTIPS.com for you to take a look at.

Hope you can join us!

posted @ 10/9/2006 10:24 AM by Mike Benkovich

I have installed an interesting application - BlogJet. It's a cool Windows client for my blog tool (as well as for other tools). Get your copy here: http://blogjet.com

"Computers are useless. They can only give you answers." -- Pablo Picasso

posted @ 10/2/2006 10:37 AM by Mike Benkovich

In case you're interested, I'm starting a run of weekly webcasts on Atlas/Ajax to help introduce and get developers up to speed with this exciting new technology. So here's the synapsis:

This webcast series is aimed at people who are new to writing AJAX style web applications but can see the value the technology offers. We go from the basics of the what AJAX is, looking at each of the components that make the technology work, and then dive into what the Atlas framework brings to the table to make developing with this technology more intuitive and easier than before.

 

Atlas: Novice to Pro
Our schedule – Monday's
10/2 – Intro to Atlas: Level 100
If you thought AJAX was for cleaning floors and an Atlas was simply a collection of maps, and you don’t know what all the fuss is about, then this webcast is for you. In this webcast we talk about the technologies available for building highly interactive web applications, the components that make it work, and the tools that are available to the Visual Studio developer for making them work. We cover examples of AJAX style applications, how to install and configure Atlas, and then use the tools to build a simple website.

10/9 – AJAX Components: Level 200
In this webcast we introduce the components and parts that make AJAX work, including the XmlHttpRequest object, the DOM and JavaScript. We explore how these pieces fit together to enable the client application experience. Going beyond naming them we will explore the structure, syntax and the use of these so that we can build a foundation for future webcasts.

10/16 – Writing JavaScript: Level 200
While many people have experience writing .NET applications, learning the syntax and grammar of yet another language can seem like more work than it’s worth. But to take full advantage of what you can do with the Atlas framework there are fundamentals that we need to know and in this webcast we lay it out.

10/23 – Understanding XmlHttpRequest: Level 200
What is the XmlHttpRequest object, and why is it in my browser? In this webcast we cover how the enabling technology for AJAX was introduced and used to allow end users to create browser based applications with a rich user experience. While this is not new technology, we talk about the challenges and complexities that limited its widespread adoption. We dive into the rich set of functionality it offers and take a look at how we can use it in our own applications.

10/30 – Atlas for the masses: Level 200
We have the foundation built, now lets take a deeper look at the framework from Microsoft for building Ajax style applications called Atlas. Using Visual Studio we explore the rich set of components and controls that can be applied to create new web sites and Ajax-ify existing ones.

11/6 – AJAX Control Toolkit: Level 200
When you think about extensibility, look at what AJAX Extensions to ASP.NET offers as a download. Controls you can use, as well as how you can create your own. Join us to learn more about what's possible with this exciting technology.

Other upcoming webcasts...

11/13 – SQL MasterClass: Tuning SQL 2005 Applications
Relational databases let us capture and manage large amounts of information. When the data grows and the application slows, what can you do to make it right? Learn tips & tricks for tuning SQL 2005 databases, using the tools at your disposal and techniques to identify what's the real problem and where to look next.

posted @ 10/2/2006 9:07 AM by Mike Benkovich

Aug6-853Hey – I’m back. I just started back in my role as the Developer Community Champion, this time officially as a Microsoft Employee!  Whooo Hooo! My first day was Monday, and already in Dallas I got the opportunity to do some presenting. My co-worker Bill Steele and I tag teamed the presentation to a great crowd in a nicely air conditioned theater in downtown Dallas – it was over 120 F in the shade down there…

So we had some great fun. Today I’m presenting a webcast on ADO.NET 2.0 that teaches the essentials that a developer needs to know to get started coding. It’s been rescheduled a couple times, but it looks like this time will be a go.

I’m looking forward to seeing you on the road. Join me at one of our MSDN Events live and stop by to say hi!

posted @ 8/18/2006 2:34 PM by Mike Benkovich

In case anyone’s listening, I was recently interviewed for TechNet radio to talk about what IT folks need to know about their developers. It was fun to sit down with with the technet expert Michael Murphy and spend some time talking technology.

Tnrpromo-395x210

 

posted @ 7/7/2006 7:25 PM by Mike Benkovich

Well, I’m back at it on Friday with a couple more webcasts. For those who’ve checked out the other series I’ve worked on (SQL Masterclass and SQL BI Quickstart), you might see a trend with these new ones I’m doing. They finish off an existing series of webcasts aimed for the application developer who is working with SQL Server.

The first one – SQL 2005 Essentials – Enhancements to the SQLClient Data Provider talks about what is new for the developer in terms of SQL Client compared to traditional access via MDAC. We’re covering SNAC, MARS, Notification, Dependencies, Bulk Copy and more. I’ve got a bunch of code examples in both VB and C#, as well as the SQL script needed (we’re using AdventureWorks again)…This is available on the downloads page from which registered users can get the code and see for themselves how it works.

The other– SQL 2005 Essentials – ADO.NET 2.0 is a webcast that dives into new features of the new interface, discusses this new model, which includes provider registration, provider factories, data source enumerators, connection string handling, generalized schema handling, and provider and SQL network stack tracingdiscusses this new model, which includes provider registration, provider factories, data source enumerators, connection string handling, generalized schema handling, and provider and SQL network stack tracing... I’ll be posting the code for this one in the near future.

Hope you can join us. I assure you it should be a lot of fun…

Happy Coding!

posted @ 7/6/2006 9:45 AM by Mike Benkovich

So here it is, mid summer, and I’m looking at what’s coming up. I finished the last of my webcasts in the series on BI last week, and many thanks to all who’ve joined us for them. They were fun to do and it feels good to share what’s possible with the new technologies. If there’s one thing I learned from last week in Boston its how much new stuff there is coming our way. Building systems and application is in a world of change right now, and we’re stuck trying to keep up.

For those who are interested I’ve been invited to speak at a couple conferences this fall – in Omaha at the Heartland Developer Conference, and then again at the Tulsa Tech Fest. These look like they’re going to be a lot of fun with some great talent to get you to speed. I don’t know if I’ll be doing any more webcasts in the near future, but if I do I’ll post ‘em here.

Later

posted @ 6/25/2006 10:13 PM by Mike Benkovich

Here it is – the last webcast of the 11 part series – Data Mining with SQL 2005. I’m in Boston at TechEd, but have tried to find a quiet place to be able to do justice to task at hand. We’ll be covering one of the more interesting parts of Business Intelligence, namely how you can use the data mining features available with SSAS. In this webcast we’ll talk about what data mining is, and then do a couple examples of using it.

I’m adding some links to pages where you can get useful information, and I’m also going to post our code so you can download it if you want. Here’s the links:

posted @ 6/15/2006 11:34 AM by Mike Benkovich

So what’s going on at TechED? I was in the lunch room today and ran into fellow DCC’er Russ Fustino of the Shed Head event series fame. Instgead of sitting down with the masses, we ducked into a special session that got scheduled at the last minute.

I’m at a live broadcast of .NET Rocks! web radio, listening to Carl Franken and Rich Campbell interview the guys from the SQL team talking about the launch of Team Systems for the DBA. Not only does this new release include all the modeling and schema management tools you would expect, it also has some really cool features for refactoring the schema, generating test data, and deploying the schema to target environments.

Very cool stuff! I’ll keep you informed…

posted @ 6/12/2006 1:02 PM by Mike Benkovich

We’re just another band out of Boston
On the road to try to make ends meet
Sleeping in our cars and playing in the bars
We practiced every nite in the streets…

As a technologist who’s had the great opportunities to do a lot of things…from working in the various roles of technology to being a presenter for a major software company canvassing the country showing people what’s possible, it’s interesting I’ve never been to a major conference before. The closest thing to it has been presenting sessions at the Visual Studio launch events (like Minneapolis, Houston & San Antonio). Lots of people, but a different perspective than what I hope to get from going to Boston this week. For the first time I’m honestly going to be a true participant at one of these things and be able to explore what’s going on. I look forward to the chance to see it from the attendee view.

I expect there’s a lot to see & learn about what’s new from MS. With the Vista launch for later this year there is a lot of excitement on the WPF and Workflow that will impact how we build systems and applications. I’ve seen what WinFX can do, having worked with demo applications that feature extreme graphics and highly interactive user interfaces for the Q3 content we did for MSDN.

On another tangent, I’m excited to explore Boston and it’s vicinity. My wife & I recently read the Adams book by McCollough, in which he chronicles the founding of the country, and talks about what was going on in the area at the time. She will be joining me for the weekend after the conference and we’re going to explore the area. I understand that Quincy is nearby, and we’re looking to find a Bed & Breakfast in the area to have a nice weekend.

Well, that’s what I’ve got to offer for now…I’m planning to provide updates as we go. This is so wierd, to feel like a journalist. My good friend Greg Downey (who’s a professor at UW Madison in the school of Journalism) would be impressed I think. Then again, maybe not. Let’s see how the week goes. I’m hoping that this blog is at least entertaining if not useful.

By the way…I will be presenting the last of my webcasts in the series on Business Intelligence with SQL Server 2005 focused on Data Mining. It will be on Thursday, and I’m planning to post some links and code samples with it so those who are interested can download ‘em.  Check out my website http://www.BenkoTIPS.com for more information on this and other webcast series.

posted @ 6/11/2006 8:34 PM by Mike Benkovich

So now I’m all excited this week, because in this 11 part webcast series I finally get to write some code. Today’s webcast Advanced SQL Server 2005 DTS will give us the chance to see how an Integration Services package can be constructed dynamically at runtime from code that we will develop. I’ll be writing the code in C#, but if you’re familiar with VB.Net you should be able to follow along (just remove the semi-colons and change the variable declarations a little)…The idea is that although the designers work well for most things, sometimes you need to customize advanced features or dynamically create things at runtime. I’ve posted the code on http://www.BenkoTIPS.com so you can explore or follow along with it.

Next week I’ll be in Boston for TechED and we’ll run our webcast on Data Mining, the last of this series on how to use the new features of Business Intelligence in SQL Analysis Services.  If I hear of anything cool that will be coming I’ll be sure to report back to you on what’s possible.

– Mike 

posted @ 6/8/2006 10:30 AM by Mike Benkovich

Hey folks, this week we’re going to pull it all together and do some reality check for working with the Business Intelligence. The goal is to do some deeper investigation in a new area of focus in our cube – sales currency. We’ll go through the alteration of the data model, create some SSIS packages to load the new data and then apply business intelligence to the resulting cube.

Hope you can join us. We’ve only got a couple webcasts left in the series. Next week we’ll do some programmatic SSIS, and the following week from TechEd we’ll look at how you can put to use the Data Mining capabilities.

Enjoy!

posted @ 6/1/2006 10:43 AM by Mike Benkovich

This week we’re looking at diving deeper into how SSAS can be configured to give us better performance with our cubes. I don’t have much to offer in the way of links on the topic that haven’t already been posted, but I did get a good question yesterday at the Chippewa Valley .NET User Group meeting on where to find resources about dimensional modeling. Here’s a couple links that might be useful:

Hope you can join us!

Mike

posted @ 5/25/2006 10:38 AM by Mike Benkovich

Ok…so last week’s blog worked well for providing additional links and resources for the webcast on MDX. It seems like a lot of people used them so I’m going to see about making this a regular practice. Here’s a few more links that you might find useful:

This week’s webcast in the BI Quickstart Series covers how to use ADOMD to access the information in our cubes. I’m going to use the MDX queries we created last week and build a couple apps in ASP.NET and a WinForms type. Again, I’ve already uploaded the code to the downloads section for registered users.

Enjoy! 

posted @ 5/18/2006 10:18 AM by Mike Benkovich

So today I’m going to be doing an introduction to Using MDX to query the Analysis Cubes we’ve been building in the BI Quickstart webcast series…I thought it might be helpful if I added some links for more information. Feel free to check these out:

I’ve also uploaded the AW project code to the downloads section…feel free to register and download the code at your leisure…

Enjoy!

posted @ 5/11/2006 10:54 AM by Mike Benkovich

Today we’re talking about reporting against cubes and tools available for this. Here’s a couple links that I’ll be using to get resources that we will be using:

I’ll update the post later if there are more links to share…

Enjoy!

posted @ 5/4/2006 10:21 AM by Mike Benkovich

Today we did the 2nd webcast of the series (considering that last week’s got rescheduled to 4/27 immediately following the regularly scheduled webcast). The topic was Integration Services, and we went through a series of examples of how to use the various transformation tools to play with the data. Some good questions came out of it, thought I would post the answers here…

For a good book on SSIS 2005 check out WROX’s book SQL Server 2005 Integration Services. Brian Larson also has some great titles on BI that you might find useful such as Delivering Business Intelligence with SQL Server 2005.

You can import SQL 2000 dts packages into SSIS 2005, but some of the scripting stuff is going to need to be looked at. Plan to spend some time with the results, but it should be worth the efforts.

The nice thing about SSIS 2005 is that you can use it to pull data from just about anywhere and send it to just about anywhere. You’re not limited in any way to the data actually residing in SQL 2005. This means I could pull data from Oracle and load to Access (why I couldn’t say), but the package would need to be deployed to a SQL 2005 machine that has the appropriate access rights set up correctly.

Hopefully you can join me next week when we’ve got a double header. We’ll do the regularly schduled webcast on Reporting Services, and then immediately following we’ll do the rescheduled Analysis Service webcast where we build a cube. 

ENJOY!

posted @ 4/20/2006 12:36 PM by Mike Benkovich

Unfortunately we ran into some issues with being able to deliver today’s webcast “Building an Analysis Services Database” as planned. So we will be rescheduling it for another day, probably after the Integration Services webcast during the week of April 24th. I’ll post the updated date when I know what it is.

Sorry…

posted @ 4/13/2006 11:15 AM by Mike Benkovich

I’ve got the opportunity to do another MSDN Webcasts series aimed at developers, this time focused on the tools available for business intelligence. We’ve spec’d out a pretty good curriculum, which will take someone from the beginning stages all the way to advanced topics such as data mining and complex data transformation packages. We’ll be doing it every Thursday morning at 10:00 am (EST). Here’s the links if you’re interested in joining us:

1. Business Intelligence core concepts and a ‘Quick Start’ solution.  (4/6) 

This module covers fundamental BI application concepts and terms, along with a ‘Quick Start’ BI solution that uses new SQL Server 2005 technologies to rapidly develop analytical functionality without the complexity associated with traditional data warehouse methodologies.  Topics include the new Unified Dimensional Model (UDM), a comparison of SQL to MDX as reporting query languages, the use of a Data Source View (DSV) to logically redefine data sources, and new dimensionality capabilities.

 2. Building an Analysis Services Database.   (4/13) 

This module focuses on using the BI Development Studio to design an Analysis Services application database, and then manipulating the resulting XML scripts to create customized versions of the application. Topics include Dimensions, MeasureGroups, Aggregations, Security, and Localization. Lab exercises focus on development tools, Analysis Services Scripting Language (ASSL) and Analysis Management Objects (AMO).

 3. Building DTS Packages.   (4/20) 

DTS has been completely re-architected for SQL Server 2005. In this module, you will learn how to utilize the Control flow and Data flow capabilities, how to create packages that can be configured for different environments at deployment time, and how to programmatically create tasks, transformations, and packages. Lab exercises include building, customizing, and deploying DTS packages

 4. Integrating Reporting Services reports into a Client Application.   (4/27) 

Reporting Services has been enhanced significantly for SQL Server 2005, including support for queries against an Analysis Services source. This module includes features most critical to including Reporting Services reports in a client application. Lab exercises include dynamically generating RDL, and creating ASP .Net applications that render reports by using Web Service calls as well as URL parameters.

 5. Integrating Office Tools into a Client Application.   (5/4) 

Microsoft Office includes several tools that can be effectively leveraged to quickly build a powerful front-end application. This module helps you understand how you can take advantage of the strengths of these technologies. Topics include Office PivotTables and Charts, Excel PivotTables, the Excel Add-In Accelerator, and integration with SharePoint. Lab exercises focus on integrating Office Web PivotTables into an application, and seamlessly navigating from a custom report into an Excel PivotTable or Add-In Accelerators. 

 6. Creating Analytical MDX Queries.    (5/11) 

General purpose tools can create standard MDX queries. To make a custom application that answers serious business questions, you need to be able to create effective analytical MDX queries. In this module, you will learn the strategy for building powerful queries that don’t just display data, but show what it means. Lab exercises include creating queries to calculate changes and exceptions, and how to parameterize the queries so that you can include them in a custom application.

 7. Creating Custom Client Applications by using ADOMD .Net and MDX Queries  (5/18) 

Often, to get the desired user interface experience, you want to develop the front-end yourself. This module guides you through using ADOMD .Net to create a client application. Lab exercises include creating ASP .Net applications that parameterize standardized analytical reports and render the result by using ADOMD Net.

 8. Advanced Analysis Services Workshop.    (5/25) 

This module focuses on issues that arise in Analysis Services with very large or very complex databases. You will learn how to effectively design aggregations, partitions, and processing schedules&mdas