Performance

Jonathan Kehayias in Performance

A Performance Troubleshooting Methodology for SQL Server

When healing a sick SQL Server, you must forget the idea that there could ever be a simple correspondence between...

28 September 2011 33 min read

Rebecca Amos

An interview with Jeff Moden – Exceptional DBA 2011

He may call himself an “Accidental DBA”, but the many SQL Server professionals who have benefited from Jeff Moden’s knowledge...

27 September 2011 2 min read

Patrick Barel

Bulk Processing in Oracle Part 2

The process of learning requires not only hearing and applying but also forgetting and then remembering again. – John Gray...

27 September 2011 4 min read

Louis Davidson

MVP Deep Dives 2: Coming Really Soon

You probably have noticed that I haven’t blogged all that much these days. Part of the reason has been taking...

27 September 2011 3 min read

Learn SQL Server

Robert Young in Learn SQL Server

Going Beyond the Relational Model with Data

SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw...

27 September 2011 28 min read

Jonathan Allen

PASS UK Regional Mentor

I have just had an email from Mark Ginnebaugh welcoming me to the role of PASS UK Regional Mentor. This...

26 September 2011 1 min read

Grant Fritchey

SQL Azure Backup and the Command Line

SQL Azure has no scheduling capabilities at all. If you want to schedule something like, oh, I don’t know, a...

26 September 2011 1 min read

Joe Celko

Mimicking Network Databases in SQL

Unlike the hierarchical database model, which created a tree structure in which to store data, the network model formed a...

26 September 2011 11 min read

Gert Poel

Oracle Forms Survey

Posted by Gert Poel on the the iAdvise blog: I want to call all Oracle Forms developers and administrators to...

23 September 2011 1 min read

Laila Lotfi

The Metro Surfaces

Our perceptions of Windows 8 are currently based on the live tiles of Windows Phone 7.5 ‘Mango’ and the touch-based...

22 September 2011 3 min read

Grant Fritchey

SQL Azure Backup and the BACPAC

Our new tool, SQL Azure Backup, is constantly undergoing changes just as SQL Azure itself does. Here’s a link to...

21 September 2011 1 min read

Simone Chiaretta

An Introduction to ASP.NET MVC Extensibility

Because ASP.NET MVC has been designed with extensibility as its design principle; almost every logical step of the processing pipeline...

21 September 2011 12 min read

Chet Justice

ORACLENERD T-Shirts

Recently I was asked to create some merchandise that fell outside of my norm. Specifically, I was asked to create...

20 September 2011 2 min read

Grant Fritchey

SQL Azure, the bacpac & Storage Containers

Silly me. I thought it would be easy. I grab a copy of the latest SQL Azure Backup and I...

20 September 2011 3 min read

Simon Cooper

The .NET Dictionary

To many people, System.Collections.Generic.Dictionary<TKey,TValue> is just a useful collection. In this post, I’ll be looking inside that collection and see...

16 September 2011 5 min read

Alex Nuijten

How Long is this String?

A quick puzzle from Alex Nuijten’s blog: How long is the folowing string?: to_char (10, ‘0999’) Have a think, and...

15 September 2011 1 min read

Jim Tilson

Writing Better Dynamic SQL

Dynamic SQL is a powerful tool. In its proper place it can achieve quite a bit of work in a...

14 September 2011 7 min read

Geoff Hudik

Red Gate Schema Compare for Oracle Review

From Geoff Hudik’s blog. As part of my recent role in application release management, I have had to compare and...

13 September 2011 2 min read

Tools

Grant Fritchey in Tools

SQL# (SQLsharp): A Review

Only the brave, and foolhardy, write production CLR routines if you can get the functionality already-written and tested. Whether you're...

13 September 2011 19 min read

Database Administration

Brad McGehee in Database Administration

Database Properties Health Check

Within an instance of SQL Server, the database settings can have a direct effect on the database's behavior, performance and...

13 September 2011 35 min read

Register for Simple Talk

Articles

A Performance Troubleshooting Methodology for SQL Server

An interview with Jeff Moden – Exceptional DBA 2011

Bulk Processing in Oracle Part 2

MVP Deep Dives 2: Coming Really Soon

Going Beyond the Relational Model with Data

PASS UK Regional Mentor

SQL Azure Backup and the Command Line

Mimicking Network Databases in SQL

Oracle Forms Survey

The Metro Surfaces

SQL Azure Backup and the BACPAC

An Introduction to ASP.NET MVC Extensibility

ORACLENERD T-Shirts

SQL Azure, the bacpac & Storage Containers

The .NET Dictionary

How Long is this String?

Writing Better Dynamic SQL

Red Gate Schema Compare for Oracle Review

SQL# (SQLsharp): A Review

Database Properties Health Check