Articles by Jovan Popovic(MSFT) (Articles: 26, Tip/Tricks: 6)

Articles: 26, Tip/Tricks: 6

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.92

ASP.NET

General

Building REST services with ASP.NET Core Web API and Azure SQL Database

Posted: 14 Jun 2016 Updated: 8 Jul 2016 Views: 98,810 Rating: 4.93/5 Votes: 35 Popularity: 7.61

Licence: The Code Project Open License (CPOL) Bookmarked: 49 Downloaded: 154

In this article you can see how easily you can easily expose your database data via REST services developed using ASP.NET Core Web API and new JSON support in Azure SQL database and SQL Server 2016

Samples

Creating an expandable master-details table (jQuery DataTables and ASP.NET MVC integration - Part IV)

Posted: 1 May 2011 Updated: 2 May 2011 Views: 320,605 Rating: 4.88/5 Votes: 54 Popularity: 8.46

Licence: The Code Project Open License (CPOL) Bookmarked: 122 Downloaded: 14,794

This article shows how an expandable master-details table can be implemented in ASP.NET MVC using the jQuery DataTables plug-in.

ASP.NET MVC Editable Table (jQuery DataTables and ASP.NET MVC integration - Part II)

Posted: 6 Mar 2011 Updated: 6 Nov 2011 Views: 574,067 Rating: 4.90/5 Votes: 70 Popularity: 9.05

Licence: The Code Project Open License (CPOL) Bookmarked: 212 Downloaded: 24,851

This article shows how a datatable with standard CRUD functionalites (select/delete data, update single cell, and add new record) can be created in ASP.NET MVC using the jQuery DataTables Editable plug-in.

jQuery DataTables Advanced Filtering in ASP.NET MVC (jQuery DataTables and ASP.NET MVC Integration - Part V)

Posted: 13 Mar 2012 Updated: 5 Apr 2012 Views: 211,678 Rating: 4.88/5 Votes: 25 Popularity: 6.89

Licence: The Code Project Open License (CPOL) Bookmarked: 71 Downloaded: 10,544

How to implement advanced column filtering using jQuery DataTables.

jQuery DataTables and ASP.NET MVC Integration - Part I

Posted: 8 Feb 2011 Updated: 11 Apr 2012 Views: 1,139,565 Rating: 4.93/5 Votes: 189 Popularity: 11.26

Licence: The Code Project Open License (CPOL) Bookmarked: 367 Downloaded: 32,117

This article contains code samples which explain how the jQuery DataTables plug-in can be integrated into ASP.NET MVC applications.

ASP.NET MVC3 Razor With jQuery For Beginners

Posted: 13 Mar 2012 Updated: 19 Apr 2012 Views: 826,460 Rating: 4.86/5 Votes: 214 Popularity: 11.32

Licence: The Code Project Open License (CPOL) Bookmarked: 369 Downloaded: 29,552

This is a simle introduction tutorial that can help ASP.NET MVC3 beginners to create a first MVC application

Refreshing content of the table using AJAX in ASP.NET MVC (jQuery DataTables and ASP.NET MVC integration - Part III)

Posted: 5 Apr 2011 Updated: 21 Apr 2012 Views: 315,135 Rating: 4.92/5 Votes: 41 Popularity: 7.98

Licence: The Code Project Open License (CPOL) Bookmarked: 118 Downloaded: 10,779

This article shows how you can refresh content of the table in ASP.NET MVC using the jQuery DataTables plug-in.

Table Row Drag and Drop in ASP.NET MVC (jQuery DataTables and ASP.NET MVC Integration - Part VI)

Posted: 2 Apr 2012 Updated: 23 Apr 2012 Views: 140,884 Rating: 5.00/5 Votes: 25 Popularity: 6.99

Licence: The Code Project Open License (CPOL) Bookmarked: 51 Downloaded: 5,955

Reordering table rows using drag and drop functionality with jQuery DataTables plug-in in ASP.NET MVC applications.

jQuery Templates/View Engines in ASP.NET MVC

Posted: 28 Apr 2011 Updated: 25 Apr 2012 Views: 173,641 Rating: 4.88/5 Votes: 61 Popularity: 8.71

Licence: The Code Project Open License (CPOL) Bookmarked: 180 Downloaded: 4,043

This article explains how client-side view engines can be used in ASP.NET MVC.

Using JEditable plugin as ASP.NET MVC3 jQuery inline editor

Posted: 17 Oct 2011 Updated: 24 Jun 2012 Views: 134,943 Rating: 4.86/5 Votes: 48 Popularity: 8.18

