STDEV? STEDEVP!

Color-coding in SMSS just got me here… I needed to write STDEVP, but as soon as STDEV turned the right color, I went on to write the next expression, and didn’t get the results I expected. Bad Marcelo. In any case, the rule is fairly straight forward to remember (and you can always see the…

0

Fun with System.IO.Directory.Delete

So, here’s a small gotcha I ran into while using this API not too long ago. System.IO.Directory.Delete has some interesting nuances (what happens with mounts?) – it’s definitely worth reading. Something that is not currently in the documentation is the behavior when files or directories are marked read-only within. In short – the operation stops…

0

Dealing with renamed/localized user/group names with managed code

If you are a regular reader of Michael Kaplan (I know I am), you might have run across his What’s in a name? (once more) post. He comments on the use of localized account names and points to the KB 157234, How to deal with localized and renamed user and group names. For those of…

0

Transfer data to an Excel workbook programmatically

Just today I came across this excellent Knowledge Base article: How to transfer data to an Excel workbook by using Visual C# 2005 or Visual C# .NET It discusses a number of methods to get the task done, and seeing them all together in one page is quite handy. With the new Office Open XML…

1

Drag & Drop with attached properties? Must see to believe!

Pavan has a post about a framework to implement drag & drop with attached properties in Windows Presentation Foundation – most nifty. This is just the first post of a series, so be on the lookout for future posts. He actually has a large number of interesting posts dealing with WPF or related topics – very…

0

Character matching

For some background on this, let me refer you to Michael Kaplan’s excellent post at http://blogs.msdn.com/michkap/archive/2005/01/11/350482.aspx. Sometimes you will be an environment in which string comparisons don’t quite work like you expect them to. One thing to quickly rule out is that your strings actually have the values you think you’re looking for. select  cast(‘(text)’…

0

GiveFeedback event in Windows Presentation Foundation Drag/Drop

Although the documentation may not make it clear, GiveFeedback is an event that happens on the source side of a drag/drop operation. If you look at http://windowssdk.msdn.microsoft.com/en-us/library/system.windows.givefeedbackeventargs.effects.aspx, you’ll see that the arguments really have one interesting property, Effects, of type DragDropEffects (http://windowssdk.msdn.microsoft.com/en-us/library/system.windows.dragdropeffects.aspx). This property gives you information about what would happen if the user was…

2

Mary Jo Foley interviews Jim Allchin

Jim talks about the importance of componentization, why Windows XP SP2 was a service pack, and other thoughts on things that have been going on during the development of Windows Vista. Check out the first part of the interview here. One bit that I found interesting was his mention of all the releases that have…

0

WPF DragDrop sample and Viewbox – beware…

In a post a few months ago, I included a sample that showed how to use an adorner to display a ‘preview’ during a drag/drop operation. http://blogs.msdn.com/marcelolr/archive/2006/03/03/543301.aspx And yet… dire news came in – someone was having a problem with this. Someone played around with the display, and the adorner wasn’t following the mouse like…

1

Sergey Melnik’s papers and ADO.NET Entities

In case you have never seen this page before, you can find Segey’s page on Microsoft Research at http://research.microsoft.com/~melnik/. Here you will find some papers on subjects that are near and dear to what ADO.NET Entities is doing.

0