Category Archives: Configuration

Stopping and Starting SQL Server Instance 08R2 Express

Simply within SSMS right click on the instance and hit STOP and To start an instance if you are still in SSMS you can simply right click and hit start Note if you stop a SQL Server instance from within … Continue reading

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Stopping and Starting SQL Server Instance 08R2 Express

Allowing sa login and altering password SSMS SQL 08 R2 Express

Recently I installed SQL Server 08 R2 Express. As part of the standard installation the sa login is disabled as default. Clearly although this is a useful security feature it is a bit awkward if you are wanting to undertake … Continue reading

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Allowing sa login and altering password SSMS SQL 08 R2 Express

BANISH DOUBLE CLICKING – My UI Design Patterns

I eluded to it in my last post but when I have tabulated forms I like to have the labels activated and set to sort alphabetically ascending on left click and descending on a right click. I use the mouse … Continue reading

Posted in All, Configuration, Database Design, MS Access, My UI Design Patterns, User Interface Design, VBA Code MS Access | Comments Off on BANISH DOUBLE CLICKING – My UI Design Patterns

Configuration vs Programming

I used to find configuration kind of frustrating – highly repetitive unintuitive and often changing as software versions change. I now consider it a simple exercise in rote learning for which there is no solution except perseverance, patience and determination and … Continue reading

Posted in All, Configuration, Problem Solving, Productivity, Programming | Tagged , | Comments Off on Configuration vs Programming