Register   
Login
   
You are visitor 146487
    
  The BenkoBLOG 

Blogging point...

I was looking a back at my site and the blog I've put together over the last couple years, and I'm starting to notice a trend. Anymore, I generally post to announce events and when I've got resources from a webcast or something I've presented that people might want to link to. Sure, it's all good, but it seems painfully one dimensional compared to what I intended when I started doing this.

What is it that I had planned for this space? For this digital ink that shows up in your reader or on my site? Originally I had hoped to make it a site where I can share my perspective on the world of technology as seen thru the glasses of someone who's been in it for a while. Tell stories about people I've met on the road from different places, what they're seeing and doing, and what inspires 'em to do what they do. I thought maybe people would be interested to hear what's new in the tools and technologies that are changing the work landscape so dramatically. I had also hoped to share insight that might be useful to help people not make the same mistakes and avoid the interesting opportunities for growth that sometimes aren't so interesting as annoying.

So I created my site (www.BenkoTips.com) a couple years ago to serve as a repository for articles and downloads as a resource for developers. It's very cool when I meet people who've been on my site before they met me, and they put it together and say "oh yeah, benkoTips...I've been to that site!". Those days make me feel like this has all been worth it. I've had grand plans for expanding it since it began, and one of these days I'll get around to implementing them...things like a book review section of titles I've found interesting. Another on the events that we're offering as part of my job, with maybe a little more information and links. I've even begun playing around with posting some demo-screencasts, but I'm not sure if I've found the right mix yet...

So then we come to the blog part. It's separate from BenkoTips and is hosted at work - http://blogs.msdn.com/benko. This is the part where I'm trying to figure out what it is I want the blog to be. Should it be a place for posting resources after a presentation? Or should I make it something deeper, more personal. More of a view of the world and include all that stuff that I'm interested in and playing with that doesn't quite fit the profile of technical blog? What is it that I can offer that would be useful like the site, and yet is something that is easier to sit down and put down in digital ink?

It's a new year (fiscal), and I'm looking at what I want to do in the next year. What can you expect from me? How about more posts on books I've read. Some insight or observations of what's going on in the developer community, both from the organized stuff to personal thoughts about how to succeed in this business. Maybe a couple ideas on how to fail as well...it will be a mix of ideas, thoughts, links, tidbits and advice that you can take for what they're worth. I'll even start using categories to help differentiate between them so you can tell what are rants.

Yep...I think I need to reinvent this thing. It's a job whose time has come.

Enjoy

Mike

[Thu, 24 Jul 2008 05:24:13 GMT]

Elvis has left the building

Wow. I know I played the video (Bill Gates Last Day) for fun a my events this spring, but it’s official now. Bill Gates has left the building. After three decades of working in the business, he is moving onto the next thing. Some skeptics are still in the wings wondering if it would really happen. But strangely enough time goes by and stuff happens. Things change. People change. It’s what we’re all about. Dealing with change.

Good luck Bill. I hope your next chapter is as good as the last. Wouldn’t that be awesome?

[Tue, 01 Jul 2008 15:54:12 GMT]

SharePoint Code Camp anyone?

I'm excited about all the opportunities to see what's going on in this rapidly changing technology world. Recently we saw the start of the Silverlight User Group in the Twin Cities. This weekend we saw the genesis of yet another group!

The SharePoint code camp was huge! What a day! We had over 140 people attend on Saturday’s all day first ever code camp for SharePoint in the Twin Cities. With over 6 tracks to choose from and 20+ sessions the crowd was big, loud and having fun from start to finish. A lot of excitement and enthusiasm not only from attendees but also from the partners who worked so hard to pull it off. It’s amazing how ready the community is for this type of event.

Summer 08 065 Summer 08 064
Summer 08 069 Summer 08 074


Sometimes it's just fun to be there. Saturday was one of those days! By the way, if you're interested in other upcoming conferences and events, check out the updated list of links on my website www.BenkoTIPS.com

Enjoy!

[Mon, 16 Jun 2008 17:00:55 GMT]

Updated the sidebar on BenkoTIPS...

I've been running this site (www.benkoTips.com) for 3 years now, and I finally got around to updating the links on the left hand side of the screen. You will now be able to find a (more) complete list of bloggers, conferences, regional User Groups as well as some links of interest to help you find what you're looking for. If you'd like to add your user group or conference to the list, please let me know. Click the link "Talk to me" on the sidebar and you can send me a direct email.

Enjoy!

Mike

[Mon, 09 Jun 2008 15:31:07 GMT]

Twin Cities Silverlight User Group is LAUNCHED!

SilverLightUserGroup_small This week on Tuesday I had the great pleasure of attending the charter meeting of a new User Group in Minneapolis focused on Silverlight. Many thanks to Farhan and all the people who worked so hard to make this event a success.

Scheduled to run the third Tuesday of each month, it was standing room only with more than 100 people in attendance. Jerry Sevier presented on an overview topic on Silverlight 2.0 and showed the various tools available to the developer to take advantage of this new technology. The crowd was very lively and the conversation was a lot of fun. Check it out!

HPIM1348 HPIM1346 HPIM1351
HPIM1345 HPIM1350 HPIM1352

See you next time!

 

[Fri, 23 May 2008 16:00:15 GMT]

Shawn Hargreaves Speaking in Mpls at XNA User Group

Calling all XNA Developers in the Twin Cities area and beyond.

This May 15th, the Twin Cities XNA User Group is pulling out all the stops to bring you a Shawn Hargreaves (Microsoft, XNA Team) Double Feature! Shawn is flying in from Redmond for one night and while we have him here, he'll be answering YOUR questions and presenting on the following topics: 1. Defeating the Network Game Gremlins and 2. Understanding Shaders

For more information and to register, please visit http://www.twincitiesxnausergroup.com.
Meetings are held at Magenic (4150 Olson Memorial Hwy, Suite 400, Golden Valley, MN 55422) on the Third Thursday of each month at 6pm.

[Wed, 14 May 2008 14:58:09 GMT]

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]

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)