How To


The Fastest Data Access Possible with Compiled Procs

If, in your "need for speed," you're looking to access and update your data as fast as possible, you can get to that goal by combining memory-optimized tables with compiled procs.

Speed Up Your Application with SQL Server In-Memory Tables

If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even better in SQL Server 2016, 2017 and Azure.

Debugging Xamarin Android Apps

You have a bunch of options for debugging Android applications built with Xamarin. Unfortunately, only one of them has worked well for Peter in all scenarios. Here are all your options with Peter's opinion on each and a recommendation on the best one.

Integrating JavaScript and C# in the Browser: Beyond the Basics with Blazor

If you want to call Blazor .NET code from JavaScript (or vice versa) with instantiated objects, or while passing multiple parameters, or while catching the results produced by that code, here's how to do it.

When You're Your Own DBA: Speeding Up SQL Server

You're not a DBA but you're responsible for managing your organization's SQL Server installation. Here are some tips on what you can do to speed up all your data access.

Defining Web API Services and Clients with NSwag

The OpenAPI (Swagger) technology suite includes a file that describes your Web API service. Peter thinks it's the slickest tool available to ensure that clients can access your services.

How to Consume Web APIs in Blazor

Chris Sainty provides hands-on code samples on how to use Web APIs to interact with Blazor, an experimental framework from the ASP.NET team that allows developers to write C# and Razor code and have it run in the browser via WebAssembly.

Speeding Up Queries: How to Think About Query Plans

If you want to speed up your SQL Server queries you need to know how your application and your users actually use your database.

The 5 Essential Patterns in Xamarin Applications

There are five design patterns you'll use every time you create a smartphone application. One is imposed by the environment and one is a pattern that you've probably been avoiding when creating other kinds of applications.

How to Do Neural Binary Classification Using Keras

Our resident data scientist provides a hands-on example on how to make a prediction that can be one of just two possible values, which requires a different set of techniques than classification problems where the value to predict can be one of three or more possible values.

Making Testing Worthwhile

That understanding should drive how you deal with testing, including how to turn it into a value-added task.

Integrating Blazor and JavaScript Code

Downloading compiled C# code to the browser using Blazor is all very good -- but it would be so much better if you can integrate your Blazor code with JavaScript. Here’s how to do that.

Generate Useful Documentation for Your Web API Project

If you want to impress your boss (or client) with your diligence in generating documentation for your Web Service, then you need Swagger. That it will also make it easier for you to run tests on your service and check for typical errors is just icing on the cake.

Your First Blazor App

Blazor is the Microsoft toolset that exploits the WebAssembly standard to let you write C# code that will run in your browser. Here's how to set up Visual Studio 2017 and create your first app.

'Hello World' for Your Smartphone: Your First Xamarin Application

Here's a step-by-step guide to creating a Xamarin project in Visual Studio 2017.

Dealing with Unsafe DELETEs in RESTful Services

Your DELETE request to the service just timed out. Surely, it's safe to send it again. Actually, it may not be.

Styling Xamarin.Forms Apps with CSS

New support for styling Xamarin.Forms apps with CSS may be controversial, but Greg Shackles thinks CSS is a powerful (and frequently maligned) solution to the problem of styling native mobile applications. See what he means in this hands-on tutorial.

Dealing with Unsafe Methods in RESTful Services

Your update request to the service just timed out. Is it safe to send it again? Maybe. Here's how to ensure that all your update, delete and add requests are safe plus some advice on what you should really be calling them and handling concurrency.

Build Your First TypeScript Application (2018)

Here's what a real-world "Hello, World" TypeScript application looks like (beginning with a discussion of whether you need TypeScript at all).

Your First Xamarin.Forms Project

If you've got a recent version of Visual Studio (Visual Studio 2017 Community Edition, for example) then you can start creating an Android application. Here's what you need to do to get your first project set up.

Clustering Non-Numeric Data Using Python

The data science doctor explains everything you need to know about clustering data, the process of grouping items so those in a group (cluster) are similar and items in different groups are dissimilar.

Leveraging Raw SQL in Entity Framework Core

The ability to use SQL with Entity Framework Core has always been a cool feature. There's a new feature in Entity Framework Core that opens the door for whole new set of SQL-related functionality.

Setting Up Your TypeScript Application – 2018 Version

If you're wondering how to start integrating TypeScript into your development practices, here's both when to do it and how to do it.

Sound-Effect Audio with Xamarin.Forms

Wally builds an app prototype and in response to user feedback investigates how to play audio sound effects in response to events such as a button press.

High Performance Object-Oriented Data Access with Dapper

Entity Framework is fabulous ... but it does impose some overhead. If you like working with data in an O-O kind of way but feel the "need for speed," then you should be looking at Dapper.

Subscribe on YouTube