Dean Hume's Blog
  • Home
  • About
  • Progressive Web Apps
  • Web Performance

SQL

A collection of 3 posts
SQL

A Simple Guide to SQL Compact 4

There has been quite a lot of interest building up recently around SQL Compact 4. Now, if you are not familiar with SQL compact, it's basically a database engine that is free and totally embedded. You don't need to install a database anywhere on your server. Not only that, but
Sep 7, 2010 4 min read
SQL

Compiling LINQ queries for improved performance

I've been using Linq to Sql for quite a while now, and here and there I have heard of compiling your Linq queries mentioned. Now I know that this feature has been around for a while in terms of .net, but I have never actually got round to using it.
Jun 22, 2010 2 min read
SQL

Useful SQL Script to generate Countries & US States

I'm currently working on a project where I need to quickly insert a list of Countries and Us States into a database table. This is not the first time that I've needed to have a useful script handy for this sort of thing. I had a quick look around the
Apr 13, 2010 1 min read
Page 1 of 1
Dean Hume's Blog © 2025
  • Sign up
Powered by Ghost