Geeks With Blogs

  • tfanshteyn Awesome: tracert about 775 days ago
  • tfanshteyn RT @AdviceMallards When searching plane tickets online, delete your cookies. Prices go up if you visit a site multiple times. about 780 days ago
  • tfanshteyn RT @unhealthytruth Junk food costs about $1.76 per 1,000 calories versus $18.16 per 1,000 calories for nutritious foods about 803 days ago
  • tfanshteyn RT @NYCSchools Just announced: School days lost due to #Sandy will be made up February 20-22 and June 4. about 858 days ago

An educated guess (Timur Fanshteyn) Technology, Software Development and other ways to make an educated guess about the world... Tips There are 10 entries for the tag Tips
SQL ROW_NUMBER() function and Audit tables
I had to search through an audit table to find times when the value changes in a specific field. Considering an audit table DateModified DateTime ID varchar() Quantity decimal Price decimal I wanted to find the rows when Quantity changed for the same ID. I've been able to accomplish that using the ROW_NUMBER function of SQL 2005 Here's the query: select Row_Number() OVER (PARTITION BY ID Order BY ID, DateModified) as RowID, DateModified, Quantity, ID INTO #TempData from AuditTable select a.ID, b.DateModified, ......

Posted On Thursday, April 10, 2008 6:16 AM

Yuneta's Blog
A friend of mine started a blog and started posting nice support entries. http://yunetasblog.blogspot... Technorati Tags: Blogs, Tips CrossPosted from ......

Posted On Thursday, April 10, 2008 6:15 AM

Sara Ford's WebLog : Did you know... You can use Shift+ESC to close a tool window - #142
Sara Ford's Tips Blog is an excellent source of tips. This one especially helpful for me. Sara Ford's WebLog : Did you know... You can use Shift+ESC to close a tool window - #142 Technorati Tags: Blogs, Microsoft, Tips, Visual Studio Cross Posted from ......

Posted On Sunday, February 3, 2008 10:10 PM

WCFTestClient - a testing utility from Visual Studio 2008
I stumbled upon an excellent utility for WCF Testing that comes with Visual Studio 2008 - WCFTestClient. The tool is an simple way to test WCF clients HTTP and TCP bindings. Some things are not supported, however, for basic WCF Testing, this definitely beats the old ASMX test page. Note: Also check out the WCFSvcHost utility from Visual Studio to host an arbitrary WCF Service. Technorati Tags: Debugging, Development, Microsoft Office, Tips, Tools, WCF, Visual Studio Cross Posted from ......

Posted On Tuesday, January 29, 2008 8:59 AM

Customizing SCSF Guidance Package for Modular Development
One of the requests that I've received from other developers is the ability to use SCSF for developing a module without including the shell in the solution. We develop a large number of modules independently in different groups and having the shell be a part of every module was getting to be a problem. The only issue that I was getting with getting this to work was that SCSF guidance package would fail in ViewTemplateCS when I would right click on a folder and tried to add a new view to the project. ......

Posted On Friday, January 11, 2008 10:29 PM

Fixing WCF/WPF VS 2005 Extensions installation after installing VS 2008 or .NET 3.0 SP1
I've encountered a problem trying fix the WCF / WPF Visual Studio 2005 Integration components after I've installed Visual Studio 2008. Installing a VS 2008 will install .NET 3.0 SP1 and remove the installation of .NET 3.0. When trying to install the WCF / WPF Extension, installation display's a message Setup has detected that a prerequisite is missing. To use Visual Studio 2005 extensions for .NET Framework 3.0 (WCF & WPF), November 2006 CTP you must have the .NET Framework 3.0 runtime installed. ......

Posted On Tuesday, January 8, 2008 8:25 AM

Compiling .NET 3.5 code to .NET 2.0 Works
This is something that is totally cool. You can use Visual Studio 2008 and a lot of the new functionality and cross compile it to .NET 2.0 and run it on the older framework. For Example, You can use Var objects, Simple Property Declarations, Property Constructors, Lambda expressions Here's an example program that can be compiled with VS 2008 to the .NET 2.0 framework static class Program { private class Client { public string Name { get; set; } public string Address { get; set; } } private static ......

Posted On Thursday, December 20, 2007 11:30 PM

Calculating Hashvalues for files the way .NET does for the Application Manifest
I had to write a custom download component to download modules for a ClickOnce deployed application. The actual downloading is simple, the tricky part was creating the manifest and make sure that I only download files that are required. I am using an GeneraApplicationManifest MSBuild task to generate an application manifest. The documentation is very easy to follow. The generated manifest will include a Hash value. It is fairly simple to compute the same hash value manually and be able to validate ......

Posted On Thursday, December 20, 2007 10:50 PM

Subversion pre-revprop-change hook
Another small batch file hook for those running subversion on windows. This hook will allow users to update a log message on the old check-in. Note: Property changes are not versioned, so you will permanently loose the old message. Place this in a pre-revprop-change.cmd ------------- IF %5 EQU M GOTO CONT1 GOTO FAIL :CONT1 IF %4 EQU svn:log GOTO OK :FAIL echo "Changing revision properties other than svn:log is prohibited" >&2 exit 1 :OK exit 0 ------------ Technorati Tags: Subversion, ......

Posted On Wednesday, December 5, 2007 4:52 PM

Subversion pre-commit hooks
I am using a great source control product Subversion. More information is available on A great future of subversion is an ability to run a server script before the check-in is committed . The script has the ability to rollback the check-in. We are using this functionality to enforce comments for every check-in. To create a script, place any executable file into a hooks folder in the repository. You can start with a ... Read full article Technorati Tags: Development,Subversion,Tips... ......

Posted On Thursday, November 22, 2007 10:14 PM

Copyright © Timur Fanshteyn | Powered by: | Join free