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

Database Development
NoSQL	Friday the 13th - JSON is Coming to SQL Server Posted: 12 Nov 2015 Updated: 8 Dec 2015 Views: 50,308 Rating: 4.98/5 Votes: 49 Popularity: 8.42 Licence: The Code Project Open License (CPOL) Bookmarked: 44 Downloaded: 0 Please Sign up or sign in to vote. Overview of built-in support for JSON text processing in new SQL Server
Hosted Services
Azure	Comparing Rows in SQL Server and Azure SQL Database Posted: 16 Jun 2016 Updated: 16 Jun 2016 Views: 8,161 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. 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: 27,197 Rating: 4.78/5 Votes: 16 Popularity: 5.62 Licence: The Code Project Open License (CPOL) Bookmarked: 31 Downloaded: 0 Please Sign up or sign in to vote. Learn about various use cases how you can leverage JSON support in SQL Server and Azure SQL Database
Serverless	MsSql.RestApi - The Easiest Way to Build the ASP.NET REST API Posted: 5 Nov 2018 Updated: 5 Nov 2018 Views: 29,105 Rating: 5.00/5 Votes: 14 Popularity: 5.73 Licence: The Code Project Open License (CPOL) Bookmarked: 30 Downloaded: 0 Please Sign up or sign in to vote. 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.
Internet of Things
	Sending Events from Azure Event Hub to Azure SQL Database using Azure Functions Posted: 7 Feb 2017 Updated: 7 Feb 2017 Views: 30,494 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote.
Programming Languages
C#	Functional Programming in C# Posted: 6 May 2012 Updated: 10 Jun 2012 Views: 461,507 Rating: 4.98/5 Votes: 196 Popularity: 11.41 Licence: The Code Project Open License (CPOL) Bookmarked: 357 Downloaded: 0 Please Sign up or sign in to vote. This article explains how you can use functional programming in C#.
	Using LINQ Queries Posted: 15 Feb 2012 Updated: 25 Apr 2012 Views: 576,547 Rating: 4.89/5 Votes: 132 Popularity: 10.26 Licence: The Code Project Open License (CPOL) Bookmarked: 292 Downloaded: 0 Please Sign up or sign in to vote. Most important LINQ queries explained
Java	Editable (CRUD) Web Tables in J2EE (jQuery Data Tables and J2EE Application Integration - Part II) Posted: 25 May 2011 Updated: 10 Apr 2012 Views: 220,888 Rating: 4.86/5 Votes: 32 Popularity: 7.32 Licence: The Code Project Open License (CPOL) Bookmarked: 42 Downloaded: 10,763 Please Sign up or sign in to vote. 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: 383,027 Rating: 4.93/5 Votes: 37 Popularity: 7.73 Licence: The Code Project Open License (CPOL) Bookmarked: 49 Downloaded: 13,576 Please Sign up or sign in to vote. Enhancing simple tables implemented in Java web applications using the jQuery DataTables plug-in
Javascript	jQuery Templates/View Engines and JSON Services Posted: 8 May 2011 Updated: 25 Apr 2012 Views: 75,792 Rating: 4.96/5 Votes: 28 Popularity: 7.09 Licence: The Code Project Open License (CPOL) Bookmarked: 102 Downloaded: 1,910 Please Sign up or sign in to vote. 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.
SQL	Inserting JSON Text into SQL Server Table Posted: 25 Mar 2016 Updated: 26 Mar 2016 Views: 188,536 Rating: 4.86/5 Votes: 27 Popularity: 6.87 Licence: The Code Project Open License (CPOL) Bookmarked: 31 Downloaded: 782 Please Sign up or sign in to vote. How to easily insert array of JSON objects into SQL Server 2016 tables
Web Development
ASP.NET	Building REST services with ASP.NET Core Web API and Azure SQL Database Posted: 14 Jun 2016 Updated: 8 Jul 2016 Views: 127,026 Rating: 4.93/5 Votes: 35 Popularity: 7.54 Licence: The Code Project Open License (CPOL) Bookmarked: 52 Downloaded: 366 Please Sign up or sign in to vote. How to build REST services with ASP.NET Core Web API and Azure SQL Database
	ASP.NET MVC Editable Table (jQuery DataTables and ASP.NET MVC integration - Part II) Posted: 6 Mar 2011 Updated: 6 Nov 2011 Views: 637,345 Rating: 4.90/5 Votes: 70 Popularity: 9.02 Licence: The Code Project Open License (CPOL) Bookmarked: 213 Downloaded: 26,114 Please Sign up or sign in to vote. Create datatable with standard CRUD functionalites 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: 244,123 Rating: 4.88/5 Votes: 25 Popularity: 6.83 Licence: The Code Project Open License (CPOL) Bookmarked: 72 Downloaded: 11,134 Please Sign up or sign in to vote. 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,244,809 Rating: 4.93/5 Votes: 191 Popularity: 11.24 Licence: The Code Project Open License (CPOL) Bookmarked: 368 Downloaded: 32,996 Please Sign up or sign in to vote. Code samples that explain how the jQuery DataTables plug-in can be integrated into ASP.NET MVC applications
	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: 361,795 Rating: 4.92/5 Votes: 43 Popularity: 7.93 Licence: The Code Project Open License (CPOL) Bookmarked: 119 Downloaded: 11,236 Please Sign up or sign in to vote. How to 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: 162,237 Rating: 5.00/5 Votes: 25 Popularity: 6.81 Licence: The Code Project Open License (CPOL) Bookmarked: 50 Downloaded: 6,266 Please Sign up or sign in to vote. 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: 191,140 Rating: 4.88/5 Votes: 61 Popularity: 8.64 Licence: The Code Project Open License (CPOL) Bookmarked: 179 Downloaded: 4,069 Please Sign up or sign in to vote. 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: 147,147 Rating: 4.86/5 Votes: 48 Popularity: 8.17 Licence: The Code Project Open License (CPOL) Bookmarked: 132 Downloaded: 3,483 Please Sign up or sign in to vote. This article describes how you can implement inline editing in an ASP.NET MVC application using the jQuery Jeditable plug-in.
	OData Services Posted: 31 May 2012 Updated: 7 Jun 2012 Views: 375,222 Rating: 4.96/5 Votes: 93 Popularity: 9.76 Licence: The Code Project Open License (CPOL) Bookmarked: 165 Downloaded: 7,234 Please Sign up or sign in to vote. How to create OData services using the WCF Data Services and use them