Licence: The Code Project Open License (CPOL) Bookmarked: 132 Downloaded: 3,431

This article describes how you can implement inline editing in an ASP.NET MVC application using the jQuery Jeditable plug-in.

Client side scripting

General

Enhancing HTML tables using the jQuery DataTables plug-in

Posted: 20 Sep 2011 Updated: 10 Apr 2012 Views: 1,982,373 Rating: 4.95/5 Votes: 81 Popularity: 9.45

Licence: The Code Project Open License (CPOL) Bookmarked: 245 Downloaded: 0

This article shows how to enhance a plain HTML table with the jQuery DataTables plug-in.

jQuery Templates/View Engines and JSON Services

Posted: 8 May 2011 Updated: 25 Apr 2012 Views: 69,482 Rating: 4.96/5 Votes: 28 Popularity: 7.17

Licence: The Code Project Open License (CPOL) Bookmarked: 102 Downloaded: 1,895

Basic concepts of creating pure JavaScript applications using jQuery, JavaScript View Engines, and web services that provide JSON results that are accessed by JavaScript code via AJAX calls.

Node.js

General

Pushing Compression from node.js to SQL Server

Posted: 10 Dec 2015 Updated: 11 Dec 2015 Views: 10,014 Rating: 5.00/5 Votes: 1 Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0

In this article, you will see how to compress data in SQL Server using GZip algorithm and send it via node.js to browser.

Web Security

Security

Implement secure ASP.NET MVC applications

Posted: 24 Nov 2011 Updated: 21 Jul 2014 Views: 314,246 Rating: 4.92/5 Votes: 117 Popularity: 10.22

Licence: The Code Project Open License (CPOL) Bookmarked: 336 Downloaded: 8,936

This article discusses various aspects of ASP.NET MVC security and shows some tips to implement these elements in your applications.

Web Services

General

MsSql.RestApi - The Easiest Way to Build the ASP.NET REST API

Posted: 5 Nov 2018 Updated: 5 Nov 2018 Views: 8,223 Rating: 5.00/5 Votes: 11 Popularity: 5.21

Licence: The Code Project Open License (CPOL) Bookmarked: 26 Downloaded: 0

In this article, I will show you how to create powerful REST API with just a few lines of C# code using MsSql.RestApi package. If you follow this approach, it might be a huge time saver for you.

Azure

General

Sending events from Azure Event Hub to Azure SQL Database using Azure Functions

Posted: 7 Feb 2017 Updated: 7 Feb 2017 Views: 16,795 Rating: 5.00/5 Votes: 5 Popularity: 3.49

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

This article describes how to get messages sent to Azure Even Hub and load them into Azure SQL Database using Azure Functions.

Database

Data Access

Entity Framework: Storing complex properties as JSON text in database

Posted: 17 Jan 2017 Updated: 18 Jan 2017 Views: 68,641 Rating: 5.00/5 Votes: 32 Popularity: 7.53

Licence: The Code Project Open License (CPOL) Bookmarked: 38 Downloaded: 399

Complex properties in entity Framework models such as arrays, dictionaries, and objects can be serialized in SQL Server database in JSON format. In this article I will show you how to map your properties in EF model to database columns that contain JSON.

SQL Server

Friday the 13th - JSON is coming to SQL Server

Posted: 12 Nov 2015 Updated: 8 Dec 2015 Views: 35,271 Rating: 4.98/5 Votes: 49 Popularity: 8.42

Licence: The Code Project Open License (CPOL) Bookmarked: 43 Downloaded: 0

Overview of built-in support for JSON text processing in new SQL Server

Inserting JSON Text into SQL Server Table

Posted: 25 Mar 2016 Updated: 26 Mar 2016 Views: 103,244 Rating: 4.80/5 Votes: 26 Popularity: 6.86

Licence: The Code Project Open License (CPOL) Bookmarked: 28 Downloaded: 275

In this article, we will see how you can easily insert array of JSON objects into SQL Server 2016 tables.

Comparing rows in SQL Server and Azure SQL Database

Posted: 16 Jun 2016 Updated: 16 Jun 2016 Views: 5,660 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

In this article is shown how to easily compare two rows in SQL Server using new JSON functionalities.

What Can JSON Do For You in SQL Server Database?

Posted: 13 Jul 2018 Updated: 13 Jul 2018 Views: 17,112 Rating: 4.77/5 Votes: 15 Popularity: 5.60

Licence: The Code Project Open License (CPOL) Bookmarked: 29 Downloaded: 0

