chapman.tim-gmail, Author at TechRepublic

chapman.tim-gmail

Bio

Tim Chapman is a SQL Server MVP, a database architect, and an administrator who works as an independent consultant in Raleigh, NC, and has more than nine years of IT experience.

Latest from chapman.tim-gmail

Data Management

Get database properties using PowerShell in SQL Server 2008

Tim Chapman shows how you can use PowerShell scripts in SQL Server 2008 to take an inventory of database properties for SQL Server instances on your network.

CXO

Comparing cursor vs. WHILE loop performance in SQL Server 2008

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

Banking

Setting up Change Data Capture in SQL Server 2008

Change Data Capture (CDC) is a new native feature in SQL Server 2008 Enterprise Edition. Tim Chapman shows how to use CDC to easily set up data auditing on your SQL Server system.

Banking

Introduction to Change Data Capture in SQL Server 2008

In today's database tip, SQL Server database consultant Tim Chapman takes a look at the great new auditing features available in SQL Server 2008.

Data Management

Perils of Adding fields to Database Tables

If you're not careful, when you add a field to a database table, you may cause all sorts of problems. Today, database consultant Tim Chapman looks at two such scenarios, and how you can plan for their occurrence.

Data Management

Filtered Indexes in SQL Server 2008

Filtered indexes are a neat new feature in SQL Server 2008 that allows you to define indexes on subsets of data. In today’s article, database architect Tim Chapman shows how you can take advantage of this useful new feature.

Data Management

Using Hash Fields in SQL Server

From auditing data changes to capturing data for loading a data warehouse, hash fields have a ton of practical uses. In today’s article, database consultant Tim Chapman shows how you can use built-in SQL Server functions to create your own hash fields.

Data Management

Using Object Dependencies in SQL Server 2008

Previous versions of SQL Server were not that great at keeping track of object dependencies. SQL Server 2008 greatly expands on this capability by tracking objects by the name of the object, rather than relying upon the ID. Here's how it works.

Data Management

How do I run code automatically when SQL Server starts?

The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. Today, consultant Tim Chapman gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on startup.

Data Management

Reviewing SQL Server Permissions

SQL Server consultant Tim Chapman looks at the importance of database permissions and how you can use internal SQL Server system views to easily which users have access on your system.

PURPOSE The purpose of this policy from TechRepublic Premium is to provide guidelines for developing mobile applications from a security, procedural and best practices standpoint. While it contains technical guidelines, it is not intended to serve as a programming guide but as a framework for operations. This policy can be customized as needed to fit ...

PURPOSE This checklist from TechRepublic Premium provides a method for auditing and documenting a client site and assembling an inventory of systems and software, as well as giving you a framework for developing recommendations, applying costs to them, and storing all that information in one file. Tracking client contact details, circuit information, network equipment, cloud ...

PURPOSE Recruiting a community engagement manager with the right combination of experience and communication skills will require a comprehensive screening process. This hiring kit from TechRepublic Premium provides a flexible framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY ...