I'm doing some web development contract work this summer, and my scenario/task is this. The environment is broken up into Production / Staging / Testing / Local Dev All environments are running MS SQL ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

Server is a dual 3.4ghz Xeon w/ 4GB of RAM running Windows 2003 and SQL Server 2000 Standard. Nothing runs on the box other than SQL Server. DB-wise, just the db I'm having problems with [we'll call ...

I'm supposed to be a software developer/consultant. However, I'm also the guy people look at when the application isn't running "fast enough." With business applications, speeding up the application ...

Idera, a provider of Microsoft SQL Server management and administration tools, announced SQL virtual database 1.3, the latest release for this solution that enables backup files to look and act just ...

Iain Kick is a lead consultant for Quest Software SQL Server products. He has worked in the U.K. for Quest since 2005, and has presented on performance, configuration, security, disaster recovery, and ...

This template provides a baseline for evaluating enterprise DBA candidate’s skill set, ranging from application deployment support to database design. The go-to resource for IT professionals from all ...

One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...