Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.
- By Dino Esposito
- 01/23/2018
After suffering the consequences of accidentally turning off his firewall for a month and then experiencing a catastrophic workstation failure that took out both of his mirrored hard disks, Tim Patrick gained a new appreciation for online code repositories. He adopted VSTS and won't be looking back.
Our cross-platform C# specialist turns his attention to the iOS side of things only to demonstrate some programming issues associated with the much-hyped device from Apple, including Face ID, the "notch," Safe Areas, Large Titles and more.
- By Wallace McClure
- 01/11/2018
You don't need to write ugly code to synchronize your AJAX calls. Instead, you can leverage await/async and the JQueryXHR object to simplify the code around your AJAX calls while still getting the benefits of concurrent processing.
One situation that can prevent a successful file transfer is when the destination file is, in fact, the program that's doing the copying. Here's how to work around such problems.
SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data.
SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the history of your data.
You can speed up how fast your "less frequently used" sites load by sharing assembles among your sites. You'll also reduce memory consumption on your server.
OOP is a special kind of animal, says Tim Patrick, who shows how to put one of its core principles, encapsulation, to work while coding constructors for base and derived classes.
Today, application settings are more likely to appear in local XML files, but the Windows Registry and its hives of key/value pairs can also be used. The good news is that interacting with the Registry is straightforward, as Tim shows you here.
With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them.
When it comes to inheritance, relational database theory and object-oriented programming have more in common than you might think. Understanding that overlap is critical in designing the object model that will generate the database design your application needs.
In an app of any meaningful size, wrapping up common functionality in a composite control reduces the long-term effort needed to craft the app. Learn how to do just that right here.
It’s easy to integrate your own attribute directives into Angular 2 templates to pass data from your component to your directive, have it respond to events on your page or even have your directive fire events to be processed by the component using it.
Our resident data scientist explains how to train neural networks with two popular variations of the back-propagation technique: batch and online.
- By James McCaffrey
- 10/31/2017
Learn how to leverage the open source MVVM ReactiveUI framework, the Observer Design Pattern, ReactiveX and more to make your Xamarin apps more responsive.
- By Daniel Krzyczkowski
- 10/24/2017
With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.
With new APIs for augmented reality and machine learning -- along with many new and updated features -- the latest iteration of iOS is sure to make Apple mobile developers happy, our resident expert concludes in this hands-on review, complete with code samples.
- By Wallace McClure
- 10/17/2017
See how the latest version of Visual Studio 2017 can be used to create Azure Functions using familiar development tools and techniques.
- By Jason Roberts
- 10/12/2017
Here’s a look -- with code samples -- at two series of updates that will improve the feature set and, most important, performance of Microsoft’s cross-platform UI solution.
- By Wallace McClure
- 10/10/2017
Learn how to keep new code-style warnings from filling up your formerly pristine Visual Studio Error List panel.
Here’s how, in Angular, you can use directives to dynamically modify HTML in Views without polluting your business logic.
Our data science expert continues his exploration of neural network programming, explaining how regularization addresses the problem of model overfitting, caused by network overtraining.
- By James McCaffrey
- 10/05/2017
If you want to encrypt integer values, then you're going to need to store the result as a string. If you're also going to roundtrip those values from the server to the browser, you'll need this code.
There’s a potential security exploit that ASP.NET MVC leaves you open to. However, in Peter’s opinion, all the proposed solutions miss the point.