Additional Articles

Freeware : DDL Source Safe Archive Utility

by Additional Articles

SQLServerCentral.com

If your shop is even close to the typical Micosoft SQL Server environment there are several people that can (and do!) make changes to the production environment, a change management system is in place, that change management system uses Source Safe to store database scripts, and what's in Source Safe does not match what's on the SQL Server. This utility by Bill Wunder will archive your SQL scripts and DDL into Source Safe easily and efficiently. All for the price of $0 (yes, free!).

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-02-26

296 reads

Discuss

Free Utility : EnforcePass

by Additional Articles

SQLServerCentral.com

Administration

These sets of scripts will add minimum password enforcement when a login is created or its password changes.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-02-14

179 reads

Discuss

VSLive Interview with Tom Rizzo and David Campbell

by Additional Articles

SQLServerCentral

An interview where they discuss their data strategy and integration with Visual Studio .Net

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-02-12

3,288 reads

Discuss

What's ROI Got to Do With It?

by Additional Articles

SQLServerCentral

Miscellaneous

This article by Simon Galbraith (from Red-Gate Software, one of our valued advertisers!) in .Net Magazine talks about how to calculate ROI when evaluating software purchases.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-02-03

1,058 reads

Discuss

Freeware: Terminator Opens Gigabyte Files Easily

by Additional Articles

SQLServerCentral.com

Ever tried to open 1 Gig ASCII file with Notepad? WordPad? Do you remember ASCII codes of Tab and Carriage Return? Enter Terminator; huge ASCII file viewer and BCP helper. Terminator reads top 10 (and more if asked) records of ASCII file of any size. It detects record terminators and calculates current cursor position (field offset) and length of selected area (field length). Best of all, it's free!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-01-29

125 reads

Discuss

How to move SQL Server from one computer to another?

by Additional Articles

Other

Moving SQL Server from one computer to another is not a very difficult thing to do, but it often stumps newbie DBAs. Of course, it needs careful planning to ensure that the SQL Server is moved completely and properly to the new machine, and with a minimal downtime and no data loss. This article introduces you to a couple of methods you can employ to move/migrate SQL Server from one computer to another.

2003-01-24

107 reads

Discuss

Document Your Tables with SchemaToDoc

by Additional Articles

Other

Miscellaneous

This application will convert your schema into a standard Word document. Try before you buy, they have two versions - both under $200.

2003-01-23

623 reads

Discuss

Auditing Your SQL Server Environment Part I

by Additional Articles

Other

This article is the first of a series that I plan on writing and placing on my website to help other DBAs in auditing a new SQL Server environment. This article deals with determing which SQL Server logins have weak passwords, with the definition of weak being, no password, password the same as the login name or having a password of only one character.The stored procedure used for this article is embedded in the article and it has been submitted as a independent script named spAuditPasswords.

2003-01-21

66 reads