Patrick Barel

Working with Table Functions in PL/SQL

Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be...

20 July 2011 2 min read

Database Administration

Glenn Berry in Database Administration

Configuring the Storage Subsystem

The storage subsystem for a SQL Server can prove to be a bottleneck if the best choices of hardware aren't...

20 July 2011 42 min read

Rebecca Amos

Finalists announced! Exceptional DBA Awards 2011

Thank you again to everyone who entered this year’s Exceptional DBA Awards. We had a record number of responses this...

19 July 2011 1 min read

Jonathan Allen

SQL in the City in retrospect – part 1

The journey, the build-up and the day The Journey We left Devon early on the Tuesday. Very early. We had...

19 July 2011 5 min read

red@work

Technology Ventures Conference

Red Gate attended the Technology Ventures Conference (TVC), held at the Cambridge Student Union on the 8th June, and we...

15 July 2011 2 min read

red@work

Cooking up a Storm

I recently moved from Red Gate’s Finance team to The Agency, where the Marketing magic (And all the colouring in),...

14 July 2011 5 min read

Louis Davidson

Denali Enhancement–Duplicate Key Error Message

When I was editing my chapter on implementing a database, I noticed a really nice improvement in the error message...

14 July 2011 3 min read

Hima Bindu Vejella

Entity Framework 4.0 – Learn to Create Databases from the Model

For application developers focusing on the needs of their code, rather than worrying about the complexities of data representation, the...

14 July 2011 13 min read

Michael Sorens

Down the Rabbit Hole- A Study in PowerShell Pipelines, Functions, and Parameters

For an experienced programmer to learn a new language can be a journey quite like Alice's in wonderland. Paradoxes, unexpected...

14 July 2011 22 min read

Louis Davidson

What Counts For A DBA: Education

There comes a point in many people’s lives where they stop adding new knowledge and become stuck at a point...

12 July 2011 5 min read

Brien Posey

Network Administrators Past, Present, and Future

Even in the short time that PCs have been signficantly networked, what it means to be a SysAdmin has changed...

11 July 2011 10 min read

Louis Davidson

Chapter 8–Patterns and Anti-Patterns

In this last kind of “creative” chapter, I will look at some of the ways you implement common problems in...

10 July 2011 3 min read

Tony Davis

Bug Me Not

Bug metrics are a notoriously erratic way to judge the performance of a development team and project, but despite this...

08 July 2011 4 min read

Jonathan Allen

It’s good to be a little bit scared

How many times have you read or heard that phrase from someone about to embark on some endeavour? A stand-up...

08 July 2011 3 min read

Simon Cooper

Inside Red Gate – Testers

Developers might write good code, but no matter how good they are the result will always have bugs in it....

07 July 2011 3 min read

Dino Esposito

ASP.NET MVC Action Results and PDF Content

The Action Result in ASP.NET MVC provides a simple and versatile means of returning different types of response to the...

06 July 2011 13 min read

Learn SQL Server

Chris Shaw in Learn SQL Server

Building Your DBA Skillset

As a DBA and hiring manager, Chris Shaw has been on those sides of the recruitement process. As an MVP...

06 July 2011 23 min read

Richard Mitchell

Windows 8 inspired website

Download the zip here Working in New Biz As I work in Red Gate’s new business division much of what...

05 July 2011 2 min read

Laerte Junior

PowerShell Eventing and SQL Server Restores

When you're managing a large number of servers, it makes no sense to run maintenance tasks one at a time,...

05 July 2011 13 min read

Joe Celko

Arrays in SQL that Avoid Repeated Groups

It is certainly possible to fake an Array in SQL, but there are only a few occasions when it would...

05 July 2011 11 min read

Register for Simple Talk

Articles

Working with Table Functions in PL/SQL

Configuring the Storage Subsystem

Finalists announced! Exceptional DBA Awards 2011

SQL in the City in retrospect – part 1

Technology Ventures Conference

Cooking up a Storm

Denali Enhancement–Duplicate Key Error Message

Entity Framework 4.0 – Learn to Create Databases from the Model

Down the Rabbit Hole- A Study in PowerShell Pipelines, Functions, and Parameters

What Counts For A DBA: Education

Network Administrators Past, Present, and Future

Chapter 8–Patterns and Anti-Patterns

Bug Me Not

It’s good to be a little bit scared

Inside Red Gate – Testers

ASP.NET MVC Action Results and PDF Content

Building Your DBA Skillset

Windows 8 inspired website

PowerShell Eventing and SQL Server Restores

Arrays in SQL that Avoid Repeated Groups