Auto Shrink DB = FRAGMENT index

Auto-shrink – turn it OFF!

Casting

Cheat Sheet - Casting in VB.NET and C# - The Code Project - .NET

What kind of join am I? (example SQL code)

Create Table Fred
( TheID INTEGER
, TheName VARCHAR(20)
)

Create Table Jobs
( TheID INTEGER
, TheJob VARCHAR(20)
)

INSERT INTO Fred VALUES (1, 'Fred')
INSERT INTO Fred VALUES (2, 'Freddy')
INSERT INTO Fred VALUES (3, 'Fredrick')

INSERT INTO Jobs VALUES (1, 'Boss')
INSERT INTO Jobs VALUES (4, 'Slave')

SELECT F.TheID, F.TheName, J.TheID, J.TheJob
FROM Fred F
INNER JOIN Jobs J On J.TheID = F.TheID

SELECT F.TheID, F.TheName, J.TheID, J.TheJob
FROM Fred F
RIGHT JOIN Jobs J On J.TheID = F.TheID

SELECT F.TheID, F.TheName, J.TheID, J.TheJob
FROM Fred F
LEFT JOIN Jobs J On J.TheID = F.TheID

Fashion Slave

ThinkGeek: "Wi-Fi Detector Shirt"

IT truths

Computerworld:

Seven years later, IT truths still hold Frank Hayes' 2000 column still relevant today

Now we have a medical reason to eat chocolate

BBC NEWS | Health | Chocolate 'aids fatigue syndrome':

Patients in a pilot study found they had less fatigue when eating dark chocolate with a high cocoa content than with white chocolate dyed brown. Researchers from Hull York Medical School said the results were surprising but dark chocolate may be having an effect on the brain chemical serotonin.

Fujitsu to acquire Infinity

ComputerWorls article

Strap yourselves in - this could be an interesting ride.

BTW "reporting from the edge of Fujitsu" is not quite the kewl tag line I am looking for.

SQL Server XML Cribsheet

SQL Server XML Cribsheet

a simple but good reason for Partial Methods in VB

What are Partial Methods useful for?

Interesting Architecture Discussion

Is we or isn't we a profession?

Real-time Web Monitor

Real-time Web Monitor: "Akamai monitors global Internet conditions around the clock. With this real-time data we identify the global regions with the greatest attack traffic, cities with the slowest Web connections (latency), and geographic areas with the most Web traffic (traffic density)."

SQL Server password bypass

How to access SQL Server when you've forget the password

Nice piece on the evils of FPQ

Mindscape - MindBlog: "How to Win the Services Game"

SQL Server: JOIN vs IN vs EXISTS - the logical difference

SQL Server: JOIN vs IN vs EXISTS - the logical difference:

There is a common misconception that IN behaves equaliy to EXISTS or JOIN in terms of returned results.
This is simply not true. To see why not, let's review what each statement does.

IN: Returns true if a specified value matches any value in a subquery or a list.
Exists: Returns true if a subquery contains any rows.
Join: Joins 2 resultsets on the joining column.

Origami to the max

foldschool - cardboard furniture: "foldschool is a collection of free cardboard furniture for kids, handmade by you. The downloadable patterns can be printed out with any printer. Follow the instructions and assemble a stable piece of furniture."

Desktop Icon Util

::: DIManager X :::

a small, practical tool to quickly save and restore the position of desktop icons.

Byte Volume

Measuring Data Transfer Rate in US Teaspoons per Second

DOS Special Characters

DDB: DOS Characters: "A Short Discussion of DOS Symbols"

MrDee buys Google

MrDeeoogle

Useful resource - Impossible to find on MSDN

Windows Environment Variables
DOS Commands A-M
DOS Commands N-Z

Warning: the GUI is for the seriously art challenged! Orange text on black - seriously ugly.

SQL 2005 Performance

Troubleshooting Performance Problems in SQL Server 2005

Awesome database resource from Barry Williams

450+ free Kick-Start Databases

80's geek humour

ThinkGeek :: Kitt is a Cylon

Others are afraid to say it but we know the truth. If it's got a sweeping red eye, it's not to be trusted.

Cloning Ron Jacobs

ARCast NZ #1

"How to convince management that letting a Developer become an Architect is a good idea".

great to hear a kiwi accent on a global issue.

Would you like some free Icons?

Sign up free icons
Add MrDee as a friend and I might send some more your way