Chris George

Antenna Aligner part 2: Finding the right direction

Last time I managed to get “my first app(tm)” built, published and running on my iPhone. This was really cool,...

21 May 2012 2 min read

Joe Sack

A first look at SQL Server 2012 Availability Group Wait Statistics

If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to...

21 May 2012 15 min read

Annette Allen

SSIS Basics: Setting Up Your Initial Package

When working with databases, the use of SQL Server Integration Services (SSIS) is a skill that often needs to be...

21 May 2012 19 min read

Fabiano Amorim

SQL Server Prefetch and Query Performance

Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting...

21 May 2012 11 min read

Brad McGehee

Checking Out SQL Backup Pro 7's New Automatic Backup Verification

Wouldn't it be great to offload the daily chore of checking the integrity of your production databases, and checking that...

18 May 2012 13 min read

Richard Morris

Chuck Lathrope: DBA of the Day

Chuck Lathrope was a finalist for the Exceptional DBA of the Year award in 2009. We contacted him to find...

17 May 2012 11 min read

David Njoku

Introduction to Oracle Flashback Technology (Part 1: Application Developers)

Imagine, if you will, that someone invented time travel. What would you do with it? Nip back into the past...

16 May 2012 7 min read

Clive Tong

C# Async: What is it, and how does it work?

The biggest new feature in C#5 is Async, and its associated Await (contextual) keyword. Anybody who is faced with creating...

15 May 2012 20 min read

Warwick Rudd

SQL Server 2012 AlwaysOn

SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It makes use of existing SQL Server...

15 May 2012 19 min read

Louis Davidson

What Counts For a DBA: Imagination

“Imagination…One little spark, of inspiration… is at the heart, of all creation.” – From the song “One Little Spark”, by...

11 May 2012 4 min read

Alex Davies

.NET Demon support for VS 11 dark theme

I’m pleased to announce that .NET Demon will be shipping simultaneously with Visual Studio 11, whenever it ends up being...

10 May 2012 1 min read

Wissem El Khlifi

Auto Restart Enterprise Manager Cloud Control Agent 12c

Introduction: Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database...

10 May 2012 1 min read

Laerte Junior

The PoSh DBA: Grown-Up PowerShell Functions

Laerte goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing...

10 May 2012 19 min read

Joe Celko

SQL VIEW Basics

SQL Views are essential for the database developer. However, it is common to see them misused, or neglected. Joe Celko...

10 May 2012 19 min read

Jonathan Kehayias

Handling Deadlocks in SQL Server

In this excerpt from his book Troubleshooting SQL Server: A Guide for the Accidental DBA, Jonathan Kehayias provides a guide...

10 May 2012 45 min read

Simon Cooper

Inside Red Gate – Ricky Leeks

So, one of our profilers has a problem. Red Gate produces two .NET profilers – ANTS Performance Profiler (APP) and...

04 May 2012 3 min read

Timothy Wiseman

SQL Scripts Manager and IronPython

As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows...

04 May 2012 10 min read

Ming Lee

What do you mean the cloud isn't free?

Because cloud services are so easy to deploy and scale-up, it is easy to start racking up unexpectedly high bills....

04 May 2012 9 min read

Jason Crease

Metrics – A little knowledge can be a dangerous thing (or ‘Why you’re not clever enough to interpret metrics data’)

At RedGate Software, I work on a .NET obfuscator called SmartAssembly. Various features of it use a database to store...

03 May 2012 6 min read

John Spears

.NET Demon 1.0 Released

Today we’re officially releasing version 1.0 of .NET Demon, the Visual Studio Extension Alex Davies and I have been working...

03 May 2012 2 min read

Register for Simple Talk

Articles