Click here to Skip to main content

Submit your article

Best practices

best-practices

Great Reads

How to Hook 64-Bit Code from WOW64 32-Bit Mode

by Apriorit Inc

Being able to switch between 32-bit and 64-bit modes in Windows is a useful skill. Learn about the heaven’s gate technique and the tools and methods needed for hooking 64-bit processes from the 32-bit WOW64 mode.

The Real Answer to the FizzBuzz Interview Question

by John M. Dlugosz

Here is the real answer to the FizzBuzz interview question

Version Control: Effective Use, Issues and Thoughts, from a Gamedev Perspective

by Ashley Davis

A look at version control from the game developers perspective

Error Handling Concepts (Again)

by John M. Dlugosz

“Whither exception handling?” We have come full circle.

Latest Articles

The Software Rewrite

by Greg Utas

Open-heart surgery on your Big Ball of Mud

How to Hook 64-Bit Code from WOW64 32-Bit Mode

by Apriorit Inc

Being able to switch between 32-bit and 64-bit modes in Windows is a useful skill. Learn about the heaven’s gate technique and the tools and methods needed for hooking 64-bit processes from the 32-bit WOW64 mode.

Restrict Access to SQL Server Data using a Facade Database

by Shameel

This article describes a way to create a Facade Database to provide restricted access to specific tables in your databases to specific users without granting direct access to any of the underlying databases/tables.

What Makes A Software Programmer a Professional?

by Rob Kraft

Best practices that software professionals follow most of the time

All Articles

Best practices

How to Hook 64-Bit Code from WOW64 32-Bit Mode

23 Mar 2020 by Apriorit Inc

Being able to switch between 32-bit and 64-bit modes in Windows is a useful skill. Learn about the heaven’s gate technique and the tools and methods needed for hooking 64-bit processes from the 32-bit WOW64 mode.

The Real Answer to the FizzBuzz Interview Question

20 May 2018 by John M. Dlugosz

Here is the real answer to the FizzBuzz interview question

coding-challenge

What is the best practice to search in SQL server with large data for a string

7 Sep 2016 by NaibedyaKar

I feel you show go for full text indexing.Read more from Understanding Full-Text Indexing in SQL Server - Simple Talk[^].Above to that you can implement fuzzy search algorithm for approximate string matching.

Version Control: Effective Use, Issues and Thoughts, from a Gamedev Perspective

10 Oct 2016 by Ashley Davis

A look at version control from the game developers perspective

Best Practices - three tier arhitecture, sort and pagination

10 Nov 2015 by Hanzaplast

i have three tier arhitecture in web app (asp.net)should sort and pagination be in presentation layer or business logic? //Search.aspx.cs public void SearchProjects(int recordCount) { var data = DAL.GetData(); var filtered =...

Best Practices - three tier arhitecture, sort and pagination

10 Nov 2015 by F-ES Sitecore

"It depends". What does GetData return? If it returns an IQuereable or IEnumerable such that the query hasn't yet been issues by the time it gets to the presentation layer then you could do the paging\sorting at the presentation layer.If GetData actually retrieves all data and returns it...

What is the best practice to search in SQL server with large data for a string

7 Sep 2016 by JPais

Hi everyoneI wanted to know that what may be the best practice to search for keywords or sentence in sql server.Suppose I have a table say products with name, description and keywords. I have a search function in my website where the user may type in anything (sentence or single word)....

What is the best practice to search in SQL server with large data for a string

29 Aug 2016 by gregorio89

I used your second solution for a similar problems.You can add a index to the fields containing the word searched and do this :select srno as productid, name +' '+ descriptions +' '+ keywords as searchfrom ProductDetails as PDwhere PD.search LIKE '%bed%' OR PD.search LIKE...

How to implement keyword search in ASP.NET and SQL server

16 Oct 2016 by JPais

Hi EveryoneI am working on a blog type project where I need to set up search for articles.I am using sql server and asp.net. I have set up search using article name and some keywords or tags related to the article.My issue is how to set up keywords or tags list for a particular...

How to implement keyword search in ASP.NET and SQL server

16 Oct 2016 by Wendelius

Not sure if I understand your question correctly but:Why do you store the tags/keywords inside a single column? I would split them into separate rows. Storing them as comma separated list will cause you problems in both logic and performanceDepending on the definition tags represent a...

How can I reuse the same gridview user controls in multiple forms

4 Jul 2017 by KarstenK

Controls have the property visible to show or hide them. And it is easy to call some different stored procedures. That is an easy way to switch the UI. Make a flag to know in which state your app is. But my experience is, when the views are to different (or more than 2) it often gets awkward or...

Appendiing a large chunk of HTML in a jqueery plugin

18 Nov 2017 by Mike Hankey

More of a best practices question. I'm creating a jquery plugin and I want to append a fairly large amount of html into a panel in the panel-body section. I've got it working by using; var res = '';...

Error Handling Concepts (Again)

17 May 2018 by John M. Dlugosz

“Whither exception handling?” We have come full circle.

Full deployment vs incremental deployment pros/cons

13 Feb 2019 by Surender Singh (CodeToastDev)

I work in a team that heavy supports full deployment procedures for .NET application maintenance projects. That means taking everything from TFS, build it and dump it on the Web server. It also requires overloading TFS with keeping every file from website including images, third party dlls, temp...

Full deployment vs incremental deployment pros/cons

13 Feb 2019 by Richard MacCutchan

Best deployment strategy[^].

Timing is Everything

4 Feb 2018 by V.

A guide to estimating work and time for a project

project-management

How Much Engineering Does My Software Need?

3 Mar 2018 by Anonymee

Overengineering vs. underengineering - a guideline to prevent them both

SQL CASE WHEN condition THEN NumericColumn ELSE 0 END

7 Jun 2017 by Niemand25

Be careful with CASE WHEN when dealing with numeric columns and using zero literal

The Software Rewrite

4 Mar 2022 by Greg Utas

Open-heart surgery on your Big Ball of Mud

project-management

Restrict Access to SQL Server Data using a Facade Database

7 Sep 2019 by Shameel

This article describes a way to create a Facade Database to provide restricted access to specific tables in your databases to specific users without granting direct access to any of the underlying databases/tables.

Permutation Puzzle: “send+more=money”

17 May 2018 by John M. Dlugosz

“Know your libraries!” You may already have the code you need.

Refactor Like a Boss: Break the Classes

18 Apr 2016 by debashishPaul

A tip for getting the most out of your refactoring practice

Project Post Mortems

11 Jan 2016 by Kirk 10389821

You can learn something from every project!

Application Architecture - What's The Matter With Being STUPID Before Being SOLID

24 Apr 2017 by Habibur Rony

This topic will cover the bad design practice using STUPID and good design practice using SOLID. Detailed explanation for Single Single Responsibility Principle, Open and Closed Principle, Liskov Substitution Principle, Interface Segregation Principle and Dependency Inversion (DI) Principle.

design-patterns

What Makes A Software Programmer a Professional?

6 Aug 2019 by Rob Kraft

Best practices that software professionals follow most of the time

Optimization Fever!!!

21 Feb 2018 by Charles Oder

To optimize, or not to optimize, that is the question...

language-agnostic