Friday, January 25, 2013

How to add breaklines to a string in C#

Problem: I'm working on a website that is generating a contiguous block of text for a reg key. This is then copy and pasted into the client software. The problem is the client software textbox doesn't really wrap text. My solution is to insert newlines into the block of text at a specified length so that when it's copy and pasted it does so with the newlines and doesn't look like crap.

Thursday, January 3, 2013

How to edit more than the default 'Edit first 200 rows' in SQL server

The default option in SQL Server for editing the table through the SSMS UI is 200 rows. Luckily that's a setting you can change!

1. In SSMS > click Tools > Options
2. Expand SQL Server Object Explorer > Commands
3. Modify the number to anything you want and save. 0 = all rows

Tuesday, January 1, 2013


2012, a year of many self-improvements and self-destructions. Overall, a great year, happy to have experienced all of it, even the madness of the situation I'm currently facing. There is one thing I've discovered about myself, I'm extremely resilient when faced with seemingly life-ruining challenges.