HTML	Creating an Expandable Master-Details Table (jQuery DataTables and ASP.NET MVC Integration - Part IV) Posted: 1 May 2011 Updated: 2 May 2011 Views: 356,134 Rating: 4.88/5 Votes: 54 Popularity: 8.42 Licence: The Code Project Open License (CPOL) Bookmarked: 123 Downloaded: 15,674 Please Sign up or sign in to vote. Implement an expandable master-details table in ASP.NET MVC using jQuery DataTables plug-in
	ASP.NET MVC3 Razor With jQuery For Beginners Posted: 13 Mar 2012 Updated: 19 Apr 2012 Views: 891,861 Rating: 4.92/5 Votes: 214 Popularity: 11.39 Licence: The Code Project Open License (CPOL) Bookmarked: 370 Downloaded: 29,784 Please Sign up or sign in to vote. Simple tutorial to create first MVC app
	Enhancing HTML tables using the jQuery DataTables plug-in Posted: 20 Sep 2011 Updated: 10 Apr 2012 Views: 3,127,141 Rating: 4.95/5 Votes: 81 Popularity: 9.45 Licence: The Code Project Open License (CPOL) Bookmarked: 245 Downloaded: 0 Please Sign up or sign in to vote. This article shows how to enhance a plain HTML table with the jQuery DataTables plug-in.
	Implement secure ASP.NET MVC applications Posted: 24 Nov 2011 Updated: 21 Jul 2014 Views: 342,676 Rating: 4.94/5 Votes: 117 Popularity: 10.18 Licence: The Code Project Open License (CPOL) Bookmarked: 339 Downloaded: 9,050 Please Sign up or sign in to vote. This article discusses various aspects of ASP.NET MVC security and shows some tips to implement these elements in your applications.
	Entity Framework: Storing Complex Properties as JSON Text in Database Posted: 17 Jan 2017 Updated: 18 Jan 2017 Views: 121,233 Rating: 5.00/5 Votes: 38 Popularity: 7.84 Licence: The Code Project Open License (CPOL) Bookmarked: 45 Downloaded: 706 Please Sign up or sign in to vote. Mapping properties in EF model to database columns that contain JSON
Node.js	Pushing Compression from node.js to SQL Server Posted: 10 Dec 2015 Updated: 11 Dec 2015 Views: 13,892 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. In this article, you will see how to compress data in SQL Server using GZip algorithm and send it via node.js to browser.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.66

Database Development
SQL Server	DROP IF EXISTS in SQL Server 2016 [Tip/Trick] Posted: 3 Nov 2015 Updated: 3 Nov 2015 Views: 13,100 Rating: 4.02/5 Votes: 12 Popularity: 4.34 Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. SQL Server 2016 introduces the new DROP IF EXISTS syntax
jQuery-UI
	Persist JQueryUI Sortable position [Tip/Trick] Posted: 14 Nov 2011 Updated: 20 Nov 2011 Views: 34,380 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Example showing how to persist positions of the sortable elements after drag&drop reordering using the JQuery UI sortable
Programming Languages
SQL	Selecting parent records with specific subset of child records [Tip/Trick] Posted: 15 Nov 2011 Updated: 15 Nov 2011 Views: 28,270 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. 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,520 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. 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: 27,681 Rating: 4.71/5 Votes: 6 Popularity: 3.67 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. This SQL example shows how you can return parent row all child rows as a single cell.
Web Development
HTML	Separating HTML list items by comma using CSS [Tip/Trick] Posted: 21 Feb 2012 Updated: 23 Feb 2012 Views: 39,862 Rating: 4.89/5 Votes: 8 Popularity: 4.42 Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Separating HTML list items by comma using CSS

Average reference rating:

No reference articles have been posted.

Average project rating:

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.

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

Articles: 26, Tip/Tricks: 6

Average article rating: 4.93

Database Development

Hosted Services

Internet of Things

Programming Languages

Web Development