Rob Garrison

What’s the Point of Using VARCHAR(n) Anymore?

The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the...

30 January 2012 11 min read

Alex Nuijten

Comparing Schemas: Red Gate Schema Compare for Oracle

This week I attended a webinar by Cary Millsap, organized by Red Gate. It was called “Real Developers DO use...

26 January 2012 2 min read

Patrick Barel

Invoker Rights Part 2

Kindness is the beginning of cruelty Frank Herbert Syntax If you check the syntax for the different program objects you...

25 January 2012 4 min read

Craig Box

Dial in the scale: Amazon’s new DynamoDB

Dynamo is a fast and scalable proprietary key-value structured storage system that gives the features of both simple databases and...

25 January 2012 8 min read

Simon Cooper

Inside the Concurrent Collections: ConcurrentQueue

ConcurrentQueue is, like ConcurrentStack, a lockless collection, in that it is implemented without using any locks at all. However, the...

24 January 2012 10 min read

Richard Morris

Scott Shaw: DBA of the Day

Scott Shaw was one of the finalists to the 2011 Exceptional DBA Award (XDBA). The award was founded in 2008...

24 January 2012 13 min read

Syed Jaffar Hussain

An Easy Way to Obtain 10053 Trace

I have just learnt a couple of new methods to obtain an Optimizer (10053) trace for any sql statement that...

23 January 2012 1 min read

Phil Factor

Confessions of a DBA: My worst mistake

Over the next few months, we'll be asking various well-known DBAs to describe their worst disaster caused by a mistake...

23 January 2012 6 min read

Michelle Malcher

DBA Monitoring Top Five

Have you ever just sat there watching all of the processes running against the database, just waiting for something to...

19 January 2012 6 min read

Grant Fritchey

SQL Cop Review

Static code analysis is used a lot by application programmers, but there have been surprisingly few tools for SQL development...

19 January 2012 7 min read

Brian Donahue

It always works on my machine.

Probably the most common question that the Red Gate developer tools support gets is “Does your X work with Y?”...

18 January 2012 2 min read

Jonathan Kehayias

Great SQL Server Debates: Buffer Cache Hit Ratio

One of the more popular counters used by DBAs to monitor the performance, the Buffer Cache Hit Ratio, is useless...

18 January 2012 15 min read

Richard Morris

Chuck Moore on the Lost Art of Keeping It Simple

Chuck Moore is still the radical thinker of Information Technology, After an astonishing career designing languages (e.g. FORTH), browser-based computers,...

18 January 2012 13 min read

Simon Cooper

Inside Red Gate – Experimental Results

As a brief interlude from my Concurrent Collections series, I thought I would give an roundup of how the lean...

17 January 2012 5 min read

Roel Hartman

Wouldn’t you like to talk to your APEX app?

You may be familiar with Martin Giffy D’Souza’s blog talkapex.com (if you’re not, check it out – it’s really worthwhile)....

17 January 2012 1 min read

Robert Young

Relational Databases and Solid State Memory: An Opportunity Squandered?

The relational model was devised long before computer hardware was able to deliver an RDBMS that could deliver a fully...

17 January 2012 6 min read

Jaap Wesselius

Exchange 2010 SP1 – A Practical Approach

This update of Jaap Wessellius' popular guide to Exchange 2010 covers everything you need to know to install, run and...

17 January 2012 2 min read

Damon Armstrong

Managing ItemUpdating and ItemUpdated Events Firing Twice in a SharePoint Item Event Receiver

Developing a Sharepoint application would have all the fun of a video game, if only you had infinite lives. Dangers...

17 January 2012 13 min read

Alamzeb Khan

Pakistan: Cyber Warfare and Internet Hacking

The extent of malicious hacking on the internet, in pursuit of political or economic advantage, crime or just plain mischief,...

17 January 2012 10 min read

Alex Davies

A new toy – .NET Demon

I’d like to present a new tool for .NET Developers that we’ve been cooking up in the Red Gate .NET...

16 January 2012 1 min read

Register for Simple Talk

Articles