Skip to content

Category Archives: Database

Quick Tip: Access SQL Server Across Local Area Network / Internet

27-Sep-09

To access your SQL Server 2005 / 2008 instance across a LAN or the Internet you must first ensure that TCP/IP is enabled on the SQL Server instance you are trying to access and you are connecting on the correct port (by default, TCP 1433).
So as quoted on MSDN, this is how you enable TCP/IP [...]

Also filed in | | Comments (3) »

Can't Install Microsoft SQL Server 2008 Management Studio Express

24-May-09

Ok, I’m angry, and two hours of my time has gone that I will never get back.
I’ve just spent the morning trying to get Microsoft SQL Server 2008 Express + Management Studio installed after a PC format. I’m running Windows 7 64-bit Ultimate (x64) and all files in question below were downloaded via the Microsoft [...]

Also filed in | Tagged | Comments (27) »

Normalizing Your Database: The Basics

25-Mar-09

Are you interested to learn more about database normalisation? or not sure really what it’s about? Or chances are if you’ve worked with, or created your own database, you’ve performed database normalisation without even knowing it.
Well I found a great article on this topic and it’s definitely a keeper. Anyway the below is shamelessly [...]

Also filed in | | Comments (0) »

Country Name and ISO 3166 SQL Server Import File

22-Jan-09

Howdy,
Today I found myself in need for a country list (specifically ISO 3166 for completeness) and like many others it wouldn’t be the first time I’ve needed to install one of these in a database. So off I headed to google in search for a ISO country list sql server (.sql) import file.
Found a [...]

Also filed in | Tagged , | Comments (0) »

Sql Server 2008 Express Setup Woes

10-Dec-08

When running the SQL Server 2008 Express installer I go through all the steps and then the installation begins, then just before completion I receive:
” is not a valid login or you do not have permission.
So I was tearing my hair out on this one. I’m running Windows Vista SP1 and using the latest SQL [...]

Also filed in | Tagged | Comments (0) »
My name is Graham O'Neale and I'm a software architect from Gold Coast, Australia. I am an overtime thinker, full time coder and awake part time in the real world. I have a keen interest in software development, particularly in the realm of programming (C#, ASP.NET, ASP.NET MVC, LINQ (2 SQL), Entity Framework, Silverlight, Blend, WCF, WPF) and a keen interest in the cutting edge and innovation. I have a new found love for design patterns, ALT.NET practices and well crafted software architecture. The purpose of this blog is to express any thoughts, findings, tips and gripes along my travels in the wonderful world of coding and technology...