This weekend was the first Hartford area Microsoft Code Camp. It was very successful with well over 150 attendees and over 22 presenters. We presented the following topics:
Lee Rodgers – Spring.NET & IOC
Reddy Kadasani – Silverlight – Lighting up the Web
Presentation content and demo content will be posted to this site in the next few days, so please check back.
Addition information about the code camp can be found at the Conneticut .NET user group website (http://ctdotnet.org).
In this post, we will demonstrate the Slowly Changing Dimension (SCD) transformation that is available for use in a Data Flow task within SQL Server Integration Services (SSIS). We’ll walk through an example of how to use it, explaining the terms as we go. In addition, I’ll demonstrate some “extra effort” kind of modifications that can be made for a more thorough usage. After that, we’ll discuss the pros and cons of using it at all. And we’ll wrap up with some tips on how to tune the transformation for better performance.
Data warehousing is a big subject. This overview is intended to cover some of the most representative issues on a high level: the nature of OLAP systems, star schemas, facts and dimensions, and differing perspectives (Inmon vs. Kimball) on warehouse design.
OLTP vs. OLAP
OLTP systems are the operational databases supporting applications. They are highly normalized, and focused on CRUD operations.
OLAP databases are usually arranged in star schemas and are built for speed in retrieving aggregated data.
In ASP.NET, the traditional way of uploading files is as follows.
<form id=”form1″ runat=”server”>
<asp:FileUpload ID=”FileUpload1″ runat=”server” />
<asp:Button ID=”Button1″ runat=”server” Text=”Upload”
<asp:Label ID=”Label1″ runat=”server”></asp:Label></p>
And you have access to the uploaded file like this.
protected void Button1_Click(object sender, EventArgs e)
In .NET MVC, you can achieve the same with the following code.
<form action=”/controller/action/” accept-charset=”UNKNOWN” enctype=”multipart/form-data” method=”post”>
<input id=”file1″ name=”file1″ size=”20″ type=”file” />
The controller side
foreach (string fileName in Request.Files)
HttpPostedFile file = Request.Files[fileName ];
It is important to understand the fundamental difference between the traditional web-form based .NET programming methods and the .NET MVC methods. You can still use the server controls, but you can only use them for read-only data rendering purpose, since ViewState is no longer an option in .NET MVC.
What is GZipStream and DeflateStream?
There are two basic compression methods that are exposed in the .NET I/O Framework i.e. System.IO namespace : GZIP and DEFLATE. They (Compression methods) are exposed via streams and support both compression and decompression (which ofcourse makes sense!).
Compression Streams in .NET
The compression streams in .NET support compression of streams with a maximum size of 4GB. You will have to break your file down if it is larger than 4GB. A drawback of the .NET compression methods is that you cannot compress multiple files into a single archive file, like you may be used to with WinZip or other similar tool. Atleast this is not avaialable out of the box.
Which one to use – GZip or Deflate?
Both these methods use the same compression algorithm (RFC 1952). But if you are going to be interfacing with other…
What is Isolated Storage and Why use It?
Putting it simply, an isolated storage is a “place” where an application can store its state information- things such as user settings, some assembly and application configuration information, and other application/assembly state information. So what is so different about that right?
Well a few things and some of these pertain to or relate to application and computer security. Let me explain, usually when an application tries to persist application state, it has to deal with user access rights, trust levels and so on. One way to resolve this is to give the application whatever rights it needs and potentially open up your computer to malware and spyware. Another way is to save information in the database. Now, the latter might be a viable option but in some cases complicates matters. Remeber when you just…
The BizTalk 2006 R2 Management Pack is a rewrite from the original pack for Microsoft Operations Manager 2005 (MOM). It is designed around all of the new features of BizTalk 2006 R2 including RFID and EDI. The pack ties into SCOM very nicely and once it has been imported into SCOM, it can automatically scan the network and will detect your BizTalk environment.
The main purpose of the pack is to
· Monitor BizTalk events
· Collect BizTalk specific performance counters in one central location
· Raise alerts on events
This pack is designed to provide the following services
· Availability Monitoring
This can detected a multitude of items with very little configuration. It will automatically detect if a send or receive port goes down, connection problems with the BizTalk database, messaging engine connection issues with the SSO database.
· Health Monitoring
You can use Health Monitoring rules to…
For those in the Connecticut area…
Tallan is providing a complimentary executive lunch around the topic of Microsoft Integration. It includes a talk by Tom Stickle, Program Manager at Microsoft for the Connected Systems Division, about the new integration features in BizTalk. In addition, there will be a real-life integration case study from a CT-based company.
The event will be held from 11:00 AM until 1:00 PM on June 10th at Lake of Isles in North Stonington, CT (part of the Foxwoods Resort), where an executive lunch will be served.
Here is the link to more information about this event and how to register.
I gave a presentation on BizTalk High Availability options to the New England chapter of the BizTalk user Group on May 14th.
Here is a link if you are interested in downloading the presentation (powerpoint 97-2003 format).
During my time with Tallan I have worked in both the MS camp and the Java camp. I prefer the Java side but I acknowledge that neither side is perfect. One of the main issues I see on the Java side is the huge variety choices that an architect has when starting a new project. I saw this article on DZone that seemed to summarize the situation well:
http://icedjava.blogspot.com/2007/12/dear-java-thanks-for-complexity-of.html [dead link]
There is an interesting link from this blog posting. I have not read it in depth. It looked good on an initial skim. The author seems to be trying to be objective, rather than selling one framework over another. (Go past the pictures of his family… would be interesting to hear the presentation that goes along with this PDF):
Comparison of frameworks:
https://equinox.dev.java.net/framework-comparison/WebFrameworks.pdf [dead link]
I am interested in hearing others point of view…