http://tech.brandonpetersen.com Software Development Fri, 18 Apr 2008 12:52:42 +0000 http://backend.userland.com/rss092 en If you are trying to get a TextBlock to right align, in ListView inside Windows Presentation Foundation  take a look at this.  I was using a GridViewColumn.CellTemplate to define a column with some monetary values in it. http://tech.brandonpetersen.com/2008/04/18/wpf-right-aligning-textblocks-in-a-gridview/ By default, WordPress only allows administrators and editors to view private posts. This WordPress plugin will allow you to determine which groups are able to see private posts by default. It will allow other authenticated users to view 'private' posts. View more details on the privatePlus page. http://tech.brandonpetersen.com/2008/03/10/privateplus/ The old phrase, 'Work Smarter, Not Harder' is a good one to live by. As software developers, we often find ourselves writing code that build strings. We start out simple, with a few lines of code that concatenates different text together to create a new variable. It's easy, ... http://tech.brandonpetersen.com/2008/02/20/benefits-of-using-the-stringbuilder-class/ This was a bit more complicated than the IF statements, but extremely useful.  I was able to Procedure [dbo].[deleteParticipant] @ParticipantID int as -- Declare the variables to store the values returned by FETCH. DECLARE @GroupID int DECLARE group_cursor CURSOR FOR SELECT GroupID FROM Participants WHERE ParticipantID = @ParticipantID OPEN county_cursor -- Perform the first fetch and store the values in ... http://tech.brandonpetersen.com/2007/06/13/using-while-statements-inside-mssql-stored-procedures/ Adding IF statements to a MSSQL Stored Procedure can help make a query more dynamic. For instance, if we had are deleting a participants from a group and wanted to remove a group after the last person was removed, we would do the following: DELETE FROM Participants WHERE ParticipantID = ... http://tech.brandonpetersen.com/2007/06/13/using-if-statements-inside-mssql-stored-procedures/ Here is a quick and dirty function that I grabbed from ( http://support.microsoft.com/kb/251354/ ). It does a nice job of replacing PHP's convenient str_replace. Private Function str_replace(ByVal strSource As String, _ ByVal strSearchFor As String, ByVal strReplace As String) As String Dim lngPointer As Long, strNew As String lngPointer = InStr(strSource, strSearchFor) If lngPointer ... http://tech.brandonpetersen.com/2007/05/31/net-replacement-for-phps-str_replace/ I always find myself hunting for a quick reference on formatting various strings, including time and dates in .Net.  Here is a great reference. .NET Format String 102: DateTime Format String http://blogs.msdn.com/kathykam/archive/2006/09/29/773041.aspx  http://tech.brandonpetersen.com/2007/05/18/time-and-date-formatting-in-net/ The Sitemap Protocol allows us to inform search engines when a page has been changed and is ready for crawling. The Sitemap file is a dynamically generated XML file that lists the URLs for a site. It allows search engines to crawl the site more intelligently. You can get ... http://tech.brandonpetersen.com/2007/04/27/submitting-the-sitemap-protocol-to-search-engines/ Kerning is the process of adjusting letter spacing in a proportional font. In a well-kerned font, the two-dimensional blank spaces between each pair of letters all have similar area. Wikipedia. To add kerning between each letter in Photoshop you place the cursor between the letters and press Option+RightArrow on a ... http://tech.brandonpetersen.com/2007/04/27/kerning-inside-photoshop/ I have to move databases between servers recently, doing a backup and restore. I had some issues arise from improper ownership of tables and store procedures in Microsoft SQL Server (MSSQL). I fixed the issue quickly through the following query: sp_changeobjectowner 'object', 'new_owner' http://tech.brandonpetersen.com/2007/04/25/changing-the-ownership-on-database-object/