What Counts For a DBA: Practicality

As a data architect, and writer on the same subject, I am completely entrenched in learning and applying the discipline...

15 December 2011 4 min read

Sam Bendayan

Constraints and the Test-Driven Database

Bad data always seems to appear when, and where, one least expects it. Sam explains the great value of a...

14 December 2011 13 min read

Shameer

PHPFog and Pagoda Box: A Look at PHP Platforms

Cloud platforms such as Heroku, AppEngine, PHPFog and Pagoda Box are ideal for companies who just want to focus on...

14 December 2011 6 min read

Matt Simmons

Physical Network Layout for the Reluctant

How do you select the hardware for your network, and connect it all together? How do you then test your...

13 December 2011 50 min read

Simon Cooper

Subterranean IL: Explicit overrides

Normally, virtual method overrides in .NET are done implicitly; if a subclass has a virtual method with the same name...

12 December 2011 6 min read

Feodor Georgiev

Administrating SQL Server Integration Services – Planning, Documenting and Troubleshooting

SQL Server Integration Services is an essential component of SQL Server, and designed to perform a variety of routine and...

12 December 2011 15 min read

Jonathan Kehayias

Great SQL Server Debates: Lock Pages in Memory

There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL...

12 December 2011 19 min read

Jeff Smith

Simple Bar Chart Reports with SQL Developer

There are many good articles out there that go into detail for creating reports with Oracle SQL Developer. I was...

09 December 2011 2 min read

Simone Chiaretta

ASP.NET MVC Routing Extensibility

You develop an ASP.NET MVC application by extending it; customising any default logic that you wish to change with your...

09 December 2011 13 min read

Patrick Barel

Invoker Rights Part 1

Truth suffers from too much analysis. Frank Herbert In the Oracle database you have a choice of two models for...

08 December 2011 4 min read

Robert Sheldon

The XML Methods in SQL Server

The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and...

08 December 2011 22 min read

Grant Fritchey

Backup Verification: Tips for Database Backup Testing

A Backup system is merely part of a recovery system. If your backups can't be used to recover the database,...

06 December 2011 4 min read

Phil Factor

Smart Storage Server for a Dumb Curmudgeon

(Guest Editorial for the SysAdmin/ITPro Newsletter) It’s been many years since I had to set up and maintain the network...

05 December 2011 3 min read

Grant Fritchey

Faster Restores: Best Practices to Increase Speed

Backups are an everyday part of DBA life, whereas restores tend to happen on call at 3 a.m. In this...

02 December 2011 5 min read

Antoine Khater

Extending Exchange 2010 Shadow Redundancy Cross Forest

When a customer asks for an Exchange Server feature that you have no idea how to implement, and you just...

01 December 2011 8 min read

Grant Fritchey

Unit Testing TSQL

I went through a period of time where I spent a lot of effort figuring out how to set up...

30 November 2011 3 min read

Database Administration

Grant Fritchey in Database Administration

Grant Fritchey’s SQL Server Howlers

We decided to ask various well-known SQL Server people to write about their favourite SQL Server Howlers. These are the...

30 November 2011 16 min read

Matt Simmons

Logical Network Layout for Small Networks

Matt examines what it's like to design a network from the ground up, as well as dealing with an existing...

28 November 2011 30 min read

Fabiano Amorim

Window Functions in SQL Server: Part 2-The Frame

Fabiano continues his introduction to SQL Server's implementation of the window functions by giving a history of what got implemented...

24 November 2011 13 min read

Richard Morris

Jeff Moden: DBA of the Day

Jeff Moden's election to the Exceptional DBA of the Year award for 2011 was a popular one. Although all the...

24 November 2011 17 min read

Register for Simple Talk

Articles

What Counts For a DBA: Practicality

Constraints and the Test-Driven Database

PHPFog and Pagoda Box: A Look at PHP Platforms

Physical Network Layout for the Reluctant

Subterranean IL: Explicit overrides

Administrating SQL Server Integration Services – Planning, Documenting and Troubleshooting

Great SQL Server Debates: Lock Pages in Memory

Simple Bar Chart Reports with SQL Developer

ASP.NET MVC Routing Extensibility

Invoker Rights Part 1

The XML Methods in SQL Server

Backup Verification: Tips for Database Backup Testing

Smart Storage Server for a Dumb Curmudgeon

Faster Restores: Best Practices to Increase Speed

Extending Exchange 2010 Shadow Redundancy Cross Forest

Unit Testing TSQL

Grant Fritchey’s SQL Server Howlers

Logical Network Layout for Small Networks

Window Functions in SQL Server: Part 2-The Frame

Jeff Moden: DBA of the Day