# Saturday, May 26, 2007

If you will be at TechEd in Orlando, I will be doing the session: Database Design Patterns on Monday and I was just told that we will repeat it Thursday afternoon as well.

The session is a great sesson. It is listed on the Architecture track. We won't be talking about data modeling but we will be talking about how to design the right database structure for the right situation.

I have 5 demos:

1. A Slowly Changing Dimension

2. Fact Tables

3. Horizontal Partitioning

4. SQL Server 2005 Table and Index Partitioning

5. Vertical Partitioning







Database Design Patterns: Architecting the Right Data Model for the Right Application

6/4/2007 4:45PM-6:00PM

N310 A

Architecting an application starts with the database. Different applications need different data models. Fifth normal form is great for an OLTP database, but reporting databases need more of a flat denormalized structure and different Web sites need several different types of data models: eCommerce sites need different data models than traditional publishing sites. You need to optimize your data model for your application's performance needs. Concurrent users, data load, transactions per minute, report rendering, and query seek time all determine the type of data model you will need. See how different applications and different parts of an application can use different data models and how you can architect your database to fit into your application's needs—not the other way around.



posted on Saturday, May 26, 2007 10:08:38 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Wednesday, May 16, 2007

Take a look at Andrew's and my book in French, Polish and Italian!


posted on Wednesday, May 16, 2007 1:39:02 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Tuesday, May 15, 2007

Office 2007 Open XML Format




You must register at http://www.clicktoattend.com/?id=118567 in order to be admitted to the building and attend.

Open XML is the default document format for the upcoming Office 2007 system. This presentation explores the motivation and design consideration of the new format. It also analyzes the architecture and the conceptual framework of Open XML. This new format opens doors to a huge number of opportunities for developers regardless the development tool or targeted platform. Package API from the new .NET Framework 3.0 is used as an example to demonstrate how to programmatically read/write Open XML documents without resorting to Microsoft Office COM API.

Speaker:  Dr. Hai Ning, Senior Software Architect, Tallán Inc

Hai Ning has over 10 years of software development experience, with MCST(BizTalk & SQL2005), MCSD.NET, MCDBA and SCJP certifications. Dr. Ning graduated from MIT with a PhD in Information Technology. His blog can be found at http://www.hyperbina.com/blog. Hai's firm, Tallán (http://www.tallan.com), is a Hartford-based Microsoft Certified Gold Partner.

Date:  Thursday, May 17, 2007

Time:  Reception 6:00 PM , Program 6:15 PM

Location:   Microsoft , 1290 Avenue of the Americas (the AXA building - bet. 51st/52nd Sts.) , 6th floor
Directions: B/D/F/V to 47th-50th Sts./Rockefeller Ctr
1 to 50th St./Bway
N/R/W to 49th St./7th Ave.

posted on Tuesday, May 15, 2007 2:19:27 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Wednesday, May 9, 2007

I got a brand new Zune for Christmas. Anyway, subscribing to Podcasts on a Zune has been, well challenging. Actually almost impossible for mere mortal. I have figured out how to do this and will explain it below. Before I do that, I have to tell you a story.

I found a great Podcast courtesy of my friend Robert Lazo. It is the Stanford University Educational Corner’s Entrepreneur Podcast. It has great content. (BTW, it this content interests you, here is the link.)

I downloaded it to my Zune and after I listened to a few of the Podcasts, I told Kathleen that she needs to listen as well. She has an iPod. But she was too lazy to download them to her iPod so she kept borrowing my Zune. After not finding my Zune where I left it the other day I suggested that she just subscribe to the Podcast. She did. Boom, just like that I sent her the link and 1.3 gigs of data started downloading to her device in a very organized manor.

Not so easy with the Zune. So here is what I had to do.

Step 1. Subscribe the RSS feed manually via Internet Explorer 7.0

After I paste in the link to the RSS feed into the browser, IE 7.0 allowed me to subscribe to it. Since I am running Vista and Office 2007, the RSS feed tried to show up all over the place, the annoying sidebar and downloading in Outlook. (As if Outlook 2007 isn’t slow enough.)

Step 2. Setting up the Feed to Automatically download the content

You have to then click on the “view feed properties..”  link to bring up the properties dialog. Here you have to check the box that says “Automatically Download Attached Files.”

Step 3. Finding where IE decides to put your files

Next you have to find out where IE will store the downloaded content. You can do this via selecting the “View Files” button. This will open the folder where IE stores your content. Copy the location from your Windows Explorer address bar. Here is where IE stores it on my computer: C:\Users\StephenForte\AppData\Local\Microsoft\Windows\TemporaryInternetFiles\Enclosure\{620E20DE-0D04-449C-B2FD-B0E9B19C852B}

Step 4. Adding that Folder to Zune’s Library

Open your Zune software and select Options|Add Folder to Library from the main menu. At this point you can see what folders Zune syncs and you will have the opportunity to add the folder.

That’s it. Just four painful steps. There are also many other problems. If you clean out your temporary internet files, you lose your podcasts and have to start over with the downloads. Also once you listen to a podcast, Zune and IE have no idea that you don’t want it anymore.

Luckily there are some 3rd party tools to help with this problem, like FeedMyZune. They basically do a version of what  I just did behind the scenes for you. You may want to try that.


posted on Wednesday, May 9, 2007 4:56:30 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback