Best Database Article of March 2017

This competition has ended

Overview
Entries
Participants
Winners
Prizes
Rules

Contribute to CodeProject and you'll automatically be in the running for a monthly prize!

Each month at CodeProject we gather together the best of the articles submitted the previous month and ask our readers to choose the best of the best. Entry is automatic - just submit you articke and we'll do the rest.

Check out the submission guidelines for information on posting articles.

Current Entries

Articles that match the contest criteria are automatically entered.

Software Principles and Patterns Revisited

28 Feb 2017PureNsanity

Fundamental aspects of software design and understanding individual elements of principles and patterns

DBA

Dev

Architect

design-patterns

architecture

SPA^2 using ASP.NET Core 1.1 + Angular 2.4 - Part 5

16 Mar 2017Robert_Dyball

Create a simple data grid that provides list, add, edit and delete and uses a simple 'parent/child' template to provide view, edit or add functionality

Insert Multiples Records to SQL Server Database

15 Mar 2017Ricardo_Torres_Torres

Read text file and insert mutiples records in just one SQL Sentence

Oracle-Style Global Temporary Tables for PostgreSQL

20 Mar 2017AlexeyYakovlev

A library to emulate Oracle-style permanent temporary tables in the PostgreSQL database

SQL

PostgreSQL

Oracle

Hello World Angular 2+ Data Sample Using JavaScriptServices .Net Core and PrimeNG

13 Mar 2017defwebserver

You can create database driven .Net Core applications using JavaScriptServices, and PrimeNG.

Making an Event Calendar for Trucking/Shipping with C# MVC and jQuery.Fullcalendar

10 Feb 2018Changming Wang

A complete event calendar, using trucking/shipping as an example, built with Visual Studio Community 2015, C# MVC and jQuery.Fullcalendar

Change Tracking Example -SQL Server

1 Mar 2017Neeraj Kaushik1980

Following are the step by step instructions to enable and use the change tracking feature in SQL Server.

SQL-Server

FileTime to DateTime and Back in MySQL

16 Mar 2017Smirnov Pavel

How to convert FileTime to DateTime and back in MySQL

Windows

MySQL

Insufficient SQL Database Permissions for User 'Name: doman\SP_UserProfiles SID:

13 Mar 2017Melick

Insufficient SQL Database Permissions for User 'Name: doman\SP_UserProfiles SID:

SQL

SQL Puzzle: How to Rank Student Scores

25 Mar 2017essentialSQL

How to identify the top and bottom 25 percent to rank student scores

SQL

WCF

SQL Puzzle: How to Calculate Moving Averages

25 Mar 2017essentialSQL

How to calculate moving averages

SQL

WCF

Introducing SQL Clone

10 Mar 2017Redgate Software

SQL Clone exploits the existing virtualization technology within Windows to take much of the sting out of the traditional problems surrounding database provisioning.

Store View State in SQL Server

13 Mar 2017yuvalsol

Keep the view state out of the web page and store it in SQL Server

Writing a Blog Engine in ASP.NET Core

27 Mar 2017Tyler Rhodes

Reflections on writing a simple blog engine in ASP.NET Core with Entity Framework Core

Processing Loops in SQL Server

31 Mar 2017CHill60

Alternatives to using procedural loops in Transact SQL, demonstrated by examples.

SQL

SQL-Server

Dev

ASP.NET Core,Angular2 CRUD with Animation using Template Pack, WEB API and EF 1.0.1

8 Mar 2017syed shanu

In this article, let’s see how to create a ASP.NET Core CRUD web application with Angular2 Animation using Template Pack, WEB API and EF 1.0.1

BulkInsert with the Entity Framework

3 May 2018Måns Tånneryd

How to extend the Entity Framework with bulk insert functionality, using DbContext

How to Prevent When a Transaction Accidentally Overwrites Modified Data

30 Apr 2017Wendelius

1 alternative

This article explains the problem, when another transaction (concurrent or not) accidentally overwrites previously modified data and how to prevent this from happening.

Single Page Application (SPA) for Enterprise App (Angular2 & WebApi) - Part 2 - Add new Permission

14 Jun 2017tranthanhtu.vn

In this article, we will learn how to create/edit Role

Random Number Generation using SQL

7 Mar 2017Shikur Yennus

Linear congruential is one of methods used to generate random numbers.

SQL

Walkthrough in detail : Create Dataset and Database with two relational tables. An UpdateAll method on the TableAdapterManager.

28 Nov 2017Bob Stoom

Walkthrough in detail to create a relational database application using C# .NET without code.

.NET4.5

.NET

ADO.NET

Work with the AdventureWorks Bill of Materials using Subqueries

19 Mar 2017essentialSQL

Work with the AdventureWorks Bill of Materials using Subqueries

SQL

Updating Database from DataGridView Using a Class Two-Tier Architecture

4 Oct 2018Awesh Vishwakarma

By reading this trick, you will be able to update your database from DataGridView through external class instead of writing code on each page.

Current Participants

Those with articles that match the contest criteria are automatically entered.

AlexeyYakovlev

Software Developer (Senior) ULTIMA Businessware

Russian Federation

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Awesh Vishwakarma

Software Developer

India

/*life runs on code*/
So keep coding...

Bob Stoom

Software Developer

Israel

8 years experience working as a Software Developer.
Use C#, Visual Basic, Java.

Changming Wang

Software Developer K&C Silviculture

Canada

IT Manager and Software Developer at K&C Silviculture Ltd.

CHill60

Software Developer (Senior)

United Kingdom

Slowing down. Now working as a "Business Automation Consultant".

"Abandon all hope of ever being understood, all ye who have a good idea but don't say it perfectly." Doug Bernard

defwebserver

Software Developer (Senior) http://ADefWebserver.com

United States

Michael Washington is a Microsoft MVP. He is a ASP.NET and
C# programmer.
He is the founder of
AiHelpWebsite.com,
LightSwitchHelpWebsite.com, and
HoloLensHelpWebsite.com.

He has a son, Zachary and resides in Los Angeles with his wife Valerie.

He is the Author of:

essentialSQL

Easy Computer Academy, LLC

United States

Hello my name is Kris. I’m here because I am passionate about helping non-techie people to overcome their fear of learning SQL.

I know what it is like to not know where to start or whether the time spent learning is worth the effort. That is why I am here to help you to:
- Get started in an easy to follow step-by-step manner.
- Use your time wisely so you focus on what is important to learn to get the most value from your time.
- Answer your questions. Really! Just post a comment and I’ll respond. I’m here to help.

It wasn’t long ago that I was helping a colleague with some reporting. She didn’t know where to start and soon got overwhelmed and lost as she didn’t know SQL.

I felt really bad, as she was under pressure to get some summary information to her boss, the built-in reports were falling short, and to make them better would require her to know SQL. At that time that seemed impossible! It in dawned on me, it doesn’t have to be that way.

Then I discovered a way for anyone with the desire to easily learn SQL. I worked with my co-worker, started to teach her what I learned and soon she was able to write reports and answer her boss’ questions without getting stressed or ploughing hours into manipulating data in Excel.

It hasn’t always been easy. Sometimes the information seems abstract or too conceptual. In this case I’ve found out that a visual explanation is best. I really like to use diagrams or videos to explain hard-to-grasp ideas.

Having video, pictures, and text really help to reinforce the point and enable learning.

And now I want to help you get the same results.

The first step is simple, click here http://www.essentialsql.com/get-started-with-sql-server/

Måns Tånneryd

Software Developer (Senior) Tånneryd IT AB

Sweden

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Melick

Sri Lanka

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Neeraj Kaushik1980

Architect Saxo Bank A/S

Denmark

• Solution Architect /Principle Lead Developer with 12 years of IT experience with more emphasize on Capital Domain and Investment banking domain.
• Strong experience in Continuous Integration, Delivery and DevOps solutions.
• Strong experience in drafting solutions, stakeholder communications and risk management.
• Proved strong coding and designing skills with agile approaches (TDD, XP framework, Pair Programming).
• Delivered many projects with involvement from inception to delivery phase.
• Strong experience in high performance, multithreaded, low latency applications.
• Ability to communicate with the business and technical stake holders effectively.
• Have extensive experience in Capital Market Domain: Front Office & BackOffice (Algorithm Trading tools, messaging framework, Enterprise bus, integration of FIX APIs and many trading APIs).
• Functional knowledge of Portfolio/Wealth Management, Equities, Fixed Income, Derivatives, Forex.
• Practical knowledge of building and practicing agile delivery methodologies (SCRUM, TDD, Kanban).

Technical Skills

• Architectural: Solution Design, Architectural Presentations (Logical, Component, Physical, UML diagrams)
• Languages: C#, C++
• Server Technologies: WCF, Web API,
• Middle Ware: ActiveMQ, RabbitMQ, Enterprise Service Bus
• UI Technologies: Winforms and WPF
• Web Technologies: Asp.Net Mvc, KnockOutJS, JQuery, Advance Java Scripts Concepts
• Databases: Sql Server 2008 +, MySQL
• Tools/Frameworks: TFS, SVN, NUnit, Rhino Mocks, Unity, NAnt, QuickFix/n, Nhibernate, LINQ, JIRA,

Functional Skills

• Wealth Management System, Trade Life Cycle, Trading Components and their integrations
• Working knowledge of Stocks, Bonds, CFDs,Forex, Futures and Options
• Pricing Systems, Market Data Management,
• BackOffice Processes : Settlement Processes, Netting, Tax, Commissions, Corporate Actions Handling,
• Reporting Solutions : OLTP and OLAP Data model designing
• FIX Engine implementation and integration

PureNsanity

Architect

United States

More than fourteen years of experience programming with six years of WPF application development. Dedicated business application developer with large focus on performance tuning for multithreaded applications. Experience developing for small scale applications and large scale distributed systems at senior and architect levels. Experience developing for a wide range of industry applications to include artificial lift, baggage tracking, distribution, customer relation management, and commodities.

Redgate Software

Red Gate Software Ltd.

United Kingdom

Redgate makes ingeniously simple software used by 804,745 IT professionals and counting, and is the leading Microsoft SQL Server tools vendor. Our philosophy is to design highly usable, reliable tools which elegantly solve the problems developers and DBAs face every day, and help them adopt database DevOps. As a result, more than 100,000 companies use products in the Redgate SQL Toolbelt, including 91% of those in the Fortune 100.

This is a Organisation

1 members

Ricardo_Torres_Torres

Software Developer (Senior)

Uruguay

I am Software Developer with a passion for technology with strong backend (PHP, MySQL, PostgreSQL and SQL Server) and frontend (HTML5, CSS3, AngularJs and KnockOutJs) experience. I combine my education with expertise in CSS3, HTML5, Javascript to build creative and effective websites and applications.

If you wish to contact me then please do so on ricardojavister@gmail.com or feel free to skype me on
ricardo-torres-torres.

Robert_Dyball

Software Developer (Senior)

Australia

Robert works as a full stack developer in the financial services industry. He's passionate about sustainable software development, building solid software and helping to grow teams. He's had 20+ years of development experience across many areas that include scheduling, logistics, telecommunications, manufacturing, health, insurance and government regulatory and licensing sectors. Outside work he also enjoys electronics, IOT and helping a number of non-profit groups.

Shikur Yennus

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Smirnov Pavel

Architect

United States

Senior Software Engineer and Solution Architect.

syed shanu

Team Leader

India

Microsoft MVP | Code Project MVP | CSharp Corner MVP | Author | Blogger and always happy to Share what he knows to others. MyBlog

My Interview on Microsoft TechNet Wiki Ninja Link

tranthanhtu.vn

Architect

Vietnam

I have more than 8 years in web development for multiple types of applications (ERP, Education System, ...).
I usually organize training/ coaching on specified topic (such as: RESTful/ WebApi, Angular2, BEM, LESS, SASS, EF, NodeJs ....). Please contact me on Skype (tranthanhtu83) or email (contact@tranthanhtu.vn) if need.
For more information about me, Please visit http://www.tranthanhtu.vn/page/about-me

Tyler Rhodes

Software Developer

United States

I've been programming and working with computers professionally for over 10 years now.

It all started as a hobby a long time ago when a friend introduced me to QBasic.

From there I've programmed in a lot of languages like C, C++, C#, Java, JavaScript and now a little bit of Go. I don't really have a favorite, but if I had to pick I like C# right now.

I also have a long background of doing systems and network engineering and know about things like email and phone systems, Active Directory and setting up VPNs.

Wendelius

Architect

Europe

Biography provided

yuvalsol

Web Developer

Israel

https://github.com/yuvalsol

First Prize	CHill60 - Processing Loops in SQL Server
Prize pool	CodeProject Mug - CodeProject


Second Prize	Måns Tånneryd - BulkInsert with the Entity Framework
Prize pool	Bob Sticker - CodeProject

Contest Entries and Requirements

The contest period covers the the first day of the month 12AM US Eastern Standard Time and ends the final day of the month at 11:59:59 PM US Eastern Standard Time. All entries must be submitted during this period in order to qualify.
Entries must be an article, or blog entry.
With the exception of the Everything Else category, the article must be tagged with at least one of the tags corresponding to that competition's category (for example, to enter the C# Competition you would need to tag your article with a C# tag).
Articles entries must follow the CodeProject submission guidelines.
No cheating, lying, plagiarizing articles, chicanery, or kicking.
Articles may only be considered for a single category. If an article is eligible for multiple categories (for example, it pertains to both the C# and Web Dev categories), CodeProject editors and judges will decide which category the article shall be entered in.
No author can be nominated twice in the same category.
If an author writes has two separate articles, each article may be considered in their respective categories provided none of the aforementioned rules are broken. For example, if an author wrote two separate articles, one related to C# and one related to VB.NET, the author and articles could be nominated in the C# and VB.NET competitions, respectively.
In the event an author wins multiple competitions, and repeat, identical prizes, the number of prizes issued is solely at the discretion of the prize issuer.
In the event an article has multiple authors and/or contributors, the number of prizes issued is solely at the discretion of the prize issuer.
In the event of a tie, the number of prizes issued is solely at the discretion of the prize issuer.
Multiple votes from the same IP will be automatically disqualified.
The judges’ decision is final and no correspondence will be entered into.
Only those who live in jurisdictions in which this contest is legal may enter.
Any breach of the rules and the prize will be awarded to the runner up.
By entering the contest you agree to the rules, conditions of entry, and agree that your member alias and any submitted material can be used for promotional purposes by CodeProject.
Entries shall be deemed to be submitted by the authorized account holder of the email address submitted at the time of entry unless clearly indicated otherwise. "Authorized account holder" is defined as the natural person who is assigned to an email address by an internet access provider, on-line service provider, or other organization (e.g. business, educational institution, etc.) that is responsible for assigning email addresses for the domain associated with the submitted email address.

Eligibility

This competition is open to software development professionals & enthusiasts who are of the age of majority in their jurisdiction of residence; however, residents of Quebec and of the following countries are ineligible to participate due to legal constraints: Cuba, Iran, Iraq, Libya, North Korea, Sudan, and Syria. Employees (or a member of their immediate family) of CodeProject or any of their affiliates, subsidiaries, advertising or promotional agencies are also ineligible to participate. Void where prohibited by law.

How to Enter

Entry is by the submission process described above. Please read the submission requirements before submitting your entry and ensure the article is tagged with at least one of the tags corresponding to that competition's category.

Lost, late, misdirected, or illegible entries will be disqualified. Any entry containing content that CodeProject deems objectionable for any reason will be disqualified. All decisions of CodeProject with respect to any aspect of the competition, including, without limitation, the eligibility of entries, are final and binding on all entrants in all matters as they relate to this competition. CodeProject reserves its right to modify the Rules.

CodeProject assumes no responsibility for lost, late, delayed, destroyed or misdirected mail, voice messages, email or any computer errors or malfunctions. No correspondence will be entered into with entrants.

CodeProject does not assume any responsibility for incorrect or inaccurate capture of entry information, technical malfunctions, human or technical error, lost, delayed or garbled data or transmissions, omission, interruption, deletion, defect or failures of any telephone or computer line or network, computer equipment, software or any combination thereof. Entry materials/data that have been tampered with or altered are void. If for any reason, in the opinion of CodeProject in its sole discretion, the competition is not capable of running as originally planned, or if the administration, security, fairness, integrity or the proper conduct of the competition is corrupted or adversely affected, including by reason of infection by computer virus, bugs, tampering, unauthorized intervention, fraud, technical failures or any other causes beyond its control, CodeProject reserves its right to cancel, terminate, modify, amend, extend or suspend the competition including cancelling any method of entry, and select a winner from previously received eligible entries. CodeProject reserves its right in its sole discretion to disqualify any individual it finds to be tampering with the entry process or the operation of the competition or to be acting in violation of the Rules or otherwise in a disruptive manner. CodeProject reserves its right to seek remedies and damages to the fullest extent of the law for any attempts to deliberately damage the competition web site or to undermine the legitimate operation of this competition. CodeProject shall not be held responsible for any errors or negligence that may arise or occur in connection with the competition including any damage to an entrant's computer equipment, system, software or any combination thereof, as a result of their participation in this competition or from downloading any material from the competition website where applicable.