CodeProject Articles - Summary

• Grid & Data Controls
  
  • DataGrid and DataView
    
    • How to Create ProgressBar Column in DataGridView
      
• Web Services
  
  • General
  • Saving Files Into Database Using .NET Web Services
    
• Database
  
  • SQL Server
  • SQL Server 2008 - Backup and Restore Databases using SMO
  • SMO Tutorial 1 of n - Programming data storage objects
  • SMO Tutorial 2 of n - (Programming Objects Not Used for Data Storage)
  • SMO Tutorial 3 of n - Scripting
  • SQL Server Database Comparison Tool
  • Database performance optimization part 1 (Indexing strategies)
  • Database performance optimization part 2 (Index maintenance)
  • Library for scripting SQL Server database objects with examples
• Algorithms & Recipes
  
  • Neural Networks
    
    • Single Layer Perceptron as Linear Classifier
  • Sorting
    
    • Visualization and comparison of sorting algorithms in C#

New articles on CodeProject.com: Database performance optimization (part 1 and part 2)

Before a couple of weeks I have posted first part of series of articles about database performance optimization. The first part is about indexing strategies and how to choose appropriate indexes. Second part discuss about maintenance of indexes. More about indexes you can find here:

• Database performance optimization part 1 (Indexing strategies)
• Database performance optimization part 2 (Index maintenance)

New article on CodeProject.com: Visualization and Comparison of sorting algorithms in C#

Before a couple of days I have posted new article about sorting algorithms and visualization. More about that you can find here

• BiDirectional Bubble Sort
• Bubble Sort
• Bucket Sort
• Comb Sort
• Cycle Sort
• Gnome Sort
• Heap Sort
• Insertion Sort
• Merge Sort
• Odd-Even Sort
• Pigeonhole Sort
• Quick Sort
• Quick Sort with Bubble Sort
• Selection Sort
• Shell Sort

New article on CodeProject.com: SMO Tutorial 2 of n - (Programming objects not used for data storage)

Before a couple of days I have posted new article on CodeProject.com. This is the second article from series of articles about Server Management Objects (SMO) and programming tasks using SMO.

• Introduction
• Background
• Logins
  
  • Enumerating SQL Server logins
  • Creating SQL Server login
• Users
  
  • Enumerating database users
  • Creating database users
  • Assigning role to database user
• Roles
  
  • Enumerating database roles
  • Creating new database role
• Server permissions
• .NET Framework Assemblies

New Article on CodeProject.com

Before couple of days I have posted a new article on CodeProject.com. In this article I will show you, how to backup and restore databases using SMO. More about that you can find here: http://www.codeproject.com/KB/database/SQLServer_Backup_SMO.aspx

CodeProject Articles

A few weeks ago I have posted 2 aricles. First article was about saving large files into SQL Server using ASP.NET webservices and the second one was about customizing a DataGridView.
Saving Files Into Database Using .NET Web Services
How to Create ProgressBar Column in DataGridView