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 12 Nov 2015 Updated: 8 Dec 2015 Rating: 4.98/5 Votes: 51 Popularity: 8.51 Licence: CPOL Views: 57,788 Bookmarked: 45 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 16 Jun 2016 Updated: 16 Jun 2016 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 9,511 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? 13 Jul 2018 Updated: 13 Jul 2018 Rating: 4.78/5 Votes: 16 Popularity: 5.62 Licence: CPOL Views: 31,308 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 5 Nov 2018 Updated: 5 Nov 2018 Rating: 5.00/5 Votes: 14 Popularity: 5.73 Licence: CPOL Views: 38,416 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 7 Feb 2017 Updated: 7 Feb 2017 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: CPOL Views: 39,205 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote.
Programming Languages
C#	Functional Programming in C# 6 May 2012 Updated: 10 Jun 2012 Rating: 4.98/5 Votes: 196 Popularity: 11.41 Licence: CPOL Views: 510,883 Bookmarked: 360 Downloaded: 0 Please Sign up or sign in to vote. This article explains how you can use functional programming in C#.
	Using LINQ Queries 15 Feb 2012 Updated: 25 Apr 2012 Rating: 4.89/5 Votes: 133 Popularity: 10.27 Licence: CPOL Views: 605,100 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) 25 May 2011 Updated: 10 Apr 2012 Rating: 4.86/5 Votes: 32 Popularity: 7.32 Licence: CPOL Views: 230,688 Bookmarked: 42 Downloaded: 10,839 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 7 Apr 2012 Updated: 26 Apr 2012 Rating: 4.93/5 Votes: 37 Popularity: 7.73 Licence: CPOL Views: 409,808 Bookmarked: 49 Downloaded: 13,710 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 8 May 2011 Updated: 25 Apr 2012 Rating: 4.96/5 Votes: 28 Popularity: 7.09 Licence: CPOL Views: 79,533 Bookmarked: 102 Downloaded: 1,919 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 25 Mar 2016 Updated: 26 Mar 2016 Rating: 4.86/5 Votes: 29 Popularity: 7.03 Licence: CPOL Views: 263,022 Bookmarked: 35 Downloaded: 1,186 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 14 Jun 2016 Updated: 8 Jul 2016 Rating: 4.93/5 Votes: 35 Popularity: 7.54 Licence: CPOL Views: 145,358 Bookmarked: 52 Downloaded: 588 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) 6 Mar 2011 Updated: 6 Nov 2011 Rating: 4.90/5 Votes: 70 Popularity: 9.02 Licence: CPOL Views: 696,931 Bookmarked: 213 Downloaded: 26,511 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) 13 Mar 2012 Updated: 5 Apr 2012 Rating: 4.88/5 Votes: 25 Popularity: 6.83 Licence: CPOL Views: 259,934 Bookmarked: 72 Downloaded: 11,262 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 8 Feb 2011 Updated: 11 Apr 2012 Rating: 4.93/5 Votes: 192 Popularity: 11.25 Licence: CPOL Views: 1,354,416 Bookmarked: 369 Downloaded: 33,181 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) 5 Apr 2011 Updated: 21 Apr 2012 Rating: 4.92/5 Votes: 45 Popularity: 7.99 Licence: CPOL Views: 384,545 Bookmarked: 119 Downloaded: 11,362 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) 2 Apr 2012 Updated: 23 Apr 2012 Rating: 5.00/5 Votes: 25 Popularity: 6.81 Licence: CPOL Views: 175,718 Bookmarked: 52 Downloaded: 6,395 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 28 Apr 2011 Updated: 26 Apr 2012 Rating: 4.88/5 Votes: 61 Popularity: 8.64 Licence: CPOL Views: 204,191 Bookmarked: 179 Downloaded: 4,075 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 17 Oct 2011 Updated: 25 Jun 2012 Rating: 4.86/5 Votes: 48 Popularity: 8.17 Licence: CPOL Views: 154,569 Bookmarked: 132 Downloaded: 3,491 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 31 May 2012 Updated: 8 Jun 2012 Rating: 4.96/5 Votes: 93 Popularity: 9.76 Licence: CPOL Views: 393,242 Bookmarked: 165 Downloaded: 7,267 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) 1 May 2011 Updated: 2 May 2011 Rating: 4.87/5 Votes: 55 Popularity: 8.44 Licence: CPOL Views: 376,645 Bookmarked: 124 Downloaded: 15,847 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 13 Mar 2012 Updated: 19 Apr 2012 Rating: 4.92/5 Votes: 214 Popularity: 11.39 Licence: CPOL Views: 956,572 Bookmarked: 369 Downloaded: 29,821 Please Sign up or sign in to vote. Simple tutorial to create first MVC app
	Enhancing HTML tables using the jQuery DataTables plug-in 20 Sep 2011 Updated: 10 Apr 2012 Rating: 4.95/5 Votes: 81 Popularity: 9.45 Licence: CPOL Views: 3,173,696 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 24 Nov 2011 Updated: 21 Jul 2014 Rating: 4.94/5 Votes: 117 Popularity: 10.18 Licence: CPOL Views: 360,926 Bookmarked: 339 Downloaded: 9,076 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 17 Jan 2017 Updated: 18 Jan 2017 Rating: 5.00/5 Votes: 38 Popularity: 7.84 Licence: CPOL Views: 150,699 Bookmarked: 45 Downloaded: 922 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 11 Dec 2015 Updated: 11 Dec 2015 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 15,192 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] 3 Nov 2015 Updated: 3 Nov 2015 Rating: 4.02/5 Votes: 12 Popularity: 4.34 Licence: CPOL Views: 14,770 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] 14 Nov 2011 Updated: 20 Nov 2011 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: CPOL Views: 35,910 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] 15 Nov 2011 Updated: 15 Nov 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 29,300 Bookmarked: 4 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] 15 Nov 2011 Updated: 20 Nov 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 9,740 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] 14 Nov 2011 Updated: 20 Nov 2011 Rating: 4.71/5 Votes: 6 Popularity: 3.67 Licence: CPOL Views: 29,991 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] 21 Feb 2012 Updated: 23 Feb 2012 Rating: 4.89/5 Votes: 8 Popularity: 4.42 Licence: CPOL Views: 43,462 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