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.93

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: 114,414 Rating: 4.93/5 Votes: 35 Popularity: 7.61

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

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: 342,713 Rating: 4.88/5 Votes: 54 Popularity: 8.42

Licence: The Code Project Open License (CPOL) Bookmarked: 123 Downloaded: 15,382

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: 611,049 Rating: 4.90/5 Votes: 70 Popularity: 9.02

Licence: The Code Project Open License (CPOL) Bookmarked: 213 Downloaded: 25,632

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: 233,001 Rating: 4.88/5 Votes: 25 Popularity: 6.83

Licence: The Code Project Open License (CPOL) Bookmarked: 72 Downloaded: 10,956

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,203,497 Rating: 4.93/5 Votes: 190 Popularity: 11.23

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

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: 864,294 Rating: 4.92/5 Votes: 214 Popularity: 11.39

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

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: 343,350 Rating: 4.92/5 Votes: 42 Popularity: 7.88

Licence: The Code Project Open License (CPOL) Bookmarked: 119 Downloaded: 11,063

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: 153,210 Rating: 5.00/5 Votes: 25 Popularity: 6.81

Licence: The Code Project Open License (CPOL) Bookmarked: 51 Downloaded: 6,136

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: 183,260 Rating: 4.88/5 Votes: 61 Popularity: 8.64

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

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: 142,590 Rating: 4.86/5 Votes: 48 Popularity: 8.17

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

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: 2,960,888 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: 73,310 Rating: 4.96/5 Votes: 28 Popularity: 7.09

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

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: 12,120 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: 331,112 Rating: 4.94/5 Votes: 117 Popularity: 10.18

Licence: The Code Project Open License (CPOL) Bookmarked: 337 Downloaded: 9,018

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: 20,920 Rating: 5.00/5 Votes: 12 Popularity: 5.40

Licence: The Code Project Open License (CPOL) Bookmarked: 29 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: 24,331 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: 98,587 Rating: 5.00/5 Votes: 36 Popularity: 7.72

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

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: 42,931 Rating: 4.98/5 Votes: 49 Popularity: 8.42

Licence: The Code Project Open License (CPOL) Bookmarked: 44 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: 146,872 Rating: 4.80/5 Votes: 26 Popularity: 6.86

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

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: 7,160 Rating: 0.00/5 Votes: 0 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: 24,230 Rating: 4.78/5 Votes: 16 Popularity: 5.62

Licence: The Code Project Open License (CPOL) Bookmarked: 31 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: 439,714 Rating: 4.98/5 Votes: 195 Popularity: 11.40

Licence: The Code Project Open License (CPOL) Bookmarked: 355 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: 215,022 Rating: 4.86/5 Votes: 32 Popularity: 7.32

Licence: The Code Project Open License (CPOL) Bookmarked: 42 Downloaded: 10,669

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: 366,685 Rating: 4.93/5 Votes: 36 Popularity: 7.67

Licence: The Code Project Open License (CPOL) Bookmarked: 48 Downloaded: 13,391

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: 556,846 Rating: 4.89/5 Votes: 132 Popularity: 10.26

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

Explanations of the most important LINQ queries.

Windows Communication Foundation

General

OData Services

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

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

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.66

Client side scripting

General

Persist JQueryUI Sortable position [Tip/Trick]

Posted: 14 Nov 2011 Updated: 20 Nov 2011 Views: 33,550 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: 37,231 Rating: 4.89/5 Votes: 8 Popularity: 4.42

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: 27,141 Rating: 0.00/5 Votes: 0 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: 9,350 Rating: 0.00/5 Votes: 0 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: 26,380 Rating: 4.71/5 Votes: 6 Popularity: 3.67

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: 12,320 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.