Scott Elkin

Category: Programming

  • Outlook Auto-Complete Emails

    In the “That’s it I can’t take it anymore department”, It really ticks me off when I start to type a name in my Outlook “To” field and it sticks in the wrong email address for the person EVEN THOUGH their correct one is stored in my Contacts. I land out emailing people at the…

  • Microsoft Codenames

    After reading the session synopsis’ for the PDC, I realized how many codenames Microsoft uses for their upcoming technology. So I made a list: indigo atlas longhorn yukon whidbey avalon orcas blackcomb I realize some of these are no longer used by MS, but I still see them referenced. Update: Found this Codename Lookup Chart…

  • PDC 2005

    I was looking at the sessions, and well, I mean, they kinda suck. Seems A LOT of WinFX and Longhorn…which are years away…am I missing something? I have been planning to go for a long time, but if they don’t change something, I can’t justify it. Microsoft, please understand that in order for me to…

  • Community Server uses some ASP.NET 2.0

    Pretty cool those guys are, thinking ahead and all. I just noticed that my CS 1.0 database has all (or near all, not sure) the tables and stored procedures that get installed for ASP.NET 2.0 membership, profiles, role management and personalization. To get it in your database, assuming you have the 2.0 framework installed is…

  • Print PDF Documents That Disable Printing

    I received a question of how to print a PDF that does not allow you to print it. This worked for me: Download and install Ghostscript. Download, install and run GSView. Open GSView and open the PDF document you can’t print. File –> Print like you normally would.

  • Fun with #region

    I am not sure if I did this on accident, or my intern did it, but I found this in my code: #region Constructors//code here #endregion Constructors I was not aware you can put a tag after #endregion. Kind of nice to clearly delineate long regions. Not that it really matters, but Visual Studio allows…

  • Learning C# over VB.NET

    I just finished writing a long 'ol email to a friend who wants to do a project in VB.NET since his background is in legacy ASP. Although my points have been illustrated by many over and over, I thought I would post what I wrote in the hopes others can add to my list. I…

  • Using SQL Where Clauses for Searching

    One piece of SQL lore I take for granted is COALESCE(). The dictionary definition describes SQL's use pretty close as “To bring or come together into a united whole”. Books Online states in laymans terms that SQL allows you to pass any number of arguments to the function, and it will return the first non-null…

  • Retrieving Values from SQL Exec()

    Never had a good reason to do this up until now, but if you need to get a value from a generated sql string, there are a few hoops you must jump through. Example: declare @table varchar(20) ,@username varchar(30)–can't use double quotes w/out this :)SET QUOTED_IDENTIFIER OFF–set your variablesselect @table = 'tblcustomers' ,@username = 'webmaster'–create…

  • Sql Dependencies

    This is a rad sproc to find dependencies from Brett. Sometimes I come across a sproc that I *think* I can delete but you never can be too sure. This makes that process A LOT easier. I am reposting it here for my own benefit with some slight formatting differences to make it easier for…