Learn about various use cases how you can leverage JSON support in SQL Server and Azure SQL Database

C#

General

Functional programming in C#

Posted: 6 May 2012 Updated: 10 Jun 2012 Views: 415,298 Rating: 4.98/5 Votes: 194 Popularity: 11.39

Licence: The Code Project Open License (CPOL) Bookmarked: 353 Downloaded: 0

This article explains how you can use functional programming in C#.

Java

General

Editable (CRUD) web tables in J2EE (jQuery Data Tables and J2EE application integration - Part II)

Posted: 25 May 2011 Updated: 10 Apr 2012 Views: 203,516 Rating: 4.86/5 Votes: 32 Popularity: 7.32

Licence: The Code Project Open License (CPOL) Bookmarked: 41 Downloaded: 10,427

This article explains how you can implement full data management functionalites (adding, deleting, inline editing) into web tables using jQuery DataTables/Editable and J2EE applications.

jQuery DataTables in Java Web Applications

Posted: 7 Apr 2012 Updated: 26 Apr 2012 Views: 340,380 Rating: 4.93/5 Votes: 36 Popularity: 7.70

Licence: The Code Project Open License (CPOL) Bookmarked: 47 Downloaded: 13,081

Enhancing simple tables implemented in Java web applications using the jQuery DataTables plug-in.

LINQ

General

Using LINQ Queries

Posted: 15 Feb 2012 Updated: 25 Apr 2012 Views: 494,772 Rating: 4.89/5 Votes: 131 Popularity: 10.35

Licence: The Code Project Open License (CPOL) Bookmarked: 290 Downloaded: 0

Explanations of the most important LINQ queries.

Windows Communication Foundation

General

OData Services

Posted: 31 May 2012 Updated: 7 Jun 2012 Views: 349,819 Rating: 4.96/5 Votes: 93 Popularity: 9.76

Licence: The Code Project Open License (CPOL) Bookmarked: 165 Downloaded: 7,048

In this article is shown what are OData services, how you can create them using the WCF Data Services, and how you can use them

No blogs have been submitted.

Average tips rating: 4.63

Client side scripting

General

Persist JQueryUI Sortable position [Tip/Trick]

Posted: 14 Nov 2011 Updated: 20 Nov 2011 Views: 31,350 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

Example showing how to persist positions of the sortable elements after drag&drop reordering using the JQuery UI sortable

HTML / CSS

General

Separating HTML list items by comma using CSS [Tip/Trick]

Posted: 21 Feb 2012 Updated: 23 Feb 2012 Views: 32,442 Rating: 4.89/5 Votes: 8 Popularity: 4.40

Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0

Separating HTML list items by comma using CSS

Database

General

Selecting parent records with specific subset of child records [Tip/Trick]

Posted: 15 Nov 2011 Updated: 15 Nov 2011 Views: 25,182 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

I will show you how you can select one parent row with two latest child rows using T-SQL

Selecting parent records with specific subset of child records [Tip/Trick]

Posted: 15 Nov 2011 Updated: 20 Nov 2011 Views: 8,560 Rating: 0.00/5 Votes: Popularity: 0.00

Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 0

If you are using some alternative SQL dialect without common table expression syntax, you can use correlated sub-query as the one in the following example:SELECT * FROM( SELECT Company.CompanyName, Employee.EmployeeName, Employee.DateHired, ROW_NUMBER() OVER( PARTITION BY...

Formatting child table rows as a list in a single column cell [Tip/Trick]

Posted: 14 Nov 2011 Updated: 20 Nov 2011 Views: 24,250 Rating: 4.60/5 Votes: 5 Popularity: 3.15

Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0

This SQL example shows how you can return parent row all child rows as a single cell.

SQL Server

DROP IF EXISTS in SQL Server 2016 [Tip/Trick]

Posted: 3 Nov 2015 Updated: 3 Nov 2015 Views: 10,381 Rating: 4.02/5 Votes: 12 Popularity: 4.29

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

SQL Server 2016 introduces the new DROP IF EXISTS syntax

No reference articles have been posted.

No projects have been posted.

Jovan Popovic(MSFT)

	Program Manager Microsoft
	Serbia

Graduated from Faculty of Electrical Engineering, Department of Computer Techniques and Informatics, University of Belgrade, Serbia.
Currently working in Microsoft as Program Manager on SQL Server product.
Member of JQuery community - created few popular plugins (four popular JQuery DataTables add-ins and loadJSON template engine).
Interests: Web and databases, Software engineering process(estimation and standardization), mobile and business intelligence platforms.

Layout: fixed | fluid