Damon Armstrong

SharePoint, HTTP Modules, and Page Validation

Sometimes I really believe that SharePoint actively thwarts my attempts to get it to do what I want. First you...

20 October 2012 3 min read

Andrew Hunter

Are Unit Tests Overused?

Unit Testing has come to dominate the many types of test that are used in developing applications. This has inevitably...

19 October 2012 13 min read

Louis Davidson

What Counts For A DBA – ESP

Now I don’t want to get religious here, and I’m not going to, but what I’m going to describe in...

18 October 2012 4 min read

red@work

Red Gate does Byte Night 2012

On the 5th of October 2012, a team of nine plucky Red Gaters braved the howling wind and the driving...

18 October 2012 4 min read

Dino Esposito

Syntactic Sugar and the Async Pill

Asynchrony is essential for scalability and performance on the server side. Although it has always been possible to write asynchronous...

18 October 2012 12 min read

Tony Davis

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

When things go wrong, a DBA's reputation depends on an understanding of the transaction log, both what it does, and...

16 October 2012 2 min read

Jacob Sebastian

Sven Aelterman

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

FILESTREAM is implemented as an extension to the VARBINARY(MAX) data type and allows large object data to be stored in...

16 October 2012 2 min read

Grant Fritchey

SQL Server Execution Plans, Second Edition, by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how...

16 October 2012 2 min read

Michael Williamson

Lightning talk: Tom Lewin – Team Fortress 2 for fun and profit

Last week, Tom Lewin taught us all about arbitrage by giving the lightning talk “Team Fortress 2 for fun and...

15 October 2012 1 min read

Jonathan Lewis

Temporary Tables in Oracle and SQL Server

This video is a follow up to the webinar broadcast by Red Gate on 13th September 2012. Please leave a...

15 October 2012 1 min read

Richard Morris

Alex Payne: Big in the IT Business

Alex Payne worked on developing Twitter for three years. When he started, it was a small side-project: When he left,...

15 October 2012 11 min read

Feodor Georgiev

Designing Databases for Rapid Resilience

As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure....

15 October 2012 12 min read

Tony Davis

Data Model Dissonance

So often at the start of the development of database applications, there is a premature rush to the keyboard. Unless,...

12 October 2012 3 min read

Robert Sheldon

Book Review: Microsoft SQL Server 2012 Bible

A broad topic requires a thick book. the Microsoft SQL Server 2012 Bible is the work of several authors and...

12 October 2012 9 min read

Robert Sheldon

Report Builder 3.0: Adding Charts to Your Report

Charts are one of the commonest ways of visualizing reports from data. Report Builder provides a way of generating charts...

11 October 2012 13 min read

Tim Ford

Louis Davidson

Tune Your Indexing Strategy with SQL Server DMVs

SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you...

11 October 2012 42 min read

Satishbabu Gunukula

Convert Single Instance to RAC – Part 2: Manually Convert to RAC

This article will focus on converting the single instance to RAC.…

10 October 2012 13 min read

Michael Sorens

Database Source Control Basics: Getting Started

It makes a lot of sense to do it, but how do you get started? Whatever you use to build...

09 October 2012 17 min read

Joe Sack

Exploring Semantic Search Key Term Relevance

SQL Server's 'Semantic Search' feature seemed an exciting feature when first shown. Was it really true that Microsoft had come...

09 October 2012 7 min read

Kalen Delaney

SQL Server Concurrency: Locking, Blocking and Row Versioning

Your application can have impeachable indexes and queries, but they won't help you if you can't get to your data...

02 October 2012 2 min read

Register for Simple Talk

Articles

SharePoint, HTTP Modules, and Page Validation

Are Unit Tests Overused?

What Counts For A DBA – ESP

Red Gate does Byte Night 2012

Syntactic Sugar and the Async Pill

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

The Art of SQL Server FILESTREAM by Jacob Sebastian and Sven Aelterman

SQL Server Execution Plans, Second Edition, by Grant Fritchey

Lightning talk: Tom Lewin – Team Fortress 2 for fun and profit

Temporary Tables in Oracle and SQL Server

Alex Payne: Big in the IT Business

Designing Databases for Rapid Resilience

Data Model Dissonance

Book Review: Microsoft SQL Server 2012 Bible

Report Builder 3.0: Adding Charts to Your Report

Tune Your Indexing Strategy with SQL Server DMVs

Convert Single Instance to RAC – Part 2: Manually Convert to RAC

Database Source Control Basics: Getting Started

Exploring Semantic Search Key Term Relevance

SQL Server Concurrency: Locking, Blocking and Row Versioning