Blog

There are 4 items on 1 pages.

Solved: SQLite TypeInitializationException

Encountering the SQLite PCL error 'TypeInitializationException' after updating SQLite or installing it on a new project? This will solve it. - read more.

22 Nov 2016

Selecting records from an MS SQL database and improving query performance

Understanding simple select statements and how they are used to select data/records/rows from a table with an overview of how to use indexes as a go further exercise. - read more.

11 Jul 2016

SQL - Select records/rows with paging and result count

A nice and simple trick to return a paged result set using MS SQL and have the total results returned as a parameter which is useful for calculating how many pages there are. - read more.

17 Dec 2015

SQL Server - Delete all non distinct rows

A quick and easy to use snippet of SQL to run on MSSQL that will delete all rows where the specified columns are not unique. - read more.

9 Dec 2015
Share with
Tags
Latest Comments
By Luke Alderton on Replacing the Xamarin Header/Navigation bar with a custom view/template
17 Jan 2018, 15:30 PM
By Luke Alderton on My experience at Umbraco UK Festival 2017
17 Jan 2018, 14:51 PM
By Victor La Fortuna on Solved: 'Debug/ibTool/LaunchScreen.storyboardc/Info.plist does not exist' Xamarin
10 Jan 2018, 14:32 PM
By Jose Luis on Replacing the Xamarin Header/Navigation bar with a custom view/template
7 Jan 2018, 11:06 AM
By Chris Howarth on My experience at Umbraco UK Festival 2017
28 Dec 2017, 10:32 AM
By Luke Alderton on Xamarin forms - Stop/Cancel back button event
20 Dec 2017, 05:49 AM
By Antony on Xamarin forms - Stop/Cancel back button event
18 Dec 2017, 11:19 AM
By dipbleds on Raspberry Pi - Bluetooth using Bluecove on Raspbian
12 Dec 2017, 21:29 PM
Categories
App Development
Event
Game Development
Mapping
Modelling
Programming
Review
Robotics
Tutorial
Web Development