This article explores the place of emotion among knowledge workers doing team-based design activities.  Read more...

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...

Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).  Read more...

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...

Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.  Read more...

Parses up & down the dependency chain of an object.  Read more...

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...

The usefulness and utility of the SQL Server Agent cannot be overstated. Oracle Database supports the automatic starting of an instance, so whatever is associated with the Oracle instance can also be started along with the instance. The same holds true with the SQL Server instance and its agent service.  Read more...

If you own a business, I believe that you have a right to make more money than the rest of your employees. You are taking on a risk, and greater risk should result in greater reward, at least that’s how capitalism is supposed to work. But what about management...  Read more...

There is a good chance that the process of purchasing software or hardware in your organization involves several people. DBAs will often initiate a request, but are not normally trained in the arts of influencing the management decision process to ensure that essentials get purchased. It is becoming essential to understand how to get Management support for software purchases. Dan offers nuggets of wisdom.  Read more...

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...

Over the years, I have assisted so many different clients whose transactional log file has become "too large" that I thought it would be helpful to write about it. The issue can be a system crippling problem, but can be easily avoided. Today I'll look at what causes your transaction logs to grow too large, and what you can do to curb the problem.  Read more...

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...

Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).  Read more...

Parses up & down the dependency chain of an object.  Read more...

This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.  Read more...