May 2011 Entries

Setting up different emails on the windows phone

Here are some links I found useful when I was setting up mine:

Setting up multiple Hotmail account:  http://community.spiceworks.com/how_to/show/714

Setting up Gmail as the Outlook sync account:  http://www.google.com/support/mobile/bin/answer.py?hl=en&answer=138636

Posted On Thursday, May 26, 2011 10:36 AM | Comments (0)

Do NOT use only CHECKSUM or BINARY_CHECKSUM as sole comparison in SQL, use HASHBYTES instead

We had a process ot using BizTalk to take in a reference file, then send data in via a table_type parameter in a stored procedure. The stored procedure uses a MERGE statement to insert and update; the update part of which does a CHECKSUM first to determine whether an update is even necessary. Then it happened, we had a reference row that should have been updated by the latest file, but it wasn't done. We checked the incoming and outgoing BizTalk Message in and out of the pipeline; everything looked ......

Posted On Friday, May 20, 2011 8:50 PM | Comments (9)

Frustration and rewards on using SSIS Pivot and Unpivot

Granted, if you are just transforming data in the same SQL server, why would you do it in SSIS instead of just using Pivot and Unpivot in T-SQL query? But what about in the case where data comes from various sources? What I had fun doing was the ability to skip using Linked server, pull in data from different sources, like XML over web service. Another point that made me happy was the ability to simulate ROW_NUMBER() function with the merged data by using a Script Component. Anyway, I highly recommend ......

Posted On Friday, May 20, 2011 3:36 PM | Comments (0)

PowerPivot, Silverlight PivotViewer, Excel Services, Performance Point, Project Crescent from STL BI Use Group

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-... ......

Posted On Thursday, May 19, 2011 9:21 PM | Comments (0)

BizTalk documentator

This looks like a very useful tool: Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... ......

Posted On Friday, May 6, 2011 11:53 AM | Comments (0)

Windows Azure Marketplace DataMarket

One stop shop for data:  https://datamarket.azure.com/

SQL Azure Labs >> Configure OData Services

 

http://www.odata.org/

Posted On Thursday, May 5, 2011 3:35 PM | Comments (0)

Windows Azure Cloud Computing Scenarios Notes

Windows Azure Cloud Computing Scenarios Notes: (http://wabcdemos.cloudapp.... Things to consider for architecture: Does It improve bottomline? http://azureroi.cloudapp.net/ http://www.microsoft.com/wi... Does it improve strategy? Independent scaling break down components into the smallest unit When increasing capacity, cost doesn't go up much, when scaling down, capacity doesn't suffer a huge drop ......

Posted On Thursday, May 5, 2011 3:35 PM | Comments (0)

Windows Azure Diagnostics Notes

Windows Azure Boot Camp: Diagnostics (http://wabcdemos.cloudapp.... Remote desktop MonAgentHost.exe starts Auto, listener wired up in app/web.config Need to define a storage account User can set quota Source to Storage: Example: Trace log to Azure Table; IIS Logs to Blob; Windows Event to Azure Table, Crash dump to Blob, ... Load Diagnostic Agent <Imports><Import moduleName="Diagnostic" /></Imports> OnStart({DiagnosticMonitor.... TransferFilterLogLevel and ......

Posted On Thursday, May 5, 2011 2:13 PM | Comments (0)

Windows Azure Queue Notes

Windows Azure Boot Camp Note: http://wabcdemos.cloudapp.net/ Queue name must be lower case Unlimited number, but limited to 8kb in size must be serializable as XML GC runs once a week Producer to Consumer Example: WebRole PutMessage() to Queue, WorkerRole GetMessage(optional Timeout), (or/then, this part is unclear as to why I have to do this) RemoveMessage() (Q: Does this mean GetMessage, after successful, puts the message back on queue? That should not be right. From the notes I get, there is no ......

Posted On Thursday, May 5, 2011 11:02 AM | Comments (0)

Windows Azure Drives Notes

Notes from Windows Azure Drives: http://wabcdemos.cloudapp.net/ Why use this? One example is to satify PDF requirement (PDF files require a local temp drive) Durable NTFS drives Can be up to 1TB Commands: CloudDrive.InitializeCache() account.CreateCloudDrive() Must use Flush() to persist data Guidance: store key in config, encrypt it wrap key with service ......

Posted On Thursday, May 5, 2011 10:08 AM | Comments (0)

Windows Azure Blob Notes

Notes from Windows Azure Boot Camp: http://wabcdemos.cloudapp.net/ Blob: Metadata, not searchable, must loop through to check Block Blob, 200GB limit Page Block, 1TB limit Upload block blob PutBlock (bloblName, blockId1, block1Bits) PutBlock (blobName, blockId2, block2Bits) ... PutBlock (n...) PutBlockList(blobName, blockId1, blockId2, ..., blockIdN) Currently no data validation Page Block Random Read/Write Work with random chunks (so can work with smaller chunks, but can over-write data) Container ......

Posted On Thursday, May 5, 2011 10:00 AM | Comments (0)

Windows Azure Tables notes

Notes from camp: http://wabcdemos.cloudapp.net/ CreateCloudTableClient() CreateIfNotExists DeleteIfExists CreateTable Create Partition Key (don't use identity key as partition key) Create Row Key, must be unique per PartitionKey Use a lightweight copy to improve performance Use "batching" to increase performance, and also save money by reducing the number of transaction For example, ???Context.SaveChanges(Save... Queries Over 30 second is cancelled result > 1000, a continuation ......

Posted On Thursday, May 5, 2011 9:03 AM | Comments (0)

Thanks to my wife for a dream machine

2 months ago I learned that there is going to be a Windows Azure Boot Camp, free, 2-day, code-intensive. The only catch at the time for me was that I didn't have a laptop, a requirement for this camp. Thanks for my beautiful and tolerant wife, we provisioned and I got my dream machine. Waited and shopped for a long time to get a reasonable price, but I got the following spec: 8GB ram Necessary for me to run my virtual environments i-5 4-Core CPU Want 4-core for virtual environments, but not a fan ......

Posted On Thursday, May 5, 2011 8:39 AM | Comments (0)

Windows Virtual PC vs. Hyper-V Virtual Machines vs. Windows Virtual PC after XPMode installation Advantages and Disadvantages

Hyper-V Virtual Machines Advantage: 64-bit support dynamic memory allocation multi-core CPU Can install Windows 7 and Windows Server 2008 and later Disadvantage: Can't get sound to work on those machines yet [Updated 2011-05-05] This is disappointing, but I guess it fits most people's requirement as most people don't use Hyper-V for personal development environment. Guess I'll just have to set up those machines for remote connect. http://sqlblog.com/blogs/jo... ......

Posted On Thursday, May 5, 2011 8:29 AM | Comments (0)

Azure Code Boot Camp

This is Day 2 of Microsoft Windows Azure Boot Camp.  Yesterday was excellent, can't wait for the events today.  One thing I do regret was not writing blogs about each topic yesterday; a mistake I will not repeat today.

For people who missed it, here is the link:  http://wabcdemos.cloudapp.net/

Posted On Thursday, May 5, 2011 8:14 AM | Comments (0)

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski