Category: sql

(See also: all categories or the complete list of articles)

pushpop, a mental stack manager

The Secret Life of Connection Strings In Oracle! (Oracle DBA's Hate Me.)

The beauty of .ensure files

In search of brutal honesty

You Feel The Blood Drain From Your Face (A DevOps story)

UPDATE a table using a JOIN to another table (or to itself)

Sweating the Small Stuff

NimbleSET 2.0: Death to the VLOOKUP!

How Bundling Doubled The Income of 'NimbleText.com'

Boothby, a personal database

Internet's Last Classic ASP Website Finally Upgraded

If Time Types were like Spatial Types

Programming The Robot from Diary of a Wimpy Kid

CRUMBS! Commandline navigation tool for Powershell

Extracting a Trello board as markdown

AddDays: A Very Simple Date Calculator

A Computer Simulation of Creative Work, or 'How To Get Nothing Done'

Slurp up mega-traffic by writing scalable, timeless search-bait

Harvey, a .net chat server built with RabbitMQ

LeonBambrick.com

NimbleText 1.6, Codename Jetboat

On Task Hoarding and Todo Bankruptcy

NimbleText: Origins

Boring article about fixing a 'Login failed... untrusted domain' issue when connecting to SQL Server.

Setting up email for your microIsv

The NO Visual Studio movement: Compiling .net projects in Notepad++

A thank you I forgot to say

My new product, NimbleText, is live

Using NimbleSet to compare lists

DOS on Dope: The last MVC web framework you'll ever need

JSON Query Languages: 5 special purpose editors

SQLike: A simple editor

24 things to do, and 100 things *not* to do (yet) for building a MicroISV

A handy workflow image for newbie mercurial users

Fractal Feedback, a diversion into recreational programming

SQL Style Extensions for C#

DevShop: The Cool Game that Makes Development Look Fun

zen-coding: turn those CSS selectors upside down

The Real-Time online JQuery Editor

God No! ...The ReBuilder

Further proof that testing is for wimps and bad programmers

Differentiating between environments within SQL Server Management Studio

Low Frustration Tolerance: Curse and Blessing

It's 2009 already -- where's my damn internet-based IDE??

Give and Take in the Software Industry

baby steps in microsoft robotics studio...

IT Industry Revolutionised By Labour Saving Device

3 differences between 'Small Business' and 'Enterprise'

Life is Upstream

Simple Trouble Shooting Application Now Fixes Everything

A to Z of Software Methodologies

How Can Microsoft Beat Google?

TimeSnapper 3.1: Attack of the the Red/Green Stripes

21 tools used in our MicroISV

Should Linq To Sql Go "Open Source"?

Redux: New Synchronisation Idea Overlooked By Microsoft

Reuse good -- Abstractions better!

Word of the day: Upsert

sql,

What To (Really) Do If You Find Out Your Parents Are Using Vista (redux)

Everything that's bad for you is suddenly good for you!

Everything I know about Code Reviews I learnt from Star Wars (and JCooney)

Workflow software: I'm calling the bluff.

TimeSnapper 2.7: Word Clouds reveal your computing lifestyle!

Thought game: What if SQL had a type called 'Operator'

TimeSnapper 2.6: Hook It Up

Fuzzy Search: Check this out and report back please, o lazy web.

Revolutionary (versus Evolutionary) Code Generation

TimeSnapper Special - 9 More Days

Your Brain, And the Effects of Syntax Highlighting

Which came first... the domain model or the human?

Brisbane's Independent .NET Consultant

Why Are So Many Dev Tools Orange?

My First WPF Application - A visual tour

TimeSnapper On Sale: 2 year anniversary special

Password Protect Your TimeSnapper Images!

Step 5 of 25 to Building a Micro-ISV: Install traffic monitoring on your web site

General Purpose Programming Language... Good For Nothing?

A weird casestudy in technical research

Look at all the things I'm NOT doing!

How to aggregate a bit column

Exec Inline AddIn for Visual Studio 2005 -- Get It Now

ATM Thief Busted By Observant Internet Watcher?

Separation Anxiety

TimeSnapper Diabetes Promotion Ending Soon!

Perfect Productivity with TimeSnapper 2.4

ORM Smackdown!

MicroISV: Step 4 of 25 -- Basic Website Content

Faster Than Light -- For Real This Time

Translating a little bit of (microsoft) double talk...

Back Seat Driven Development

Step 3 of 25 -- Design Your Website

'Reuse' Is Not Usable

Is there a general solution to string templating?

How Naming Works At Microsoft

Essential 'Programming' Skills for Non-Programmers

TimeSnapper 2.3: Extract Text Using Optical Character Recognition

Step 2 of 25 to Building a Micro-ISV: Reliable Hosting

Step 1 of 25 to Building a Micro-ISV: Register a Domain

TimeSnapper 2.2 -- Auto Popup? That sounds terrible!

25 steps for building a Micro-ISV

How to Sneak .net 2.0 into an organization

Download It Now! Exec Inline: A VS2003 add-in that lets you run a chunk of code

New Year's Resolution: Build Your Own Micro ISV!

Give Your Manager A 500% Productivity Enhancement

Deadlocks: What would Feynman do?

Passwords in Sql Server 2000 are Case Insensitive by default -- WTF?

Never Pay For Application Development Services Again

ShinyPower Now Opensource

11 Tools for Database Versioning

TimeSnapper 2 Goes Live!

Gripping Reading, All The Way Through!

Sql Down Under Code Camp

syntactic sweeteners, part ][

Understanding JSON: the 3 minute lesson

Web 2.0: Something's Missing

Babysteps in PowerShell part deux: Variables! Real Proper Variables!

XML isn't a mark-up language.

KeyTraino

Collation Is Evil

sql,

6 Tools for Documentation++

ReDim for C#, using Generics

Amphetamines for Query Analyser

Never BCC an Idiot.

Big In Japan!

Marked up: Finalists for the 16th Annual Jolt Product Excellence & Productivity Awards

rescued by timeSnapper

Let's Go Right Ahead

Joe Celko, Bill of Materials, hierarchical nested trees, data explosion...

What is so scary about DLINQ?

LINQ love

Infinity LIMITed

Brisbane .NET Developer Position

A Color Gradient Webservice

Sexy Tool for Fast, Active Coding -- Any Language!

Simple Example of Using the World's Simplest Code Generator....

Hey Brisbaner! Want to join a Superfast, Wireless Peer To Peer Community?

Enhance Reporting Services By Including A Function Library

Use Your Instant Messenger To Query Amazon

Can Microsoft Reporting Services retrieve data from Oracle?

Sure beats Northwind.

You know your query is getting a little intense when...

sql,

SQL Server Enterprise Manager Tip: Printing Diagrams

The Future of Music, MP3s and Moods. Or not.

Impress your geeky colleagues with clever tips and hidden treasures

Save Dog as Virtual Chicken

Reporting services -- Tips and tricks

Sometimes you frustrate me, Mrs. Reporting Services.

Hiatus Halted

Clubbing the Crystal Dodo

Can you Nest Enums?

I must strangle someone.

sql,

Triggers: Very Good, or Very Bad?

MMMS: A Map of My Mind-Space

Y2-GAY: Government Approves Third Gender; DBA's Panic!

Embedded-Sql without Sql-Injection

Sexy New Development Methodology!

Just keep zooming -- the resolution never degrades.

Excel-Lite: Hey coder! This spreadsheet's for you!

Riddle me this, batman.

sql,

Two security hacks i'm looking forward to:

A few changes on the way

Never Trust A SysAdmin

Dogfooding Your Mother-In-Law

The four horsemen of the online apocalypse

It's the Little Things that Sh*t Me Most

sql,

ASP and the Tower of Babel

.Net Remoting: the Quick and Dirty Guide

Technical Year In review

Network Stuff

Smartjelly Improvements

"Dot-Net Awareness" Day!

Release Early Release Often

How to write a novel

Essential Software for Geeks and Power Browsers

Future Articles

(See also: All Years, all categories or the complete list of articles)