Category Archives: Programming

High Availability with SQL Server and Double-Take – the links

In 2008, Steve Warren with TechRepublic created a 3-part blog post with details of how to configure Double-Take software to protect SQL Server. The 3 parts are not mutually linked to each other. Here are links to all three parts: Part … Continue reading

Posted in Programming, SQL Server, System/DB Administration | 1 Comment

Typo of the day

Refactoring a local variable to a stored procedure parameter resulted in this sillyname. From: DECLARE @operator To: @pOoperator Firstly, they’re loaded with soluble fibre, which helps push excess cholesterol through your digestive system before viagra without prescription donssite.com it can … Continue reading

Posted in Programming, Quote of the Day | Leave a comment

PDF customization links

Thanks to Google, here are some People are using e-mail blasts to sell sex, drugs and other items of less than 1.00 per pill. order generic levitra http://acupuncture4health.ca/treatments/traditional-chinese-medical-assessment/ Regardless of what time you log in you’ll realize one or the … Continue reading

Posted in Programming | Leave a comment

Easy way to apply filter to DataTable

Problem: Cannot directly apply a filter to a datatable. The application requires dynamic filtering for various criteria, altered at runtime by the user. Re-querying the database is not feasible; filters must be applied at the client upon a local DataTable. … Continue reading

Posted in C#, Programming | Leave a comment

OMG, CTE TVF and UDF

O M G. https://www.simple-talk.com/sql/t-sql-programming/sql-server-apply-basics/ SO, SO helpful to understand how to restructure the LEFT OUTER JOINs in my Common Table Expression (CTE) to instead use User Defined Functions (UDFs) that return Table-Valued Functions (TVFs). Mr. Sheldon’s article brought everything together for me. My CTE … Continue reading

Posted in Programming, SQL Server | Leave a comment

Some free C# charting components / tools

Free C# Grid/Graph component http://stackoverflow.com/questions/433729/free-c-sharp-grid-graph-component Best Free Controls for .NET [closed] http://stackoverflow.com/questions/361271/best-free-controls-for-net Which .net charting library should I use? http://stackoverflow.com/questions/3201977/which-net-charting-library-should-i-use ZedGraph: A flexible charting library for .NET http://www.codeproject.com/Articles/5431/A-flexible-charting-library-for-NET   Besides, the way that buy Kamagra viagra soft tabs online can … Continue reading

Posted in C#, Programming | 1 Comment

Time to see what the other side is doing (moving from windows forms development to web apps)

I’ve been coding winforms for internal use. For the most part, I stick to professional standards, but I am willing to release less-polished applications than if I were selling them. Part of the implication of this is that I don’t … Continue reading

Posted in C#, Programming | Leave a comment

Replacing SSMS

Phil Factor’s thought-provoking article “Cold Turkey with SSMS” on a way to replace SQL Server Management Studio: https://www.simple-talk.com/blogs/2008/10/14/cold-turkey-with-ssms/ I am in a position where it would be NICE to have a replacement for SSMS, but I lack the time and budget to build or buy a … Continue reading

Posted in C#, Office, Programming, SQL Server, System/DB Administration | Leave a comment

Remove bold formatting from copied DataGridView column headers

When copying from DataGridView and pasting to Excel, the column headers were bolded. This was undesirable, requiring a manual Paste Special… as Text or Unicode Text every time data was copied. This problem was resolved by adjusting the clipped data’s … Continue reading

Posted in C#, Programming | Leave a comment

Heads-down data entry into a list

This is a concise, user-friendly way to add intuitive functionality to a form that controls one or more lists of entries. It is optimized for 10-Key operators but will also work for QWERTY-mode users. Drop a Textbox and a Listbox onto the … Continue reading

Posted in C#, Programming | Leave a comment